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_MR_EFFECTIVITY_PVT dependencies on FND_API

Line 20: p_effectivity_rec.name <> FND_API.G_MISS_CHAR ) THEN

16: l_record_identifier VARCHAR2(2000) := '';
17:
18: BEGIN
19: IF ( p_effectivity_rec.name IS NOT NULL AND
20: p_effectivity_rec.name <> FND_API.G_MISS_CHAR ) THEN
21: l_record_identifier := p_effectivity_rec.name;
22: END IF;
23:
24: l_record_identifier := l_record_identifier || ' - ';

Line 27: p_effectivity_rec.item_number <> FND_API.G_MISS_CHAR ) THEN

23:
24: l_record_identifier := l_record_identifier || ' - ';
25:
26: IF ( p_effectivity_rec.item_number IS NOT NULL AND
27: p_effectivity_rec.item_number <> FND_API.G_MISS_CHAR ) THEN
28: l_record_identifier := l_record_identifier || p_effectivity_rec.item_number;
29: END IF;
30:
31: IF ( G_APPLN_USAGE = 'PM' ) THEN

Line 38: p_effectivity_rec.position_ref_meaning <> FND_API.G_MISS_CHAR ) THEN

34:
35: l_record_identifier := l_record_identifier || ' - ';
36:
37: IF ( p_effectivity_rec.position_ref_meaning IS NOT NULL AND
38: p_effectivity_rec.position_ref_meaning <> FND_API.G_MISS_CHAR ) THEN
39: l_record_identifier := l_record_identifier || p_effectivity_rec.position_ref_meaning;
40: END IF;
41:
42: l_record_identifier := l_record_identifier || ' - ';

Line 45: p_effectivity_rec.position_item_number <> FND_API.G_MISS_CHAR ) THEN

41:
42: l_record_identifier := l_record_identifier || ' - ';
43:
44: IF ( p_effectivity_rec.position_item_number IS NOT NULL AND
45: p_effectivity_rec.position_item_number <> FND_API.G_MISS_CHAR ) THEN
46: l_record_identifier := l_record_identifier || p_effectivity_rec.position_item_number;
47: END IF;
48:
49: l_record_identifier := l_record_identifier || ' - ';

Line 52: p_effectivity_rec.pc_node_name <> FND_API.G_MISS_CHAR ) THEN

48:
49: l_record_identifier := l_record_identifier || ' - ';
50:
51: IF ( p_effectivity_rec.pc_node_name IS NOT NULL AND
52: p_effectivity_rec.pc_node_name <> FND_API.G_MISS_CHAR ) THEN
53: l_record_identifier := l_record_identifier || p_effectivity_rec.pc_node_name;
54: END IF;
55:
56: --sansatpa - added for fleet name

Line 60: p_effectivity_rec.FLEET_NAME <> FND_API.G_MISS_CHAR ) THEN

56: --sansatpa - added for fleet name
57: l_record_identifier := l_record_identifier || ' - ';
58:
59: IF ( p_effectivity_rec.FLEET_NAME IS NOT NULL AND
60: p_effectivity_rec.FLEET_NAME <> FND_API.G_MISS_CHAR ) THEN
61: l_record_identifier := l_record_identifier || p_effectivity_rec.FLEET_NAME;
62: END IF;
63:
64: RETURN l_record_identifier;

Line 85: x_return_status := FND_API.G_RET_STS_SUCCESS;

81: l_mr_type_code VARCHAR2(30);
82: l_pm_install_flag VARCHAR2(1);
83:
84: BEGIN
85: x_return_status := FND_API.G_RET_STS_SUCCESS;
86:
87: -- Check if a valid value is passed in p_mr_header_id
88:
89: IF ( p_mr_header_id = FND_API.G_MISS_NUM OR

Line 89: IF ( p_mr_header_id = FND_API.G_MISS_NUM OR

85: x_return_status := FND_API.G_RET_STS_SUCCESS;
86:
87: -- Check if a valid value is passed in p_mr_header_id
88:
89: IF ( p_mr_header_id = FND_API.G_MISS_NUM OR
90: p_mr_header_id IS NULL ) THEN
91: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_MR_HEADER_ID_NULL' );
92: FND_MSG_PUB.add;
93: x_return_status := FND_API.G_RET_STS_ERROR;

Line 93: x_return_status := FND_API.G_RET_STS_ERROR;

89: IF ( p_mr_header_id = FND_API.G_MISS_NUM OR
90: p_mr_header_id IS NULL ) THEN
91: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_MR_HEADER_ID_NULL' );
92: FND_MSG_PUB.add;
93: x_return_status := FND_API.G_RET_STS_ERROR;
94: RETURN;
95: IF G_DEBUG = 'Y' THEN
96: AHL_DEBUG_PUB.debug('MR_HEADER_ID is null to validate_api_inputs' );
97: END IF;

Line 121: x_return_status := FND_API.G_RET_STS_ERROR;

117: l_mr_status_code :=AHL_FMP_COMMON_PVT.check_mr_status(p_mr_header_id);
118: IF l_mr_status_code IS NULL THEN
119: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVALID_MR' );
120: FND_MSG_PUB.add;
121: x_return_status := FND_API.G_RET_STS_ERROR;
122: RETURN;
123: END IF;
124:
125: --check if mr type.

Line 162: x_return_status := FND_API.G_RET_STS_ERROR;

158: IF ( p_effectivity_tbl.count < 1 ) THEN
159: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
160: FND_MESSAGE.set_token( 'PROCEDURE', G_PKG_NAME || '.' || G_API_NAME );
161: FND_MSG_PUB.add;
162: x_return_status := FND_API.G_RET_STS_ERROR;
163: RETURN;
164: END IF;
165:
166: FOR i IN 1..p_effectivity_tbl.count LOOP

Line 176: x_return_status := FND_API.G_RET_STS_ERROR;

172: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML' );
173: FND_MESSAGE.set_token( 'FIELD', p_effectivity_tbl(i).dml_operation );
174: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );
175: FND_MSG_PUB.add;
176: x_return_status := FND_API.G_RET_STS_ERROR;
177: END IF;
178:
179: IF ( l_pm_install_flag = 'Y' AND
180: p_effectivity_tbl(i).dml_operation = 'D' AND

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

187: x_msg_data => l_error_code,
188: p_effectivity_id => p_effectivity_tbl(i).MR_EFFECTIVITY_ID,
189: p_eff_obj_version => p_effectivity_tbl(i).OBJECT_VERSION_NUMBER
190: );
191: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
192: FND_MESSAGE.set_name( 'AHL', l_error_code );
193: FND_MSG_PUB.add;
194: x_return_status := FND_API.G_RET_STS_ERROR;
195: RETURN;

Line 194: x_return_status := FND_API.G_RET_STS_ERROR;

190: );
191: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
192: FND_MESSAGE.set_name( 'AHL', l_error_code );
193: FND_MSG_PUB.add;
194: x_return_status := FND_API.G_RET_STS_ERROR;
195: RETURN;
196: END IF;
197: END IF;
198:

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

209: p_effectivity_id => p_effectivity_tbl(i).MR_EFFECTIVITY_ID,
210: p_eff_obj_version => p_effectivity_tbl(i).OBJECT_VERSION_NUMBER
211: );
212:
213: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
214: FND_MESSAGE.set_name( 'AHL', l_error_code );
215: FND_MSG_PUB.add;
216: x_return_status := FND_API.G_RET_STS_ERROR;
217: RETURN;

Line 216: x_return_status := FND_API.G_RET_STS_ERROR;

212:
213: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
214: FND_MESSAGE.set_name( 'AHL', l_error_code );
215: FND_MSG_PUB.add;
216: x_return_status := FND_API.G_RET_STS_ERROR;
217: RETURN;
218: END IF;
219: END IF;
220:

Line 229: x_return_status := FND_API.G_RET_STS_ERROR;

225: l_mr_status_code = 'COMPLETE') THEN
226: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVALID_UPDATE' );
227: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );
228: FND_MSG_PUB.add;
229: x_return_status := FND_API.G_RET_STS_ERROR;
230: RETURN;
231: END IF;
232:
233:

Line 239: p_effectivity_tbl(i).relationship_id <> FND_API.G_MISS_NUM ) OR

235: IF ( P_APPLN_USAGE = 'PM' AND
236: p_effectivity_tbl(i).dml_operation <> 'D' ) THEN
237:
238: IF ( ( p_effectivity_tbl(i).relationship_id IS NOT NULL AND
239: p_effectivity_tbl(i).relationship_id <> FND_API.G_MISS_NUM ) OR
240: ( p_effectivity_tbl(i).position_ref_meaning IS NOT NULL AND
241: p_effectivity_tbl(i).position_ref_meaning <> FND_API.G_MISS_CHAR ) ) THEN
242: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PM_INPUT_MC_POS' );
243: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );

Line 241: p_effectivity_tbl(i).position_ref_meaning <> FND_API.G_MISS_CHAR ) ) THEN

237:
238: IF ( ( p_effectivity_tbl(i).relationship_id IS NOT NULL AND
239: p_effectivity_tbl(i).relationship_id <> FND_API.G_MISS_NUM ) OR
240: ( p_effectivity_tbl(i).position_ref_meaning IS NOT NULL AND
241: p_effectivity_tbl(i).position_ref_meaning <> FND_API.G_MISS_CHAR ) ) THEN
242: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PM_INPUT_MC_POS' );
243: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );
244: FND_MSG_PUB.add;
245: x_return_status := FND_API.G_RET_STS_ERROR;

Line 245: x_return_status := FND_API.G_RET_STS_ERROR;

241: p_effectivity_tbl(i).position_ref_meaning <> FND_API.G_MISS_CHAR ) ) THEN
242: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PM_INPUT_MC_POS' );
243: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );
244: FND_MSG_PUB.add;
245: x_return_status := FND_API.G_RET_STS_ERROR;
246: END IF;
247:
248: IF ( ( p_effectivity_tbl(i).position_inventory_item_id IS NOT NULL AND
249: p_effectivity_tbl(i).position_inventory_item_id <> FND_API.G_MISS_NUM ) OR

Line 249: p_effectivity_tbl(i).position_inventory_item_id <> FND_API.G_MISS_NUM ) OR

245: x_return_status := FND_API.G_RET_STS_ERROR;
246: END IF;
247:
248: IF ( ( p_effectivity_tbl(i).position_inventory_item_id IS NOT NULL AND
249: p_effectivity_tbl(i).position_inventory_item_id <> FND_API.G_MISS_NUM ) OR
250: ( p_effectivity_tbl(i).position_item_number IS NOT NULL AND
251: p_effectivity_tbl(i).position_item_number <> FND_API.G_MISS_CHAR ) ) THEN
252: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PM_INPUT_MC_POS_ITEM' );
253: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );

Line 251: p_effectivity_tbl(i).position_item_number <> FND_API.G_MISS_CHAR ) ) THEN

247:
248: IF ( ( p_effectivity_tbl(i).position_inventory_item_id IS NOT NULL AND
249: p_effectivity_tbl(i).position_inventory_item_id <> FND_API.G_MISS_NUM ) OR
250: ( p_effectivity_tbl(i).position_item_number IS NOT NULL AND
251: p_effectivity_tbl(i).position_item_number <> FND_API.G_MISS_CHAR ) ) THEN
252: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PM_INPUT_MC_POS_ITEM' );
253: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );
254: FND_MSG_PUB.add;
255: x_return_status := FND_API.G_RET_STS_ERROR;

Line 255: x_return_status := FND_API.G_RET_STS_ERROR;

251: p_effectivity_tbl(i).position_item_number <> FND_API.G_MISS_CHAR ) ) THEN
252: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PM_INPUT_MC_POS_ITEM' );
253: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );
254: FND_MSG_PUB.add;
255: x_return_status := FND_API.G_RET_STS_ERROR;
256: END IF;
257:
258: IF ( ( p_effectivity_tbl(i).pc_node_id IS NOT NULL AND
259: p_effectivity_tbl(i).pc_node_id <> FND_API.G_MISS_NUM ) OR

Line 259: p_effectivity_tbl(i).pc_node_id <> FND_API.G_MISS_NUM ) OR

255: x_return_status := FND_API.G_RET_STS_ERROR;
256: END IF;
257:
258: IF ( ( p_effectivity_tbl(i).pc_node_id IS NOT NULL AND
259: p_effectivity_tbl(i).pc_node_id <> FND_API.G_MISS_NUM ) OR
260: ( p_effectivity_tbl(i).pc_node_name IS NOT NULL AND
261: p_effectivity_tbl(i).pc_node_name <> FND_API.G_MISS_CHAR ) ) THEN
262: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PM_INPUT_PC_NODE' );
263: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );

Line 261: p_effectivity_tbl(i).pc_node_name <> FND_API.G_MISS_CHAR ) ) THEN

257:
258: IF ( ( p_effectivity_tbl(i).pc_node_id IS NOT NULL AND
259: p_effectivity_tbl(i).pc_node_id <> FND_API.G_MISS_NUM ) OR
260: ( p_effectivity_tbl(i).pc_node_name IS NOT NULL AND
261: p_effectivity_tbl(i).pc_node_name <> FND_API.G_MISS_CHAR ) ) THEN
262: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PM_INPUT_PC_NODE' );
263: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );
264: FND_MSG_PUB.add;
265: x_return_status := FND_API.G_RET_STS_ERROR;

Line 265: x_return_status := FND_API.G_RET_STS_ERROR;

261: p_effectivity_tbl(i).pc_node_name <> FND_API.G_MISS_CHAR ) ) THEN
262: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PM_INPUT_PC_NODE' );
263: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );
264: FND_MSG_PUB.add;
265: x_return_status := FND_API.G_RET_STS_ERROR;
266: END IF;
267:
268: END IF;
269:

Line 285: ELSIF ( p_x_effectivity_rec.item_number = FND_API.G_MISS_CHAR ) THEN

281: BEGIN
282: /*
283: IF ( p_x_effectivity_rec.item_number IS NULL ) THEN
284: p_x_effectivity_rec.inventory_item_id := NULL;
285: ELSIF ( p_x_effectivity_rec.item_number = FND_API.G_MISS_CHAR ) THEN
286: p_x_effectivity_rec.inventory_item_id := FND_API.G_MISS_NUM;
287: END IF;
288: */
289: IF ( p_x_effectivity_rec.position_ref_meaning IS NULL ) THEN

Line 286: p_x_effectivity_rec.inventory_item_id := FND_API.G_MISS_NUM;

282: /*
283: IF ( p_x_effectivity_rec.item_number IS NULL ) THEN
284: p_x_effectivity_rec.inventory_item_id := NULL;
285: ELSIF ( p_x_effectivity_rec.item_number = FND_API.G_MISS_CHAR ) THEN
286: p_x_effectivity_rec.inventory_item_id := FND_API.G_MISS_NUM;
287: END IF;
288: */
289: IF ( p_x_effectivity_rec.position_ref_meaning IS NULL ) THEN
290: p_x_effectivity_rec.relationship_id := NULL;

Line 291: ELSIF ( p_x_effectivity_rec.position_ref_meaning = FND_API.G_MISS_CHAR ) THEN

287: END IF;
288: */
289: IF ( p_x_effectivity_rec.position_ref_meaning IS NULL ) THEN
290: p_x_effectivity_rec.relationship_id := NULL;
291: ELSIF ( p_x_effectivity_rec.position_ref_meaning = FND_API.G_MISS_CHAR ) THEN
292: p_x_effectivity_rec.relationship_id := FND_API.G_MISS_NUM;
293: END IF;
294:
295: IF ( p_x_effectivity_rec.position_item_number IS NULL ) THEN

Line 292: p_x_effectivity_rec.relationship_id := FND_API.G_MISS_NUM;

288: */
289: IF ( p_x_effectivity_rec.position_ref_meaning IS NULL ) THEN
290: p_x_effectivity_rec.relationship_id := NULL;
291: ELSIF ( p_x_effectivity_rec.position_ref_meaning = FND_API.G_MISS_CHAR ) THEN
292: p_x_effectivity_rec.relationship_id := FND_API.G_MISS_NUM;
293: END IF;
294:
295: IF ( p_x_effectivity_rec.position_item_number IS NULL ) THEN
296: p_x_effectivity_rec.position_inventory_item_id := NULL;

Line 297: ELSIF ( p_x_effectivity_rec.position_item_number = FND_API.G_MISS_CHAR ) THEN

293: END IF;
294:
295: IF ( p_x_effectivity_rec.position_item_number IS NULL ) THEN
296: p_x_effectivity_rec.position_inventory_item_id := NULL;
297: ELSIF ( p_x_effectivity_rec.position_item_number = FND_API.G_MISS_CHAR ) THEN
298: p_x_effectivity_rec.position_inventory_item_id := FND_API.G_MISS_NUM;
299: END IF;
300:
301: IF ( p_x_effectivity_rec.pc_node_name IS NULL ) THEN

Line 298: p_x_effectivity_rec.position_inventory_item_id := FND_API.G_MISS_NUM;

294:
295: IF ( p_x_effectivity_rec.position_item_number IS NULL ) THEN
296: p_x_effectivity_rec.position_inventory_item_id := NULL;
297: ELSIF ( p_x_effectivity_rec.position_item_number = FND_API.G_MISS_CHAR ) THEN
298: p_x_effectivity_rec.position_inventory_item_id := FND_API.G_MISS_NUM;
299: END IF;
300:
301: IF ( p_x_effectivity_rec.pc_node_name IS NULL ) THEN
302: p_x_effectivity_rec.pc_node_id := NULL;

Line 303: ELSIF ( p_x_effectivity_rec.pc_node_name = FND_API.G_MISS_CHAR ) THEN

299: END IF;
300:
301: IF ( p_x_effectivity_rec.pc_node_name IS NULL ) THEN
302: p_x_effectivity_rec.pc_node_id := NULL;
303: ELSIF ( p_x_effectivity_rec.pc_node_name = FND_API.G_MISS_CHAR ) THEN
304: p_x_effectivity_rec.pc_node_id := FND_API.G_MISS_NUM;
305: END IF;
306:
307: --sansatpa - added for fleet name and id

Line 304: p_x_effectivity_rec.pc_node_id := FND_API.G_MISS_NUM;

300:
301: IF ( p_x_effectivity_rec.pc_node_name IS NULL ) THEN
302: p_x_effectivity_rec.pc_node_id := NULL;
303: ELSIF ( p_x_effectivity_rec.pc_node_name = FND_API.G_MISS_CHAR ) THEN
304: p_x_effectivity_rec.pc_node_id := FND_API.G_MISS_NUM;
305: END IF;
306:
307: --sansatpa - added for fleet name and id
308: IF ( p_x_effectivity_rec.FLEET_NAME IS NULL ) THEN

Line 310: ELSIF ( p_x_effectivity_rec.FLEET_NAME = FND_API.G_MISS_CHAR ) THEN

306:
307: --sansatpa - added for fleet name and id
308: IF ( p_x_effectivity_rec.FLEET_NAME IS NULL ) THEN
309: p_x_effectivity_rec.FLEET_HEADER_ID := NULL;
310: ELSIF ( p_x_effectivity_rec.FLEET_NAME = FND_API.G_MISS_CHAR ) THEN
311: p_x_effectivity_rec.FLEET_HEADER_ID := FND_API.G_MISS_NUM;
312: END IF;
313:
314: END clear_lov_attribute_ids;

Line 311: p_x_effectivity_rec.FLEET_HEADER_ID := FND_API.G_MISS_NUM;

307: --sansatpa - added for fleet name and id
308: IF ( p_x_effectivity_rec.FLEET_NAME IS NULL ) THEN
309: p_x_effectivity_rec.FLEET_HEADER_ID := NULL;
310: ELSIF ( p_x_effectivity_rec.FLEET_NAME = FND_API.G_MISS_CHAR ) THEN
311: p_x_effectivity_rec.FLEET_HEADER_ID := FND_API.G_MISS_NUM;
312: END IF;
313:
314: END clear_lov_attribute_ids;
315:

Line 328: x_return_status := FND_API.G_RET_STS_SUCCESS;

324: l_return_status VARCHAR2(1);
325: l_msg_data VARCHAR2(2000);
326:
327: BEGIN
328: x_return_status := FND_API.G_RET_STS_SUCCESS;
329:
330: -- Convert / Validate Item
331: IF ( ( p_x_effectivity_rec.inventory_item_id IS NOT NULL AND
332: p_x_effectivity_rec.inventory_item_id <> FND_API.G_MISS_NUM ) OR

Line 332: p_x_effectivity_rec.inventory_item_id <> FND_API.G_MISS_NUM ) OR

328: x_return_status := FND_API.G_RET_STS_SUCCESS;
329:
330: -- Convert / Validate Item
331: IF ( ( p_x_effectivity_rec.inventory_item_id IS NOT NULL AND
332: p_x_effectivity_rec.inventory_item_id <> FND_API.G_MISS_NUM ) OR
333: ( p_x_effectivity_rec.item_number IS NOT NULL AND
334: p_x_effectivity_rec.item_number <> FND_API.G_MISS_CHAR ) ) THEN
335:
336: AHL_FMP_COMMON_PVT.validate_item

Line 334: p_x_effectivity_rec.item_number <> FND_API.G_MISS_CHAR ) ) THEN

330: -- Convert / Validate Item
331: IF ( ( p_x_effectivity_rec.inventory_item_id IS NOT NULL AND
332: p_x_effectivity_rec.inventory_item_id <> FND_API.G_MISS_NUM ) OR
333: ( p_x_effectivity_rec.item_number IS NOT NULL AND
334: p_x_effectivity_rec.item_number <> FND_API.G_MISS_CHAR ) ) THEN
335:
336: AHL_FMP_COMMON_PVT.validate_item
337: (
338: x_return_status => l_return_status,

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

340: p_item_number => p_x_effectivity_rec.item_number,
341: p_x_inventory_item_id => p_x_effectivity_rec.inventory_item_id
342: );
343:
344: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
345: FND_MESSAGE.set_name( 'AHL', l_msg_data );
346:
347: IF ( p_x_effectivity_rec.item_number IS NULL OR
348: p_x_effectivity_rec.item_number = FND_API.G_MISS_CHAR ) THEN

Line 348: p_x_effectivity_rec.item_number = FND_API.G_MISS_CHAR ) THEN

344: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
345: FND_MESSAGE.set_name( 'AHL', l_msg_data );
346:
347: IF ( p_x_effectivity_rec.item_number IS NULL OR
348: p_x_effectivity_rec.item_number = FND_API.G_MISS_CHAR ) THEN
349: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_rec.inventory_item_id ) );
350: ELSE
351: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.item_number );
352: END IF;

Line 362: p_x_effectivity_rec.relationship_id <> FND_API.G_MISS_NUM ) OR

358: END IF;
359:
360: -- Convert / Validate Master Configuration Position
361: IF ( ( p_x_effectivity_rec.relationship_id IS NOT NULL AND
362: p_x_effectivity_rec.relationship_id <> FND_API.G_MISS_NUM ) OR
363: ( p_x_effectivity_rec.position_ref_meaning IS NOT NULL AND
364: p_x_effectivity_rec.position_ref_meaning <> FND_API.G_MISS_CHAR ) )
365: THEN
366:

Line 364: p_x_effectivity_rec.position_ref_meaning <> FND_API.G_MISS_CHAR ) )

360: -- Convert / Validate Master Configuration Position
361: IF ( ( p_x_effectivity_rec.relationship_id IS NOT NULL AND
362: p_x_effectivity_rec.relationship_id <> FND_API.G_MISS_NUM ) OR
363: ( p_x_effectivity_rec.position_ref_meaning IS NOT NULL AND
364: p_x_effectivity_rec.position_ref_meaning <> FND_API.G_MISS_CHAR ) )
365: THEN
366:
367: AHL_FMP_COMMON_PVT.validate_position
368: (

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

371: p_position_ref_meaning => p_x_effectivity_rec.position_ref_meaning,
372: p_x_relationship_id => p_x_effectivity_rec.relationship_id
373: );
374:
375: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
376: FND_MESSAGE.set_name( 'AHL', l_msg_data );
377:
378: IF ( p_x_effectivity_rec.position_ref_meaning IS NULL OR
379: p_x_effectivity_rec.position_ref_meaning = FND_API.G_MISS_CHAR ) THEN

Line 379: p_x_effectivity_rec.position_ref_meaning = FND_API.G_MISS_CHAR ) THEN

375: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
376: FND_MESSAGE.set_name( 'AHL', l_msg_data );
377:
378: IF ( p_x_effectivity_rec.position_ref_meaning IS NULL OR
379: p_x_effectivity_rec.position_ref_meaning = FND_API.G_MISS_CHAR ) THEN
380: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_rec.relationship_id ) );
381: ELSE
382: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.position_ref_meaning );
383: END IF;

Line 393: p_x_effectivity_rec.position_inventory_item_id <> FND_API.G_MISS_NUM )

389: END IF;
390:
391: -- Convert / Validate Master Configuration Item
392: IF ( ( p_x_effectivity_rec.position_inventory_item_id IS NOT NULL AND
393: p_x_effectivity_rec.position_inventory_item_id <> FND_API.G_MISS_NUM )
394: OR
395: ( p_x_effectivity_rec.position_item_number IS NOT NULL AND
396: p_x_effectivity_rec.position_item_number <> FND_API.G_MISS_CHAR ) )
397: THEN

Line 396: p_x_effectivity_rec.position_item_number <> FND_API.G_MISS_CHAR ) )

392: IF ( ( p_x_effectivity_rec.position_inventory_item_id IS NOT NULL AND
393: p_x_effectivity_rec.position_inventory_item_id <> FND_API.G_MISS_NUM )
394: OR
395: ( p_x_effectivity_rec.position_item_number IS NOT NULL AND
396: p_x_effectivity_rec.position_item_number <> FND_API.G_MISS_CHAR ) )
397: THEN
398:
399: AHL_FMP_COMMON_PVT.validate_item
400: (

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

403: p_item_number => p_x_effectivity_rec.position_item_number,
404: p_x_inventory_item_id => p_x_effectivity_rec.position_inventory_item_id
405: );
406:
407: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
408: FND_MESSAGE.set_name( 'AHL', l_msg_data );
409:
410: IF ( p_x_effectivity_rec.position_item_number IS NULL OR
411: p_x_effectivity_rec.position_item_number = FND_API.G_MISS_CHAR ) THEN

Line 411: p_x_effectivity_rec.position_item_number = FND_API.G_MISS_CHAR ) THEN

407: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
408: FND_MESSAGE.set_name( 'AHL', l_msg_data );
409:
410: IF ( p_x_effectivity_rec.position_item_number IS NULL OR
411: p_x_effectivity_rec.position_item_number = FND_API.G_MISS_CHAR ) THEN
412: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_rec.position_inventory_item_id ) );
413: ELSE
414: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.position_item_number );
415: END IF;

Line 425: p_x_effectivity_rec.pc_node_id <> FND_API.G_MISS_NUM ) OR

421: END IF;
422:
423: -- Convert / Validate Product Classification Node
424: IF ( ( p_x_effectivity_rec.pc_node_id IS NOT NULL AND
425: p_x_effectivity_rec.pc_node_id <> FND_API.G_MISS_NUM ) OR
426: ( p_x_effectivity_rec.pc_node_name IS NOT NULL AND
427: p_x_effectivity_rec.pc_node_name <> FND_API.G_MISS_CHAR ) ) THEN
428:
429: AHL_FMP_COMMON_PVT.validate_pc_node

Line 427: p_x_effectivity_rec.pc_node_name <> FND_API.G_MISS_CHAR ) ) THEN

423: -- Convert / Validate Product Classification Node
424: IF ( ( p_x_effectivity_rec.pc_node_id IS NOT NULL AND
425: p_x_effectivity_rec.pc_node_id <> FND_API.G_MISS_NUM ) OR
426: ( p_x_effectivity_rec.pc_node_name IS NOT NULL AND
427: p_x_effectivity_rec.pc_node_name <> FND_API.G_MISS_CHAR ) ) THEN
428:
429: AHL_FMP_COMMON_PVT.validate_pc_node
430: (
431: x_return_status => l_return_status,

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

433: p_pc_node_name => p_x_effectivity_rec.pc_node_name,
434: p_x_pc_node_id => p_x_effectivity_rec.pc_node_id
435: );
436:
437: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
438: FND_MESSAGE.set_name( 'AHL', l_msg_data );
439:
440: IF ( p_x_effectivity_rec.pc_node_name IS NULL OR
441: p_x_effectivity_rec.pc_node_name = FND_API.G_MISS_CHAR ) THEN

Line 441: p_x_effectivity_rec.pc_node_name = FND_API.G_MISS_CHAR ) THEN

437: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
438: FND_MESSAGE.set_name( 'AHL', l_msg_data );
439:
440: IF ( p_x_effectivity_rec.pc_node_name IS NULL OR
441: p_x_effectivity_rec.pc_node_name = FND_API.G_MISS_CHAR ) THEN
442: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_rec.pc_node_id ) );
443: ELSE
444: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.pc_node_name );
445: END IF;

Line 456: p_x_effectivity_rec.FLEET_HEADER_ID <> FND_API.G_MISS_NUM ) OR

452:
453:
454: -- sansatpa - Convert / Validate Fleet Node
455: IF ( ( p_x_effectivity_rec.FLEET_HEADER_ID IS NOT NULL AND
456: p_x_effectivity_rec.FLEET_HEADER_ID <> FND_API.G_MISS_NUM ) OR
457: ( p_x_effectivity_rec.FLEET_NAME IS NOT NULL AND
458: p_x_effectivity_rec.FLEET_NAME <> FND_API.G_MISS_CHAR ) ) THEN
459:
460: AHL_FMP_COMMON_PVT.validate_fleet_node

Line 458: p_x_effectivity_rec.FLEET_NAME <> FND_API.G_MISS_CHAR ) ) THEN

454: -- sansatpa - Convert / Validate Fleet Node
455: IF ( ( p_x_effectivity_rec.FLEET_HEADER_ID IS NOT NULL AND
456: p_x_effectivity_rec.FLEET_HEADER_ID <> FND_API.G_MISS_NUM ) OR
457: ( p_x_effectivity_rec.FLEET_NAME IS NOT NULL AND
458: p_x_effectivity_rec.FLEET_NAME <> FND_API.G_MISS_CHAR ) ) THEN
459:
460: AHL_FMP_COMMON_PVT.validate_fleet_node
461: (
462: x_return_status => l_return_status,

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

464: p_fleet_name => p_x_effectivity_rec.FLEET_NAME,
465: p_x_fleet_header_id => p_x_effectivity_rec.FLEET_HEADER_ID
466: );
467:
468: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
469: FND_MESSAGE.set_name( 'AHL', l_msg_data );
470:
471: IF ( p_x_effectivity_rec.FLEET_NAME IS NULL OR
472: p_x_effectivity_rec.FLEET_NAME = FND_API.G_MISS_CHAR ) THEN

Line 472: p_x_effectivity_rec.FLEET_NAME = FND_API.G_MISS_CHAR ) THEN

468: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
469: FND_MESSAGE.set_name( 'AHL', l_msg_data );
470:
471: IF ( p_x_effectivity_rec.FLEET_NAME IS NULL OR
472: p_x_effectivity_rec.FLEET_NAME = FND_API.G_MISS_CHAR ) THEN
473: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_rec.FLEET_HEADER_ID ) );
474: ELSE
475: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.FLEET_NAME );
476: END IF;

Line 517: IF ( p_x_effectivity_rec.inventory_item_id = FND_API.G_MISS_NUM ) THEN

513:
514: BEGIN
515:
516: -- Convert G_MISS values to NULL
517: IF ( p_x_effectivity_rec.inventory_item_id = FND_API.G_MISS_NUM ) THEN
518: p_x_effectivity_rec.inventory_item_id := null;
519: END IF;
520:
521: IF ( p_x_effectivity_rec.item_number = FND_API.G_MISS_CHAR ) THEN

Line 521: IF ( p_x_effectivity_rec.item_number = FND_API.G_MISS_CHAR ) THEN

517: IF ( p_x_effectivity_rec.inventory_item_id = FND_API.G_MISS_NUM ) THEN
518: p_x_effectivity_rec.inventory_item_id := null;
519: END IF;
520:
521: IF ( p_x_effectivity_rec.item_number = FND_API.G_MISS_CHAR ) THEN
522: p_x_effectivity_rec.item_number := null;
523: END IF;
524:
525: IF ( p_x_effectivity_rec.relationship_id = FND_API.G_MISS_NUM ) THEN

Line 525: IF ( p_x_effectivity_rec.relationship_id = FND_API.G_MISS_NUM ) THEN

521: IF ( p_x_effectivity_rec.item_number = FND_API.G_MISS_CHAR ) THEN
522: p_x_effectivity_rec.item_number := null;
523: END IF;
524:
525: IF ( p_x_effectivity_rec.relationship_id = FND_API.G_MISS_NUM ) THEN
526: p_x_effectivity_rec.relationship_id := null;
527: END IF;
528:
529: IF ( p_x_effectivity_rec.position_ref_meaning = FND_API.G_MISS_CHAR ) THEN

Line 529: IF ( p_x_effectivity_rec.position_ref_meaning = FND_API.G_MISS_CHAR ) THEN

525: IF ( p_x_effectivity_rec.relationship_id = FND_API.G_MISS_NUM ) THEN
526: p_x_effectivity_rec.relationship_id := null;
527: END IF;
528:
529: IF ( p_x_effectivity_rec.position_ref_meaning = FND_API.G_MISS_CHAR ) THEN
530: p_x_effectivity_rec.position_ref_meaning := null;
531: END IF;
532:
533: IF ( p_x_effectivity_rec.position_inventory_item_id = FND_API.G_MISS_NUM ) THEN

Line 533: IF ( p_x_effectivity_rec.position_inventory_item_id = FND_API.G_MISS_NUM ) THEN

529: IF ( p_x_effectivity_rec.position_ref_meaning = FND_API.G_MISS_CHAR ) THEN
530: p_x_effectivity_rec.position_ref_meaning := null;
531: END IF;
532:
533: IF ( p_x_effectivity_rec.position_inventory_item_id = FND_API.G_MISS_NUM ) THEN
534: p_x_effectivity_rec.position_inventory_item_id := null;
535: END IF;
536:
537: IF ( p_x_effectivity_rec.position_item_number = FND_API.G_MISS_CHAR ) THEN

Line 537: IF ( p_x_effectivity_rec.position_item_number = FND_API.G_MISS_CHAR ) THEN

533: IF ( p_x_effectivity_rec.position_inventory_item_id = FND_API.G_MISS_NUM ) THEN
534: p_x_effectivity_rec.position_inventory_item_id := null;
535: END IF;
536:
537: IF ( p_x_effectivity_rec.position_item_number = FND_API.G_MISS_CHAR ) THEN
538: p_x_effectivity_rec.position_item_number := null;
539: END IF;
540:
541: IF ( p_x_effectivity_rec.pc_node_id = FND_API.G_MISS_NUM ) THEN

Line 541: IF ( p_x_effectivity_rec.pc_node_id = FND_API.G_MISS_NUM ) THEN

537: IF ( p_x_effectivity_rec.position_item_number = FND_API.G_MISS_CHAR ) THEN
538: p_x_effectivity_rec.position_item_number := null;
539: END IF;
540:
541: IF ( p_x_effectivity_rec.pc_node_id = FND_API.G_MISS_NUM ) THEN
542: p_x_effectivity_rec.pc_node_id := null;
543: END IF;
544:
545: IF ( p_x_effectivity_rec.pc_node_name = FND_API.G_MISS_CHAR ) THEN

Line 545: IF ( p_x_effectivity_rec.pc_node_name = FND_API.G_MISS_CHAR ) THEN

541: IF ( p_x_effectivity_rec.pc_node_id = FND_API.G_MISS_NUM ) THEN
542: p_x_effectivity_rec.pc_node_id := null;
543: END IF;
544:
545: IF ( p_x_effectivity_rec.pc_node_name = FND_API.G_MISS_CHAR ) THEN
546: p_x_effectivity_rec.pc_node_name := null;
547: END IF;
548:
549: --SANSATPA - DEFAULT ATTRIBS FOR FLEET ID AND NAME

Line 550: IF ( p_x_effectivity_rec.FLEET_HEADER_ID = FND_API.G_MISS_NUM ) THEN

546: p_x_effectivity_rec.pc_node_name := null;
547: END IF;
548:
549: --SANSATPA - DEFAULT ATTRIBS FOR FLEET ID AND NAME
550: IF ( p_x_effectivity_rec.FLEET_HEADER_ID = FND_API.G_MISS_NUM ) THEN
551: p_x_effectivity_rec.FLEET_HEADER_ID := null;
552: END IF;
553:
554: IF ( p_x_effectivity_rec.FLEET_NAME = FND_API.G_MISS_CHAR ) THEN

Line 554: IF ( p_x_effectivity_rec.FLEET_NAME = FND_API.G_MISS_CHAR ) THEN

550: IF ( p_x_effectivity_rec.FLEET_HEADER_ID = FND_API.G_MISS_NUM ) THEN
551: p_x_effectivity_rec.FLEET_HEADER_ID := null;
552: END IF;
553:
554: IF ( p_x_effectivity_rec.FLEET_NAME = FND_API.G_MISS_CHAR ) THEN
555: p_x_effectivity_rec.FLEET_NAME := null;
556: END IF;
557:
558: IF ( p_x_effectivity_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN

Line 558: IF ( p_x_effectivity_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN

554: IF ( p_x_effectivity_rec.FLEET_NAME = FND_API.G_MISS_CHAR ) THEN
555: p_x_effectivity_rec.FLEET_NAME := null;
556: END IF;
557:
558: IF ( p_x_effectivity_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN
559: p_x_effectivity_rec.attribute_category := null;
560: END IF;
561:
562: IF ( p_x_effectivity_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN

Line 562: IF ( p_x_effectivity_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN

558: IF ( p_x_effectivity_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN
559: p_x_effectivity_rec.attribute_category := null;
560: END IF;
561:
562: IF ( p_x_effectivity_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN
563: p_x_effectivity_rec.attribute1 := null;
564: END IF;
565:
566: IF ( p_x_effectivity_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN

Line 566: IF ( p_x_effectivity_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN

562: IF ( p_x_effectivity_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN
563: p_x_effectivity_rec.attribute1 := null;
564: END IF;
565:
566: IF ( p_x_effectivity_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN
567: p_x_effectivity_rec.attribute2 := null;
568: END IF;
569:
570: IF ( p_x_effectivity_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN

Line 570: IF ( p_x_effectivity_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN

566: IF ( p_x_effectivity_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN
567: p_x_effectivity_rec.attribute2 := null;
568: END IF;
569:
570: IF ( p_x_effectivity_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN
571: p_x_effectivity_rec.attribute3 := null;
572: END IF;
573:
574: IF ( p_x_effectivity_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN

Line 574: IF ( p_x_effectivity_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN

570: IF ( p_x_effectivity_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN
571: p_x_effectivity_rec.attribute3 := null;
572: END IF;
573:
574: IF ( p_x_effectivity_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN
575: p_x_effectivity_rec.attribute4 := null;
576: END IF;
577:
578: IF ( p_x_effectivity_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN

Line 578: IF ( p_x_effectivity_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN

574: IF ( p_x_effectivity_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN
575: p_x_effectivity_rec.attribute4 := null;
576: END IF;
577:
578: IF ( p_x_effectivity_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN
579: p_x_effectivity_rec.attribute5 := null;
580: END IF;
581:
582: IF ( p_x_effectivity_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN

Line 582: IF ( p_x_effectivity_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN

578: IF ( p_x_effectivity_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN
579: p_x_effectivity_rec.attribute5 := null;
580: END IF;
581:
582: IF ( p_x_effectivity_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN
583: p_x_effectivity_rec.attribute6 := null;
584: END IF;
585:
586: IF ( p_x_effectivity_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN

Line 586: IF ( p_x_effectivity_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN

582: IF ( p_x_effectivity_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN
583: p_x_effectivity_rec.attribute6 := null;
584: END IF;
585:
586: IF ( p_x_effectivity_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN
587: p_x_effectivity_rec.attribute7 := null;
588: END IF;
589:
590: IF ( p_x_effectivity_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN

Line 590: IF ( p_x_effectivity_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN

586: IF ( p_x_effectivity_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN
587: p_x_effectivity_rec.attribute7 := null;
588: END IF;
589:
590: IF ( p_x_effectivity_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN
591: p_x_effectivity_rec.attribute8 := null;
592: END IF;
593:
594: IF ( p_x_effectivity_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN

Line 594: IF ( p_x_effectivity_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN

590: IF ( p_x_effectivity_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN
591: p_x_effectivity_rec.attribute8 := null;
592: END IF;
593:
594: IF ( p_x_effectivity_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN
595: p_x_effectivity_rec.attribute9 := null;
596: END IF;
597:
598: IF ( p_x_effectivity_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN

Line 598: IF ( p_x_effectivity_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN

594: IF ( p_x_effectivity_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN
595: p_x_effectivity_rec.attribute9 := null;
596: END IF;
597:
598: IF ( p_x_effectivity_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN
599: p_x_effectivity_rec.attribute10 := null;
600: END IF;
601:
602: IF ( p_x_effectivity_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN

Line 602: IF ( p_x_effectivity_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN

598: IF ( p_x_effectivity_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN
599: p_x_effectivity_rec.attribute10 := null;
600: END IF;
601:
602: IF ( p_x_effectivity_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN
603: p_x_effectivity_rec.attribute11 := null;
604: END IF;
605:
606: IF ( p_x_effectivity_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN

Line 606: IF ( p_x_effectivity_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN

602: IF ( p_x_effectivity_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN
603: p_x_effectivity_rec.attribute11 := null;
604: END IF;
605:
606: IF ( p_x_effectivity_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN
607: p_x_effectivity_rec.attribute12 := null;
608: END IF;
609:
610: IF ( p_x_effectivity_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN

Line 610: IF ( p_x_effectivity_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN

606: IF ( p_x_effectivity_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN
607: p_x_effectivity_rec.attribute12 := null;
608: END IF;
609:
610: IF ( p_x_effectivity_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN
611: p_x_effectivity_rec.attribute13 := null;
612: END IF;
613:
614: IF ( p_x_effectivity_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN

Line 614: IF ( p_x_effectivity_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN

610: IF ( p_x_effectivity_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN
611: p_x_effectivity_rec.attribute13 := null;
612: END IF;
613:
614: IF ( p_x_effectivity_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN
615: p_x_effectivity_rec.attribute14 := null;
616: END IF;
617:
618: IF ( p_x_effectivity_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN

Line 618: IF ( p_x_effectivity_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN

614: IF ( p_x_effectivity_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN
615: p_x_effectivity_rec.attribute14 := null;
616: END IF;
617:
618: IF ( p_x_effectivity_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN
619: p_x_effectivity_rec.attribute15 := null;
620: END IF;
621:
622: END default_missing_attributes;

Line 704: RAISE FND_API.G_EXC_ERROR;

700: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVALID_MR_EFF_REC' );
701: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_rec ) );
702: FND_MSG_PUB.add;
703: CLOSE get_old_rec;
704: RAISE FND_API.G_EXC_ERROR;
705: END IF;
706:
707: CLOSE get_old_rec;
708:

Line 714: IF ( p_x_effectivity_rec.inventory_item_id = FND_API.G_MISS_NUM ) THEN

710: IF ( p_x_effectivity_rec.name IS NULL ) THEN
711: p_x_effectivity_rec.name := l_old_effectivity_rec.name;
712: END IF;
713:
714: IF ( p_x_effectivity_rec.inventory_item_id = FND_API.G_MISS_NUM ) THEN
715: p_x_effectivity_rec.inventory_item_id := null;
716: ELSIF ( p_x_effectivity_rec.inventory_item_id IS NULL ) THEN
717: p_x_effectivity_rec.inventory_item_id := l_old_effectivity_rec.inventory_item_id;
718: END IF;

Line 720: IF ( p_x_effectivity_rec.item_number = FND_API.G_MISS_CHAR ) THEN

716: ELSIF ( p_x_effectivity_rec.inventory_item_id IS NULL ) THEN
717: p_x_effectivity_rec.inventory_item_id := l_old_effectivity_rec.inventory_item_id;
718: END IF;
719:
720: IF ( p_x_effectivity_rec.item_number = FND_API.G_MISS_CHAR ) THEN
721: p_x_effectivity_rec.item_number := null;
722: ELSIF ( p_x_effectivity_rec.item_number IS NULL ) THEN
723: p_x_effectivity_rec.item_number := l_old_effectivity_rec.item_number;
724: END IF;

Line 726: IF ( p_x_effectivity_rec.relationship_id = FND_API.G_MISS_NUM ) THEN

722: ELSIF ( p_x_effectivity_rec.item_number IS NULL ) THEN
723: p_x_effectivity_rec.item_number := l_old_effectivity_rec.item_number;
724: END IF;
725:
726: IF ( p_x_effectivity_rec.relationship_id = FND_API.G_MISS_NUM ) THEN
727: p_x_effectivity_rec.relationship_id := null;
728: ELSIF ( p_x_effectivity_rec.relationship_id IS NULL ) THEN
729: p_x_effectivity_rec.relationship_id := l_old_effectivity_rec.relationship_id;
730: END IF;

Line 732: IF ( p_x_effectivity_rec.position_ref_meaning = FND_API.G_MISS_CHAR ) THEN

728: ELSIF ( p_x_effectivity_rec.relationship_id IS NULL ) THEN
729: p_x_effectivity_rec.relationship_id := l_old_effectivity_rec.relationship_id;
730: END IF;
731:
732: IF ( p_x_effectivity_rec.position_ref_meaning = FND_API.G_MISS_CHAR ) THEN
733: p_x_effectivity_rec.position_ref_meaning := null;
734: ELSIF ( p_x_effectivity_rec.position_ref_meaning IS NULL ) THEN
735: p_x_effectivity_rec.position_ref_meaning := l_old_effectivity_rec.position_ref_meaning;
736: END IF;

Line 738: IF ( p_x_effectivity_rec.position_inventory_item_id = FND_API.G_MISS_NUM ) THEN

734: ELSIF ( p_x_effectivity_rec.position_ref_meaning IS NULL ) THEN
735: p_x_effectivity_rec.position_ref_meaning := l_old_effectivity_rec.position_ref_meaning;
736: END IF;
737:
738: IF ( p_x_effectivity_rec.position_inventory_item_id = FND_API.G_MISS_NUM ) THEN
739: p_x_effectivity_rec.position_inventory_item_id := null;
740: ELSIF ( p_x_effectivity_rec.position_inventory_item_id IS NULL ) THEN
741: p_x_effectivity_rec.position_inventory_item_id := l_old_effectivity_rec.position_inventory_item_id;
742: END IF;

Line 744: IF ( p_x_effectivity_rec.position_item_number = FND_API.G_MISS_CHAR ) THEN

740: ELSIF ( p_x_effectivity_rec.position_inventory_item_id IS NULL ) THEN
741: p_x_effectivity_rec.position_inventory_item_id := l_old_effectivity_rec.position_inventory_item_id;
742: END IF;
743:
744: IF ( p_x_effectivity_rec.position_item_number = FND_API.G_MISS_CHAR ) THEN
745: p_x_effectivity_rec.position_item_number := null;
746: ELSIF ( p_x_effectivity_rec.position_item_number IS NULL ) THEN
747: p_x_effectivity_rec.position_item_number := l_old_effectivity_rec.position_item_number;
748: END IF;

Line 750: IF ( p_x_effectivity_rec.pc_node_id = FND_API.G_MISS_NUM ) THEN

746: ELSIF ( p_x_effectivity_rec.position_item_number IS NULL ) THEN
747: p_x_effectivity_rec.position_item_number := l_old_effectivity_rec.position_item_number;
748: END IF;
749:
750: IF ( p_x_effectivity_rec.pc_node_id = FND_API.G_MISS_NUM ) THEN
751: p_x_effectivity_rec.pc_node_id := null;
752: ELSIF ( p_x_effectivity_rec.pc_node_id IS NULL ) THEN
753: p_x_effectivity_rec.pc_node_id := l_old_effectivity_rec.pc_node_id;
754: END IF;

Line 756: IF ( p_x_effectivity_rec.pc_node_name = FND_API.G_MISS_CHAR ) THEN

752: ELSIF ( p_x_effectivity_rec.pc_node_id IS NULL ) THEN
753: p_x_effectivity_rec.pc_node_id := l_old_effectivity_rec.pc_node_id;
754: END IF;
755:
756: IF ( p_x_effectivity_rec.pc_node_name = FND_API.G_MISS_CHAR ) THEN
757: p_x_effectivity_rec.pc_node_name := null;
758: ELSIF ( p_x_effectivity_rec.pc_node_name IS NULL ) THEN
759: p_x_effectivity_rec.pc_node_name := l_old_effectivity_rec.pc_node_name;
760: END IF;

Line 763: IF ( p_x_effectivity_rec.FLEET_HEADER_ID = FND_API.G_MISS_NUM ) THEN

759: p_x_effectivity_rec.pc_node_name := l_old_effectivity_rec.pc_node_name;
760: END IF;
761:
762: --sansatpa - checking for fleet id and name
763: IF ( p_x_effectivity_rec.FLEET_HEADER_ID = FND_API.G_MISS_NUM ) THEN
764: p_x_effectivity_rec.FLEET_HEADER_ID := null;
765: ELSIF ( p_x_effectivity_rec.FLEET_HEADER_ID IS NULL ) THEN
766: p_x_effectivity_rec.FLEET_HEADER_ID := l_old_effectivity_rec.FLEET_HEADER_ID;
767: END IF;

Line 769: IF ( p_x_effectivity_rec.FLEET_NAME = FND_API.G_MISS_CHAR ) THEN

765: ELSIF ( p_x_effectivity_rec.FLEET_HEADER_ID IS NULL ) THEN
766: p_x_effectivity_rec.FLEET_HEADER_ID := l_old_effectivity_rec.FLEET_HEADER_ID;
767: END IF;
768:
769: IF ( p_x_effectivity_rec.FLEET_NAME = FND_API.G_MISS_CHAR ) THEN
770: p_x_effectivity_rec.FLEET_NAME := null;
771: ELSIF ( p_x_effectivity_rec.FLEET_NAME IS NULL ) THEN
772: p_x_effectivity_rec.FLEET_NAME := l_old_effectivity_rec.FLEET_NAME;
773: END IF;

Line 775: IF ( p_x_effectivity_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN

771: ELSIF ( p_x_effectivity_rec.FLEET_NAME IS NULL ) THEN
772: p_x_effectivity_rec.FLEET_NAME := l_old_effectivity_rec.FLEET_NAME;
773: END IF;
774:
775: IF ( p_x_effectivity_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN
776: p_x_effectivity_rec.attribute_category := null;
777: ELSIF ( p_x_effectivity_rec.attribute_category IS NULL ) THEN
778: p_x_effectivity_rec.attribute_category := l_old_effectivity_rec.attribute_category;
779: END IF;

Line 781: IF ( p_x_effectivity_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN

777: ELSIF ( p_x_effectivity_rec.attribute_category IS NULL ) THEN
778: p_x_effectivity_rec.attribute_category := l_old_effectivity_rec.attribute_category;
779: END IF;
780:
781: IF ( p_x_effectivity_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN
782: p_x_effectivity_rec.attribute1 := null;
783: ELSIF ( p_x_effectivity_rec.attribute1 IS NULL ) THEN
784: p_x_effectivity_rec.attribute1 := l_old_effectivity_rec.attribute1;
785: END IF;

Line 787: IF ( p_x_effectivity_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN

783: ELSIF ( p_x_effectivity_rec.attribute1 IS NULL ) THEN
784: p_x_effectivity_rec.attribute1 := l_old_effectivity_rec.attribute1;
785: END IF;
786:
787: IF ( p_x_effectivity_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN
788: p_x_effectivity_rec.attribute2 := null;
789: ELSIF ( p_x_effectivity_rec.attribute2 IS NULL ) THEN
790: p_x_effectivity_rec.attribute2 := l_old_effectivity_rec.attribute2;
791: END IF;

Line 793: IF ( p_x_effectivity_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN

789: ELSIF ( p_x_effectivity_rec.attribute2 IS NULL ) THEN
790: p_x_effectivity_rec.attribute2 := l_old_effectivity_rec.attribute2;
791: END IF;
792:
793: IF ( p_x_effectivity_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN
794: p_x_effectivity_rec.attribute3 := null;
795: ELSIF ( p_x_effectivity_rec.attribute3 IS NULL ) THEN
796: p_x_effectivity_rec.attribute3 := l_old_effectivity_rec.attribute3;
797: END IF;

Line 799: IF ( p_x_effectivity_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN

795: ELSIF ( p_x_effectivity_rec.attribute3 IS NULL ) THEN
796: p_x_effectivity_rec.attribute3 := l_old_effectivity_rec.attribute3;
797: END IF;
798:
799: IF ( p_x_effectivity_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN
800: p_x_effectivity_rec.attribute4 := null;
801: ELSIF ( p_x_effectivity_rec.attribute4 IS NULL ) THEN
802: p_x_effectivity_rec.attribute4 := l_old_effectivity_rec.attribute4;
803: END IF;

Line 805: IF ( p_x_effectivity_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN

801: ELSIF ( p_x_effectivity_rec.attribute4 IS NULL ) THEN
802: p_x_effectivity_rec.attribute4 := l_old_effectivity_rec.attribute4;
803: END IF;
804:
805: IF ( p_x_effectivity_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN
806: p_x_effectivity_rec.attribute5 := null;
807: ELSIF ( p_x_effectivity_rec.attribute5 IS NULL ) THEN
808: p_x_effectivity_rec.attribute5 := l_old_effectivity_rec.attribute5;
809: END IF;

Line 811: IF ( p_x_effectivity_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN

807: ELSIF ( p_x_effectivity_rec.attribute5 IS NULL ) THEN
808: p_x_effectivity_rec.attribute5 := l_old_effectivity_rec.attribute5;
809: END IF;
810:
811: IF ( p_x_effectivity_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN
812: p_x_effectivity_rec.attribute6 := null;
813: ELSIF ( p_x_effectivity_rec.attribute6 IS NULL ) THEN
814: p_x_effectivity_rec.attribute6 := l_old_effectivity_rec.attribute6;
815: END IF;

Line 817: IF ( p_x_effectivity_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN

813: ELSIF ( p_x_effectivity_rec.attribute6 IS NULL ) THEN
814: p_x_effectivity_rec.attribute6 := l_old_effectivity_rec.attribute6;
815: END IF;
816:
817: IF ( p_x_effectivity_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN
818: p_x_effectivity_rec.attribute7 := null;
819: ELSIF ( p_x_effectivity_rec.attribute7 IS NULL ) THEN
820: p_x_effectivity_rec.attribute7 := l_old_effectivity_rec.attribute7;
821: END IF;

Line 823: IF ( p_x_effectivity_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN

819: ELSIF ( p_x_effectivity_rec.attribute7 IS NULL ) THEN
820: p_x_effectivity_rec.attribute7 := l_old_effectivity_rec.attribute7;
821: END IF;
822:
823: IF ( p_x_effectivity_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN
824: p_x_effectivity_rec.attribute8 := null;
825: ELSIF ( p_x_effectivity_rec.attribute8 IS NULL ) THEN
826: p_x_effectivity_rec.attribute8 := l_old_effectivity_rec.attribute8;
827: END IF;

Line 829: IF ( p_x_effectivity_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN

825: ELSIF ( p_x_effectivity_rec.attribute8 IS NULL ) THEN
826: p_x_effectivity_rec.attribute8 := l_old_effectivity_rec.attribute8;
827: END IF;
828:
829: IF ( p_x_effectivity_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN
830: p_x_effectivity_rec.attribute9 := null;
831: ELSIF ( p_x_effectivity_rec.attribute9 IS NULL ) THEN
832: p_x_effectivity_rec.attribute9 := l_old_effectivity_rec.attribute9;
833: END IF;

Line 835: IF ( p_x_effectivity_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN

831: ELSIF ( p_x_effectivity_rec.attribute9 IS NULL ) THEN
832: p_x_effectivity_rec.attribute9 := l_old_effectivity_rec.attribute9;
833: END IF;
834:
835: IF ( p_x_effectivity_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN
836: p_x_effectivity_rec.attribute10 := null;
837: ELSIF ( p_x_effectivity_rec.attribute10 IS NULL ) THEN
838: p_x_effectivity_rec.attribute10 := l_old_effectivity_rec.attribute10;
839: END IF;

Line 841: IF ( p_x_effectivity_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN

837: ELSIF ( p_x_effectivity_rec.attribute10 IS NULL ) THEN
838: p_x_effectivity_rec.attribute10 := l_old_effectivity_rec.attribute10;
839: END IF;
840:
841: IF ( p_x_effectivity_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN
842: p_x_effectivity_rec.attribute11 := null;
843: ELSIF ( p_x_effectivity_rec.attribute11 IS NULL ) THEN
844: p_x_effectivity_rec.attribute11 := l_old_effectivity_rec.attribute11;
845: END IF;

Line 847: IF ( p_x_effectivity_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN

843: ELSIF ( p_x_effectivity_rec.attribute11 IS NULL ) THEN
844: p_x_effectivity_rec.attribute11 := l_old_effectivity_rec.attribute11;
845: END IF;
846:
847: IF ( p_x_effectivity_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN
848: p_x_effectivity_rec.attribute12 := null;
849: ELSIF ( p_x_effectivity_rec.attribute12 IS NULL ) THEN
850: p_x_effectivity_rec.attribute12 := l_old_effectivity_rec.attribute12;
851: END IF;

Line 853: IF ( p_x_effectivity_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN

849: ELSIF ( p_x_effectivity_rec.attribute12 IS NULL ) THEN
850: p_x_effectivity_rec.attribute12 := l_old_effectivity_rec.attribute12;
851: END IF;
852:
853: IF ( p_x_effectivity_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN
854: p_x_effectivity_rec.attribute13 := null;
855: ELSIF ( p_x_effectivity_rec.attribute13 IS NULL ) THEN
856: p_x_effectivity_rec.attribute13 := l_old_effectivity_rec.attribute13;
857: END IF;

Line 859: IF ( p_x_effectivity_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN

855: ELSIF ( p_x_effectivity_rec.attribute13 IS NULL ) THEN
856: p_x_effectivity_rec.attribute13 := l_old_effectivity_rec.attribute13;
857: END IF;
858:
859: IF ( p_x_effectivity_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN
860: p_x_effectivity_rec.attribute14 := null;
861: ELSIF ( p_x_effectivity_rec.attribute14 IS NULL ) THEN
862: p_x_effectivity_rec.attribute14 := l_old_effectivity_rec.attribute14;
863: END IF;

Line 865: IF ( p_x_effectivity_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN

861: ELSIF ( p_x_effectivity_rec.attribute14 IS NULL ) THEN
862: p_x_effectivity_rec.attribute14 := l_old_effectivity_rec.attribute14;
863: END IF;
864:
865: IF ( p_x_effectivity_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN
866: p_x_effectivity_rec.attribute15 := null;
867: ELSIF ( p_x_effectivity_rec.attribute15 IS NULL ) THEN
868: p_x_effectivity_rec.attribute15 := l_old_effectivity_rec.attribute15;
869: END IF;

Line 882: x_return_status := FND_API.G_RET_STS_SUCCESS;

878: )
879: IS
880:
881: BEGIN
882: x_return_status := FND_API.G_RET_STS_SUCCESS;
883:
884: IF ( p_effectivity_rec.dml_operation = 'C' ) THEN
885: -- Check if the Effectivity Name does not column contains a null value.
886: IF ( p_effectivity_rec.name IS NULL OR

Line 887: p_effectivity_rec.name = FND_API.G_MISS_CHAR ) THEN

883:
884: IF ( p_effectivity_rec.dml_operation = 'C' ) THEN
885: -- Check if the Effectivity Name does not column contains a null value.
886: IF ( p_effectivity_rec.name IS NULL OR
887: p_effectivity_rec.name = FND_API.G_MISS_CHAR ) THEN
888: FND_MESSAGE.set_name( 'AHL','AHL_FMP_EFFECTIVITY_NAME_NULL' );
889: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
890: FND_MSG_PUB.add;
891: END IF;

Line 897: IF ( p_effectivity_rec.name = FND_API.G_MISS_CHAR ) THEN

893: END IF;
894:
895: IF ( p_effectivity_rec.dml_operation = 'U' ) THEN
896: -- Check if the Effectivity Name column does not contains a null value.
897: IF ( p_effectivity_rec.name = FND_API.G_MISS_CHAR ) THEN
898: FND_MESSAGE.set_name( 'AHL','AHL_FMP_EFFECTIVITY_NAME_NULL' );
899: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
900: FND_MSG_PUB.add;
901: END IF;

Line 906: p_effectivity_rec.mr_effectivity_id = FND_API.G_MISS_NUM ) THEN

902: END IF;
903:
904: -- Check if the mandatory Effectivity ID column contains a null value.
905: IF ( p_effectivity_rec.mr_effectivity_id IS NULL OR
906: p_effectivity_rec.mr_effectivity_id = FND_API.G_MISS_NUM ) THEN
907: FND_MESSAGE.set_name( 'AHL','AHL_FMP_EFFECTIVITY_ID_NULL' );
908: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
909: FND_MSG_PUB.add;
910: RETURN;

Line 915: p_effectivity_rec.object_version_number = FND_API.G_MISS_NUM ) THEN

911: END IF;
912:
913: -- Check if the mandatory Object Version Number column contains a null value.
914: IF ( p_effectivity_rec.object_version_number IS NULL OR
915: p_effectivity_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
916: FND_MESSAGE.set_name( 'AHL','AHL_FMP_MRE_OBJ_VERSION_NULL' );
917: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
918: FND_MSG_PUB.add;
919: RETURN;

Line 988: x_return_status := FND_API.G_RET_STS_SUCCESS;

984: l_prog_type VARCHAR2(30);
985: -- Tamal [MEL/CDL RM-FMP Enhancements] Ends here...
986:
987: BEGIN
988: x_return_status := FND_API.G_RET_STS_SUCCESS;
989:
990: IF ( P_APPLN_USAGE = 'PM' ) THEN
991:
992: -- Check if Item is NULL

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

1072: p_inventory_item_id => p_effectivity_rec.position_inventory_item_id,
1073: p_relationship_id => p_effectivity_rec.relationship_id
1074: );
1075:
1076: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1077: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1078: IF ( p_effectivity_rec.position_item_number IS NULL OR
1079: p_effectivity_rec.position_item_number = FND_API.G_MISS_CHAR ) THEN
1080: FND_MESSAGE.set_token( 'FIELD1', TO_CHAR( p_effectivity_rec.position_inventory_item_id ) );

Line 1079: p_effectivity_rec.position_item_number = FND_API.G_MISS_CHAR ) THEN

1075:
1076: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1077: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1078: IF ( p_effectivity_rec.position_item_number IS NULL OR
1079: p_effectivity_rec.position_item_number = FND_API.G_MISS_CHAR ) THEN
1080: FND_MESSAGE.set_token( 'FIELD1', TO_CHAR( p_effectivity_rec.position_inventory_item_id ) );
1081: ELSE
1082: FND_MESSAGE.set_token( 'FIELD1', p_effectivity_rec.position_item_number );
1083: END IF;

Line 1086: p_effectivity_rec.position_ref_meaning = FND_API.G_MISS_CHAR ) THEN

1082: FND_MESSAGE.set_token( 'FIELD1', p_effectivity_rec.position_item_number );
1083: END IF;
1084:
1085: IF ( p_effectivity_rec.position_ref_meaning IS NULL OR
1086: p_effectivity_rec.position_ref_meaning = FND_API.G_MISS_CHAR ) THEN
1087: FND_MESSAGE.set_token( 'FIELD2', TO_CHAR( p_effectivity_rec.relationship_id ) );
1088: ELSE
1089: FND_MESSAGE.set_token( 'FIELD2', p_effectivity_rec.position_ref_meaning );
1090: END IF;

Line 1107: p_effectivity_rec.position_item_number = FND_API.G_MISS_CHAR ) THEN

1103: l_msg_data := 'AHL_FMP_INVALID_POSITION_ITEM';
1104:
1105: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1106: IF ( p_effectivity_rec.position_item_number IS NULL OR
1107: p_effectivity_rec.position_item_number = FND_API.G_MISS_CHAR ) THEN
1108: FND_MESSAGE.set_token( 'FIELD1', TO_CHAR( p_effectivity_rec.position_inventory_item_id ) );
1109: ELSE
1110: FND_MESSAGE.set_token( 'FIELD1', p_effectivity_rec.position_item_number );
1111: END IF;

Line 1114: p_effectivity_rec.position_ref_meaning = FND_API.G_MISS_CHAR ) THEN

1110: FND_MESSAGE.set_token( 'FIELD1', p_effectivity_rec.position_item_number );
1111: END IF;
1112:
1113: IF ( p_effectivity_rec.position_ref_meaning IS NULL OR
1114: p_effectivity_rec.position_ref_meaning = FND_API.G_MISS_CHAR ) THEN
1115: FND_MESSAGE.set_token( 'FIELD2', TO_CHAR( p_effectivity_rec.relationship_id ) );
1116: ELSE
1117: FND_MESSAGE.set_token( 'FIELD2', p_effectivity_rec.position_ref_meaning );
1118: END IF;

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

1158: p_x_manufacturer_id => l_manufacturer_id
1159: );
1160: END IF;
1161:
1162: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1163: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_EFFECTIVITY_DTLS_EXIST' );
1164: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
1165: FND_MSG_PUB.add;
1166: END IF;

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

1208: p_x_counter_id => l_counter_id
1209: );
1210: END IF;
1211:
1212: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1213: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INTERVALS_EXIST' );
1214: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
1215: FND_MSG_PUB.add;
1216: END IF;

Line 1267: x_return_status := FND_API.G_RET_STS_SUCCESS;

1263: where inventory_item_id = c_inventory_item_id;
1264:
1265: BEGIN
1266:
1267: x_return_status := FND_API.G_RET_STS_SUCCESS;
1268:
1269: -- Check whether any duplicate effectivity records (based on Name) for the given MR_HEADER_ID
1270: OPEN get_dup_name( p_mr_header_id );
1271:

Line 1286: x_return_status := FND_API.G_RET_STS_ERROR;

1282:
1283: END LOOP;
1284:
1285: IF ( get_dup_name%ROWCOUNT > 0 ) THEN
1286: x_return_status := FND_API.G_RET_STS_ERROR;
1287: END IF;
1288:
1289: CLOSE get_dup_name;
1290:

Line 1318: x_return_status := FND_API.G_RET_STS_ERROR;

1314:
1315: END LOOP;
1316:
1317: IF ( get_dup_item%ROWCOUNT > 0 ) THEN
1318: x_return_status := FND_API.G_RET_STS_ERROR;
1319: END IF;
1320:
1321: CLOSE get_dup_item;
1322:

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

1327:
1328: PROCEDURE process_effectivity
1329: (
1330: p_api_version IN NUMBER := '1.0',
1331: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1332: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1333: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1334: p_default IN VARCHAR2 := FND_API.G_FALSE,
1335: p_module_type IN VARCHAR2 := NULL,

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

1328: PROCEDURE process_effectivity
1329: (
1330: p_api_version IN NUMBER := '1.0',
1331: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1332: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1333: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1334: p_default IN VARCHAR2 := FND_API.G_FALSE,
1335: p_module_type IN VARCHAR2 := NULL,
1336: x_return_status OUT NOCOPY VARCHAR2,

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

1329: (
1330: p_api_version IN NUMBER := '1.0',
1331: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1332: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1333: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1334: p_default IN VARCHAR2 := FND_API.G_FALSE,
1335: p_module_type IN VARCHAR2 := NULL,
1336: x_return_status OUT NOCOPY VARCHAR2,
1337: x_msg_count OUT NOCOPY NUMBER,

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

1330: p_api_version IN NUMBER := '1.0',
1331: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1332: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1333: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1334: p_default IN VARCHAR2 := FND_API.G_FALSE,
1335: p_module_type IN VARCHAR2 := NULL,
1336: x_return_status OUT NOCOPY VARCHAR2,
1337: x_msg_count OUT NOCOPY NUMBER,
1338: x_msg_data OUT NOCOPY VARCHAR2,

Line 1350: x_return_status := FND_API.G_RET_STS_SUCCESS;

1346: l_msg_count NUMBER;
1347: l_mr_effectivity_id NUMBER;
1348: BEGIN
1349: -- Initialize API return status to success
1350: x_return_status := FND_API.G_RET_STS_SUCCESS;
1351:
1352: -- Standard Start of API savepoint
1353: SAVEPOINT process_effectivity_PVT;
1354:

Line 1356: IF NOT FND_API.compatible_api_call

1352: -- Standard Start of API savepoint
1353: SAVEPOINT process_effectivity_PVT;
1354:
1355: -- Standard call to check for call compatibility.
1356: IF NOT FND_API.compatible_api_call
1357: (
1358: l_api_version,
1359: p_api_version,
1360: G_API_NAME,

Line 1364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1360: G_API_NAME,
1361: G_PKG_NAME
1362: )
1363: THEN
1364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1365: END IF;
1366:
1367: -- Initialize message list if p_init_msg_list is set to TRUE.
1368: IF FND_API.to_boolean( p_init_msg_list ) THEN

Line 1368: IF FND_API.to_boolean( p_init_msg_list ) THEN

1364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1365: END IF;
1366:
1367: -- Initialize message list if p_init_msg_list is set to TRUE.
1368: IF FND_API.to_boolean( p_init_msg_list ) THEN
1369: FND_MSG_PUB.initialize;
1370: END IF;
1371:
1372: -- Enable Debug (optional)

Line 1402: RAISE FND_API.G_EXC_ERROR;

1398: l_msg_count := FND_MSG_PUB.count_msg;
1399: IF l_msg_count > 0 THEN
1400: AHL_DEBUG_PUB.debug('After validate with error ' );
1401: x_msg_count := l_msg_count;
1402: RAISE FND_API.G_EXC_ERROR;
1403: END IF;
1404:
1405:
1406: AHL_DEBUG_PUB.debug('After validate with no error ' );

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

1423: END LOOP;
1424: END IF;
1425:
1426: -- Convert Values into Ids.
1427: IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL ) THEN
1428: FOR i IN 1..p_x_effectivity_tbl.count LOOP
1429: IF ( p_x_effectivity_tbl(i).dml_operation <> 'D' ) THEN
1430: convert_values_to_ids
1431: (

Line 1437: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1433: l_return_status -- OUT
1434: );
1435:
1436: -- If any severe error occurs, then, abort API.
1437: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1438: RAISE FND_API.G_EXC_ERROR;
1439: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1441: END IF;

Line 1438: RAISE FND_API.G_EXC_ERROR;

1434: );
1435:
1436: -- If any severe error occurs, then, abort API.
1437: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1438: RAISE FND_API.G_EXC_ERROR;
1439: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1441: END IF;
1442: END IF;

Line 1439: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1435:
1436: -- If any severe error occurs, then, abort API.
1437: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1438: RAISE FND_API.G_EXC_ERROR;
1439: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1441: END IF;
1442: END IF;
1443: END LOOP;

Line 1440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1436: -- If any severe error occurs, then, abort API.
1437: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1438: RAISE FND_API.G_EXC_ERROR;
1439: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1441: END IF;
1442: END IF;
1443: END LOOP;
1444: END IF;

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

1461: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after default_attributes' );
1462: END IF;
1463:
1464: -- Validate all attributes (Item level validation)
1465: IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL ) THEN
1466: FOR i IN 1..p_x_effectivity_tbl.count LOOP
1467: validate_attributes
1468: (
1469: p_x_effectivity_tbl(i), -- IN

Line 1474: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1470: l_return_status -- OUT
1471: );
1472:
1473: -- If any severe error occurs, then, abort API.
1474: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1475: RAISE FND_API.G_EXC_ERROR;
1476: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1478: END IF;

Line 1475: RAISE FND_API.G_EXC_ERROR;

1471: );
1472:
1473: -- If any severe error occurs, then, abort API.
1474: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1475: RAISE FND_API.G_EXC_ERROR;
1476: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1478: END IF;
1479: END LOOP;

Line 1476: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1472:
1473: -- If any severe error occurs, then, abort API.
1474: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1475: RAISE FND_API.G_EXC_ERROR;
1476: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1478: END IF;
1479: END LOOP;
1480: END IF;

Line 1477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1473: -- If any severe error occurs, then, abort API.
1474: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1475: RAISE FND_API.G_EXC_ERROR;
1476: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1478: END IF;
1479: END LOOP;
1480: END IF;
1481:

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

1502: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after default_unchanged_attributes / default_missing_attributes' );
1503: END IF;
1504:
1505: -- Perform cross attribute validation and missing attribute checks (Record level validation)
1506: IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL ) THEN
1507: FOR i IN 1..p_x_effectivity_tbl.count LOOP
1508: IF ( p_x_effectivity_tbl(i).dml_operation <> 'D' ) THEN
1509: validate_record
1510: (

Line 1520: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1516: l_return_status -- OUT
1517: );
1518:
1519: -- If any severe error occurs, then, abort API.
1520: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1521: RAISE FND_API.G_EXC_ERROR;
1522: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1524: END IF;

Line 1521: RAISE FND_API.G_EXC_ERROR;

1517: );
1518:
1519: -- If any severe error occurs, then, abort API.
1520: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1521: RAISE FND_API.G_EXC_ERROR;
1522: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1524: END IF;
1525: END IF;

Line 1522: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1518:
1519: -- If any severe error occurs, then, abort API.
1520: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1521: RAISE FND_API.G_EXC_ERROR;
1522: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1524: END IF;
1525: END IF;
1526: END LOOP;

Line 1523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1519: -- If any severe error occurs, then, abort API.
1520: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1521: RAISE FND_API.G_EXC_ERROR;
1522: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1524: END IF;
1525: END IF;
1526: END LOOP;
1527: END IF;

Line 1537: RAISE FND_API.G_EXC_ERROR;

1533: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
1534: l_msg_count := FND_MSG_PUB.count_msg;
1535: IF l_msg_count > 0 THEN
1536: x_msg_count := l_msg_count;
1537: RAISE FND_API.G_EXC_ERROR;
1538: END IF;
1539:
1540: -- Perform the DML statement directly.
1541: FOR i IN 1..p_x_effectivity_tbl.count LOOP

Line 1732: RAISE FND_API.G_EXC_ERROR;

1728: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
1729: l_msg_count := FND_MSG_PUB.count_msg;
1730: IF l_msg_count > 0 THEN
1731: x_msg_count := l_msg_count;
1732: RAISE FND_API.G_EXC_ERROR;
1733: END IF;
1734:
1735: -- Perform cross records validations and duplicate records check
1736:

Line 1758: RAISE FND_API.G_EXC_ERROR;

1754: -- If any severe error occurs, then, abort API.
1755: l_msg_count := FND_MSG_PUB.count_msg;
1756: IF l_msg_count > 0 THEN
1757: x_msg_count := l_msg_count;
1758: RAISE FND_API.G_EXC_ERROR;
1759: END IF;
1760:
1761: IF G_DEBUG = 'Y' THEN
1762: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after validate_records' );

Line 1766: IF FND_API.to_boolean( p_commit ) THEN

1762: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after validate_records' );
1763: END IF;
1764:
1765: -- Perform the Commit (if requested)
1766: IF FND_API.to_boolean( p_commit ) THEN
1767: COMMIT WORK;
1768: END IF;
1769:
1770: -- Count and Get messages (optional)

Line 1773: p_encoded => FND_API.G_FALSE,

1769:
1770: -- Count and Get messages (optional)
1771: FND_MSG_PUB.count_and_get
1772: (
1773: p_encoded => FND_API.G_FALSE,
1774: p_count => x_msg_count,
1775: p_data => x_msg_data
1776: );
1777:

Line 1785: WHEN FND_API.G_EXC_ERROR THEN

1781: END IF;
1782:
1783: EXCEPTION
1784:
1785: WHEN FND_API.G_EXC_ERROR THEN
1786: ROLLBACK TO process_effectivity_PVT;
1787: x_return_status := FND_API.G_RET_STS_ERROR ;
1788: FND_MSG_PUB.count_and_get
1789: (

Line 1787: x_return_status := FND_API.G_RET_STS_ERROR ;

1783: EXCEPTION
1784:
1785: WHEN FND_API.G_EXC_ERROR THEN
1786: ROLLBACK TO process_effectivity_PVT;
1787: x_return_status := FND_API.G_RET_STS_ERROR ;
1788: FND_MSG_PUB.count_and_get
1789: (
1790: p_encoded => FND_API.G_FALSE,
1791: p_count => x_msg_count,

Line 1790: p_encoded => FND_API.G_FALSE,

1786: ROLLBACK TO process_effectivity_PVT;
1787: x_return_status := FND_API.G_RET_STS_ERROR ;
1788: FND_MSG_PUB.count_and_get
1789: (
1790: p_encoded => FND_API.G_FALSE,
1791: p_count => x_msg_count,
1792: p_data => x_msg_data
1793: );
1794:

Line 1800: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1796: IF ( G_DEBUG = 'Y' ) THEN
1797: AHL_DEBUG_PUB.disable_debug;
1798: END IF;
1799:
1800: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1801: ROLLBACK TO process_effectivity_PVT;
1802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1803: FND_MSG_PUB.count_and_get
1804: (

Line 1802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1798: END IF;
1799:
1800: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1801: ROLLBACK TO process_effectivity_PVT;
1802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1803: FND_MSG_PUB.count_and_get
1804: (
1805: p_encoded => FND_API.G_FALSE,
1806: p_count => x_msg_count,

Line 1805: p_encoded => FND_API.G_FALSE,

1801: ROLLBACK TO process_effectivity_PVT;
1802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1803: FND_MSG_PUB.count_and_get
1804: (
1805: p_encoded => FND_API.G_FALSE,
1806: p_count => x_msg_count,
1807: p_data => x_msg_data
1808: );
1809:

Line 1817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1813: END IF;
1814:
1815: WHEN OTHERS THEN
1816: ROLLBACK TO process_effectivity_PVT;
1817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1818: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1819: THEN
1820: FND_MSG_PUB.add_exc_msg
1821: (

Line 1829: p_encoded => FND_API.G_FALSE,

1825: );
1826: END IF;
1827: FND_MSG_PUB.count_and_get
1828: (
1829: p_encoded => FND_API.G_FALSE,
1830: p_count => x_msg_count,
1831: p_data => x_msg_data
1832: );
1833: -- Disable debug (if enabled)