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.GMF_ALLOCATIONDEFINITION_PUB dependencies on FND_API

Line 174: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

170:
171: PROCEDURE Create_Allocation_Definition
172: (
173: p_api_version IN NUMBER ,
174: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
175: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
176:
177: x_return_status OUT NOCOPY VARCHAR2 ,
178: x_msg_count OUT NOCOPY NUMBER ,

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

171: PROCEDURE Create_Allocation_Definition
172: (
173: p_api_version IN NUMBER ,
174: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
175: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
176:
177: x_return_status OUT NOCOPY VARCHAR2 ,
178: x_msg_count OUT NOCOPY NUMBER ,
179: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 200: IF FND_API.to_Boolean( p_init_msg_list ) THEN

196: -- Standard Start of API savepoint
197: SAVEPOINT Create_Alloc_Definition_PUB;
198:
199: -- Initialize message list if p_init_msg_list is set to TRUE.
200: IF FND_API.to_Boolean( p_init_msg_list ) THEN
201: FND_MSG_PUB.initialize;
202: END IF;
203:
204: -- Standard call to check for call compatibility.

Line 205: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

201: FND_MSG_PUB.initialize;
202: END IF;
203:
204: -- Standard call to check for call compatibility.
205: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
206: p_api_version ,
207: l_api_name ,
208: G_PKG_NAME )
209: THEN

Line 210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

206: p_api_version ,
207: l_api_name ,
208: G_PKG_NAME )
209: THEN
210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
211: END IF;
212:
213: -- Initialize API return status to success
214: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 214: x_return_status := FND_API.G_RET_STS_SUCCESS;

210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
211: END IF;
212:
213: -- Initialize API return status to success
214: x_return_status := FND_API.G_RET_STS_SUCCESS;
215:
216: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
217: log_msg('Beginning Create Allocation Definition process.');
218: END IF;

Line 239: IF l_return_status = FND_API.G_RET_STS_ERROR

235: log_msg('Return Status after validating : ' || l_return_status);
236: END IF;
237:
238: -- Return if validation failures detected
239: IF l_return_status = FND_API.G_RET_STS_ERROR
240: THEN
241: RAISE FND_API.G_EXC_ERROR;
242: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
243: THEN

Line 241: RAISE FND_API.G_EXC_ERROR;

237:
238: -- Return if validation failures detected
239: IF l_return_status = FND_API.G_RET_STS_ERROR
240: THEN
241: RAISE FND_API.G_EXC_ERROR;
242: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
243: THEN
244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
245: END IF;

Line 242: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

238: -- Return if validation failures detected
239: IF l_return_status = FND_API.G_RET_STS_ERROR
240: THEN
241: RAISE FND_API.G_EXC_ERROR;
242: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
243: THEN
244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
245: END IF;
246:

Line 244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

240: THEN
241: RAISE FND_API.G_EXC_ERROR;
242: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
243: THEN
244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
245: END IF;
246:
247: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
248: log_msg('Calling private API to insert record.');

Line 253: , p_init_msg_list => FND_API.G_FALSE

249: END IF;
250:
251: GMF_AllocationDefinition_PVT.Create_Allocation_Definition
252: ( p_api_version => 3.0
253: , p_init_msg_list => FND_API.G_FALSE
254: , p_commit => FND_API.G_FALSE
255:
256: , x_return_status => l_return_status
257: , x_msg_count => l_count

Line 254: , p_commit => FND_API.G_FALSE

250:
251: GMF_AllocationDefinition_PVT.Create_Allocation_Definition
252: ( p_api_version => 3.0
253: , p_init_msg_list => FND_API.G_FALSE
254: , p_commit => FND_API.G_FALSE
255:
256: , x_return_status => l_return_status
257: , x_msg_count => l_count
258: , x_msg_data => l_data

Line 265: IF l_return_status = FND_API.G_RET_STS_ERROR

261: , p_user_id => l_user_id
262: );
263:
264: -- Return if insert fails for any reason
265: IF l_return_status = FND_API.G_RET_STS_ERROR
266: THEN
267: RAISE FND_API.G_EXC_ERROR;
268: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
269: THEN

Line 267: RAISE FND_API.G_EXC_ERROR;

263:
264: -- Return if insert fails for any reason
265: IF l_return_status = FND_API.G_RET_STS_ERROR
266: THEN
267: RAISE FND_API.G_EXC_ERROR;
268: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
269: THEN
270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
271: END IF;

Line 268: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

264: -- Return if insert fails for any reason
265: IF l_return_status = FND_API.G_RET_STS_ERROR
266: THEN
267: RAISE FND_API.G_EXC_ERROR;
268: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
269: THEN
270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
271: END IF;
272:

Line 270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

266: THEN
267: RAISE FND_API.G_EXC_ERROR;
268: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
269: THEN
270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
271: END IF;
272:
273: l_no_rows_ins := SQL%ROWCOUNT ;
274:

Line 294: IF FND_API.To_Boolean( p_commit ) THEN

290: log_msg('1 row inserted');
291: END IF;
292:
293: -- Standard check of p_commit.
294: IF FND_API.To_Boolean( p_commit ) THEN
295: COMMIT WORK;
296: END IF;
297:
298: -- Standard call to get message count and if count is 1, get message info.

Line 305: WHEN FND_API.G_EXC_ERROR THEN

301: p_data => x_msg_data
302: );
303:
304: EXCEPTION
305: WHEN FND_API.G_EXC_ERROR THEN
306: ROLLBACK TO Create_Alloc_Definition_PUB;
307: x_return_status := FND_API.G_RET_STS_ERROR ;
308: FND_MSG_PUB.Count_And_Get
309: ( p_count => x_msg_count ,

Line 307: x_return_status := FND_API.G_RET_STS_ERROR ;

303:
304: EXCEPTION
305: WHEN FND_API.G_EXC_ERROR THEN
306: ROLLBACK TO Create_Alloc_Definition_PUB;
307: x_return_status := FND_API.G_RET_STS_ERROR ;
308: FND_MSG_PUB.Count_And_Get
309: ( p_count => x_msg_count ,
310: p_data => x_msg_data
311: );

Line 312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

308: FND_MSG_PUB.Count_And_Get
309: ( p_count => x_msg_count ,
310: p_data => x_msg_data
311: );
312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
313: ROLLBACK TO Create_Alloc_Definition_PUB;
314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
315: FND_MSG_PUB.Count_And_Get
316: ( p_count => x_msg_count ,

Line 314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

310: p_data => x_msg_data
311: );
312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
313: ROLLBACK TO Create_Alloc_Definition_PUB;
314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
315: FND_MSG_PUB.Count_And_Get
316: ( p_count => x_msg_count ,
317: p_data => x_msg_data
318: );

Line 321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

317: p_data => x_msg_data
318: );
319: WHEN OTHERS THEN
320: ROLLBACK TO Create_Alloc_Definition_PUB;
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
322: IF FND_MSG_PUB.Check_Msg_Level
323: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
324: THEN
325: FND_MSG_PUB.Add_Exc_Msg

Line 373: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

369:
370: PROCEDURE Update_Allocation_Definition
371: (
372: p_api_version IN NUMBER ,
373: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
374: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
375:
376: x_return_status OUT NOCOPY VARCHAR2 ,
377: x_msg_count OUT NOCOPY NUMBER ,

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

370: PROCEDURE Update_Allocation_Definition
371: (
372: p_api_version IN NUMBER ,
373: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
374: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
375:
376: x_return_status OUT NOCOPY VARCHAR2 ,
377: x_msg_count OUT NOCOPY NUMBER ,
378: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 398: IF FND_API.to_Boolean( p_init_msg_list ) THEN

394: -- Standard Start of API savepoint
395: SAVEPOINT Update_Alloc_Definition_PUB;
396:
397: -- Initialize message list if p_init_msg_list is set to TRUE.
398: IF FND_API.to_Boolean( p_init_msg_list ) THEN
399: FND_MSG_PUB.initialize;
400: END IF;
401:
402: -- Standard call to check for call compatibility.

Line 403: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

399: FND_MSG_PUB.initialize;
400: END IF;
401:
402: -- Standard call to check for call compatibility.
403: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
404: p_api_version ,
405: l_api_name ,
406: G_PKG_NAME )
407: THEN

Line 408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

404: p_api_version ,
405: l_api_name ,
406: G_PKG_NAME )
407: THEN
408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
409: END IF;
410:
411: -- Initialize API return status to success
412: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 412: x_return_status := FND_API.G_RET_STS_SUCCESS;

408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
409: END IF;
410:
411: -- Initialize API return status to success
412: x_return_status := FND_API.G_RET_STS_SUCCESS;
413:
414: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
415: log_msg('Beginning Update Allocation Definition process.');
416: END IF;

Line 430: (p_allocation_definition_rec.line_no = FND_API.G_MISS_NUM) THEN -- Bug 2659435

426: log_msg('validating line_no : '||p_allocation_definition_rec.line_no);
427: END IF;
428:
429: IF (p_allocation_definition_rec.line_no IS NULL) OR
430: (p_allocation_definition_rec.line_no = FND_API.G_MISS_NUM) THEN -- Bug 2659435
431: add_header_to_error_stack(p_allocation_definition_rec); -- Bug 2659435
432: FND_MESSAGE.SET_NAME('GMF','GMF_API_LINE_NO_REQ');
433: FND_MSG_PUB.Add;
434: RAISE FND_API.G_EXC_ERROR;

Line 434: RAISE FND_API.G_EXC_ERROR;

430: (p_allocation_definition_rec.line_no = FND_API.G_MISS_NUM) THEN -- Bug 2659435
431: add_header_to_error_stack(p_allocation_definition_rec); -- Bug 2659435
432: FND_MESSAGE.SET_NAME('GMF','GMF_API_LINE_NO_REQ');
433: FND_MSG_PUB.Add;
434: RAISE FND_API.G_EXC_ERROR;
435: END IF;
436: -- End Line number
437:
438: -- Validate all the input parameters.

Line 454: IF l_return_status = FND_API.G_RET_STS_ERROR

450: log_msg('Return Status after validating : ' || l_return_status);
451: END IF;
452:
453: -- Return if validation failures detected
454: IF l_return_status = FND_API.G_RET_STS_ERROR
455: THEN
456: RAISE FND_API.G_EXC_ERROR;
457: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
458: THEN

Line 456: RAISE FND_API.G_EXC_ERROR;

452:
453: -- Return if validation failures detected
454: IF l_return_status = FND_API.G_RET_STS_ERROR
455: THEN
456: RAISE FND_API.G_EXC_ERROR;
457: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
458: THEN
459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
460: END IF;

Line 457: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

453: -- Return if validation failures detected
454: IF l_return_status = FND_API.G_RET_STS_ERROR
455: THEN
456: RAISE FND_API.G_EXC_ERROR;
457: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
458: THEN
459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
460: END IF;
461:

Line 459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

455: THEN
456: RAISE FND_API.G_EXC_ERROR;
457: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
458: THEN
459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
460: END IF;
461:
462: /*
463: -- Check whether any records exists for update

Line 475: RAISE FND_API.G_EXC_ERROR;

471: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_FOUND');
472: FND_MESSAGE.SET_TOKEN('ALLOC_ID',l_alloc_def_rec.alloc_id);
473: FND_MESSAGE.SET_TOKEN('LINE_NO', l_alloc_def_rec.line_no);
474: FND_MSG_PUB.Add;
475: RAISE FND_API.G_EXC_ERROR;
476: END IF ;
477: */
478:
479: -- Check whether any records exists for update

Line 486: RAISE FND_API.G_EXC_ERROR;

482: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_FOUND');
483: FND_MESSAGE.SET_TOKEN('ALLOC_ID',l_alloc_def_rec.alloc_id);
484: FND_MESSAGE.SET_TOKEN('LINE_NO', l_alloc_def_rec.line_no);
485: FND_MSG_PUB.Add;
486: RAISE FND_API.G_EXC_ERROR;
487: END IF ;
488:
489: IF l_alloc_def_rec.delete_mark = 1 THEN
490: add_header_to_error_stack(l_alloc_def_rec); -- Bug 2659435

Line 493: RAISE FND_API.G_EXC_ERROR;

489: IF l_alloc_def_rec.delete_mark = 1 THEN
490: add_header_to_error_stack(l_alloc_def_rec); -- Bug 2659435
491: FND_MESSAGE.SET_NAME('GMF','GMF_API_CANT_MARK_FOR_PURGE');
492: FND_MSG_PUB.Add;
493: RAISE FND_API.G_EXC_ERROR;
494: END IF ;
495:
496: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
497: log_msg('Updating record for alloc_id : ' ||

Line 503: , p_init_msg_list => FND_API.G_FALSE

499: END IF;
500:
501: GMF_AllocationDefinition_PVT.Update_Allocation_Definition
502: ( p_api_version => 3.0
503: , p_init_msg_list => FND_API.G_FALSE
504: , p_commit => FND_API.G_FALSE
505:
506: , x_return_status => l_return_status
507: , x_msg_count => l_count

Line 504: , p_commit => FND_API.G_FALSE

500:
501: GMF_AllocationDefinition_PVT.Update_Allocation_Definition
502: ( p_api_version => 3.0
503: , p_init_msg_list => FND_API.G_FALSE
504: , p_commit => FND_API.G_FALSE
505:
506: , x_return_status => l_return_status
507: , x_msg_count => l_count
508: , x_msg_data => l_data

Line 515: IF l_return_status = FND_API.G_RET_STS_ERROR

511: , p_user_id => l_user_id
512: );
513:
514: -- Return if insert fails for any reason
515: IF l_return_status = FND_API.G_RET_STS_ERROR
516: THEN
517: RAISE FND_API.G_EXC_ERROR;
518: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
519: THEN

Line 517: RAISE FND_API.G_EXC_ERROR;

513:
514: -- Return if insert fails for any reason
515: IF l_return_status = FND_API.G_RET_STS_ERROR
516: THEN
517: RAISE FND_API.G_EXC_ERROR;
518: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
519: THEN
520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
521: END IF;

Line 518: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

514: -- Return if insert fails for any reason
515: IF l_return_status = FND_API.G_RET_STS_ERROR
516: THEN
517: RAISE FND_API.G_EXC_ERROR;
518: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
519: THEN
520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
521: END IF;
522:

Line 520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

516: THEN
517: RAISE FND_API.G_EXC_ERROR;
518: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
519: THEN
520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
521: END IF;
522:
523: l_no_rows_upd := SQL%ROWCOUNT ;
524:

Line 542: IF FND_API.To_Boolean( p_commit ) THEN

538:
539: --log_msg( l_no_rows_upd || ' rows updated.');
540:
541: -- Standard check of p_commit.
542: IF FND_API.To_Boolean( p_commit ) THEN
543: COMMIT WORK;
544: END IF;
545:
546: -- Standard call to get message count and if count is 1, get message info.

Line 553: WHEN FND_API.G_EXC_ERROR THEN

549: p_data => x_msg_data
550: );
551:
552: EXCEPTION
553: WHEN FND_API.G_EXC_ERROR THEN
554: ROLLBACK TO Update_Alloc_Definition_PUB;
555: x_return_status := FND_API.G_RET_STS_ERROR ;
556: FND_MSG_PUB.Count_And_Get
557: ( p_count => x_msg_count ,

Line 555: x_return_status := FND_API.G_RET_STS_ERROR ;

551:
552: EXCEPTION
553: WHEN FND_API.G_EXC_ERROR THEN
554: ROLLBACK TO Update_Alloc_Definition_PUB;
555: x_return_status := FND_API.G_RET_STS_ERROR ;
556: FND_MSG_PUB.Count_And_Get
557: ( p_count => x_msg_count ,
558: p_data => x_msg_data
559: );

Line 560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

556: FND_MSG_PUB.Count_And_Get
557: ( p_count => x_msg_count ,
558: p_data => x_msg_data
559: );
560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
561: ROLLBACK TO Update_Alloc_Definition_PUB;
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
563: FND_MSG_PUB.Count_And_Get
564: ( p_count => x_msg_count ,

Line 562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

558: p_data => x_msg_data
559: );
560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
561: ROLLBACK TO Update_Alloc_Definition_PUB;
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
563: FND_MSG_PUB.Count_And_Get
564: ( p_count => x_msg_count ,
565: p_data => x_msg_data
566: );

Line 569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

565: p_data => x_msg_data
566: );
567: WHEN OTHERS THEN
568: ROLLBACK TO Update_Alloc_Definition_PUB;
569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
570: IF FND_MSG_PUB.Check_Msg_Level
571: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
572: THEN
573: FND_MSG_PUB.Add_Exc_Msg

Line 621: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

617:
618: PROCEDURE Delete_Allocation_Definition
619: (
620: p_api_version IN NUMBER ,
621: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
622: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
623:
624: x_return_status OUT NOCOPY VARCHAR2 ,
625: x_msg_count OUT NOCOPY NUMBER ,

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

618: PROCEDURE Delete_Allocation_Definition
619: (
620: p_api_version IN NUMBER ,
621: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
622: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
623:
624: x_return_status OUT NOCOPY VARCHAR2 ,
625: x_msg_count OUT NOCOPY NUMBER ,
626: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 639: l_user_name fnd_user.user_name%TYPE ; --:= FND_API.G_MISS_CHAR ; Bug 2659435

635: l_user_id fnd_user.user_id%TYPE ;
636: l_no_rows_del NUMBER(10) ;
637: l_count NUMBER(10) ;
638: l_cnt NUMBER(10) ;
639: l_user_name fnd_user.user_name%TYPE ; --:= FND_API.G_MISS_CHAR ; Bug 2659435
640: l_return_status VARCHAR2(2) ;
641: l_data VARCHAR2(2000) ;
642:
643: BEGIN

Line 649: IF FND_API.to_Boolean( p_init_msg_list ) THEN

645: -- Standard Start of API savepoint
646: SAVEPOINT Delete_Alloc_Definition_PUB;
647:
648: -- Initialize message list if p_init_msg_list is set to TRUE.
649: IF FND_API.to_Boolean( p_init_msg_list ) THEN
650: FND_MSG_PUB.initialize;
651: END IF;
652:
653: -- Standard call to check for call compatibility.

Line 654: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

650: FND_MSG_PUB.initialize;
651: END IF;
652:
653: -- Standard call to check for call compatibility.
654: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
655: p_api_version ,
656: l_api_name ,
657: G_PKG_NAME )
658: THEN

Line 659: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

655: p_api_version ,
656: l_api_name ,
657: G_PKG_NAME )
658: THEN
659: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
660: END IF;
661:
662: -- Initialize API return status to success
663: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 663: x_return_status := FND_API.G_RET_STS_SUCCESS;

659: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
660: END IF;
661:
662: -- Initialize API return status to success
663: x_return_status := FND_API.G_RET_STS_SUCCESS;
664:
665: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
666: log_msg('Beginning Delete Allocation Definition process.');
667: END IF;

Line 689: (p_allocation_definition_rec.line_no = FND_API.G_MISS_NUM) THEN -- Bug 2659435

685: log_msg('validating line_no : '||p_allocation_definition_rec.line_no);
686: END IF;
687:
688: IF (p_allocation_definition_rec.line_no IS NULL) OR
689: (p_allocation_definition_rec.line_no = FND_API.G_MISS_NUM) THEN -- Bug 2659435
690: add_header_to_error_stack(p_allocation_definition_rec); -- Bug 2659435
691: FND_MESSAGE.SET_NAME('GMF','GMF_API_LINE_NO_REQ');
692: FND_MSG_PUB.Add;
693: RAISE FND_API.G_EXC_ERROR;

Line 693: RAISE FND_API.G_EXC_ERROR;

689: (p_allocation_definition_rec.line_no = FND_API.G_MISS_NUM) THEN -- Bug 2659435
690: add_header_to_error_stack(p_allocation_definition_rec); -- Bug 2659435
691: FND_MESSAGE.SET_NAME('GMF','GMF_API_LINE_NO_REQ');
692: FND_MSG_PUB.Add;
693: RAISE FND_API.G_EXC_ERROR;
694: ELSE
695: l_alloc_def_rec.line_no := p_allocation_definition_rec.line_no ;
696: END IF;
697: -- End Line number

Line 706: IF (p_allocation_definition_rec.alloc_id <> FND_API.G_MISS_NUM) AND

702: -- Use alloc_id if sent otherwise use Alloc_code and legal_entity_id
703: -- If both are sent then use only alloc_id and ignore other params and log a message
704: -- If both are not sent then raise error.
705: --
706: IF (p_allocation_definition_rec.alloc_id <> FND_API.G_MISS_NUM) AND
707: (p_allocation_definition_rec.alloc_id IS NOT NULL) THEN
708: -- validate alloc_id
709: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
710: log_msg('validating alloc_id : '||

Line 719: RAISE FND_API.G_EXC_ERROR;

715: add_header_to_error_stack(p_allocation_definition_rec); -- Bug 2659435
716: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ALLOC_ID');
717: FND_MESSAGE.SET_TOKEN('ALLOC_ID',p_allocation_definition_rec.alloc_id);
718: FND_MSG_PUB.Add;
719: RAISE FND_API.G_EXC_ERROR;
720: END IF;
721:
722: l_alloc_def_rec.alloc_id := p_allocation_definition_rec.alloc_id ;
723:

Line 725: IF ((p_allocation_definition_rec.alloc_code <> FND_API.G_MISS_CHAR) AND

721:
722: l_alloc_def_rec.alloc_id := p_allocation_definition_rec.alloc_id ;
723:
724: -- Log message if alloc_code and company is also passed
725: IF ((p_allocation_definition_rec.alloc_code <> FND_API.G_MISS_CHAR) AND
726: (p_allocation_definition_rec.alloc_code IS NOT NULL)) OR
727: ((p_allocation_definition_rec.legal_entity_id <> FND_API.G_MISS_NUM) AND
728: (p_allocation_definition_rec.legal_entity_id IS NOT NULL))
729: THEN

Line 727: ((p_allocation_definition_rec.legal_entity_id <> FND_API.G_MISS_NUM) AND

723:
724: -- Log message if alloc_code and company is also passed
725: IF ((p_allocation_definition_rec.alloc_code <> FND_API.G_MISS_CHAR) AND
726: (p_allocation_definition_rec.alloc_code IS NOT NULL)) OR
727: ((p_allocation_definition_rec.legal_entity_id <> FND_API.G_MISS_NUM) AND
728: (p_allocation_definition_rec.legal_entity_id IS NOT NULL))
729: THEN
730: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
731: add_header_to_error_stack(p_allocation_definition_rec); -- Bug 2659435

Line 738: ELSIF ((p_allocation_definition_rec.alloc_code <> FND_API.G_MISS_CHAR) AND

734: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY',p_allocation_definition_rec.LEGAL_ENTITY_ID);
735: FND_MSG_PUB.Add;
736: END IF;
737: END IF;
738: ELSIF ((p_allocation_definition_rec.alloc_code <> FND_API.G_MISS_CHAR) AND
739: (p_allocation_definition_rec.alloc_code IS NOT NULL)) AND
740: ((p_allocation_definition_rec.LEGAL_ENTITY_ID <> FND_API.G_MISS_NUM) AND
741: (p_allocation_definition_rec.alloc_code IS NOT NULL)) THEN
742:

Line 740: ((p_allocation_definition_rec.LEGAL_ENTITY_ID <> FND_API.G_MISS_NUM) AND

736: END IF;
737: END IF;
738: ELSIF ((p_allocation_definition_rec.alloc_code <> FND_API.G_MISS_CHAR) AND
739: (p_allocation_definition_rec.alloc_code IS NOT NULL)) AND
740: ((p_allocation_definition_rec.LEGAL_ENTITY_ID <> FND_API.G_MISS_NUM) AND
741: (p_allocation_definition_rec.alloc_code IS NOT NULL)) THEN
742:
743: -- Convert value into ID.
744:

Line 766: RAISE FND_API.G_EXC_ERROR;

762: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ALLOC_CODE');
763: FND_MESSAGE.SET_TOKEN('ALLOC_CODE',p_allocation_definition_rec.alloc_code);
764: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY',p_allocation_definition_rec.legal_entity_id);
765: FND_MSG_PUB.Add;
766: RAISE FND_API.G_EXC_ERROR;
767: END IF;
768: ELSE
769: add_header_to_error_stack(p_allocation_definition_rec); -- Bug 2659435
770: FND_MESSAGE.SET_NAME('GMF','GMF_API_ALLOC_DTL_REQ');

Line 772: RAISE FND_API.G_EXC_ERROR;

768: ELSE
769: add_header_to_error_stack(p_allocation_definition_rec); -- Bug 2659435
770: FND_MESSAGE.SET_NAME('GMF','GMF_API_ALLOC_DTL_REQ');
771: FND_MSG_PUB.Add;
772: RAISE FND_API.G_EXC_ERROR;
773: END IF;
774: -- End Allocation Id
775:
776: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435

Line 780: IF (p_allocation_definition_rec.user_name <> FND_API.G_MISS_CHAR) AND

776: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
777: log_msg('validating user_name : '|| p_allocation_definition_rec.user_name);
778: END IF;
779:
780: IF (p_allocation_definition_rec.user_name <> FND_API.G_MISS_CHAR) AND
781: (p_allocation_definition_rec.user_name IS NOT NULL) THEN
782: GMA_GLOBAL_GRP.Get_who( p_user_name => p_allocation_definition_rec.user_name
783: , x_user_id => l_user_id
784: );

Line 790: RAISE FND_API.G_EXC_ERROR;

786: add_header_to_error_stack(p_allocation_definition_rec); -- Bug 2659435
787: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_USER_NAME');
788: FND_MESSAGE.SET_TOKEN('USER_NAME',p_allocation_definition_rec.user_name);
789: FND_MSG_PUB.Add;
790: RAISE FND_API.G_EXC_ERROR;
791: ELSE
792: l_alloc_def_rec.user_name := p_allocation_definition_rec.user_name;
793: END IF;
794: ELSE

Line 798: RAISE FND_API.G_EXC_ERROR;

794: ELSE
795: add_header_to_error_stack(p_allocation_definition_rec); -- Bug 2659435
796: FND_MESSAGE.SET_NAME('GMF','GMF_API_USER_NAME_REQ');
797: FND_MSG_PUB.Add;
798: RAISE FND_API.G_EXC_ERROR;
799: END IF;
800: -- End User Name
801:
802:

Line 817: RAISE FND_API.G_EXC_ERROR;

813: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_FOUND');
814: FND_MESSAGE.SET_TOKEN('ALLOC_ID',l_alloc_def_rec.alloc_id);
815: FND_MESSAGE.SET_TOKEN('LINE_NO', l_alloc_def_rec.line_no);
816: FND_MSG_PUB.Add;
817: RAISE FND_API.G_EXC_ERROR;
818: END IF ;
819: */
820:
821: -- Check whether any records exists for update

Line 828: RAISE FND_API.G_EXC_ERROR;

824: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_FOUND');
825: FND_MESSAGE.SET_TOKEN('ALLOC_ID',l_alloc_def_rec.alloc_id);
826: FND_MESSAGE.SET_TOKEN('LINE_NO', l_alloc_def_rec.line_no);
827: FND_MSG_PUB.Add;
828: RAISE FND_API.G_EXC_ERROR;
829: END IF ;
830:
831: l_alloc_def_rec.delete_mark := 1;
832:

Line 840: , p_init_msg_list => FND_API.G_FALSE

836: END IF;
837:
838: GMF_AllocationDefinition_PVT.Update_Allocation_Definition
839: ( p_api_version => 3.0
840: , p_init_msg_list => FND_API.G_FALSE
841: , p_commit => FND_API.G_FALSE
842:
843: , x_return_status => l_return_status
844: , x_msg_count => l_count

Line 841: , p_commit => FND_API.G_FALSE

837:
838: GMF_AllocationDefinition_PVT.Update_Allocation_Definition
839: ( p_api_version => 3.0
840: , p_init_msg_list => FND_API.G_FALSE
841: , p_commit => FND_API.G_FALSE
842:
843: , x_return_status => l_return_status
844: , x_msg_count => l_count
845: , x_msg_data => l_data

Line 852: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

848: , p_user_id => l_user_id
849: );
850:
851: -- Return if insert fails for any reason
852: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
853: RAISE FND_API.G_EXC_ERROR;
854: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
856: END IF;

Line 853: RAISE FND_API.G_EXC_ERROR;

849: );
850:
851: -- Return if insert fails for any reason
852: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
853: RAISE FND_API.G_EXC_ERROR;
854: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
856: END IF;
857:

Line 854: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

850:
851: -- Return if insert fails for any reason
852: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
853: RAISE FND_API.G_EXC_ERROR;
854: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
856: END IF;
857:
858: l_no_rows_del := SQL%ROWCOUNT ;

Line 855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

851: -- Return if insert fails for any reason
852: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
853: RAISE FND_API.G_EXC_ERROR;
854: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
856: END IF;
857:
858: l_no_rows_del := SQL%ROWCOUNT ;
859:

Line 879: IF FND_API.To_Boolean( p_commit ) THEN

875: log_msg(l_no_rows_del || ' rows deleted.');
876: END IF;
877:
878: -- Standard check of p_commit.
879: IF FND_API.To_Boolean( p_commit ) THEN
880: COMMIT WORK;
881: END IF;
882:
883: -- Standard call to get message count and if count is 1, get message info.

Line 890: WHEN FND_API.G_EXC_ERROR THEN

886: p_data => x_msg_data
887: );
888:
889: EXCEPTION
890: WHEN FND_API.G_EXC_ERROR THEN
891: ROLLBACK TO Delete_Alloc_Definition_PUB;
892: x_return_status := FND_API.G_RET_STS_ERROR ;
893: FND_MSG_PUB.Count_And_Get
894: ( p_count => x_msg_count ,

Line 892: x_return_status := FND_API.G_RET_STS_ERROR ;

888:
889: EXCEPTION
890: WHEN FND_API.G_EXC_ERROR THEN
891: ROLLBACK TO Delete_Alloc_Definition_PUB;
892: x_return_status := FND_API.G_RET_STS_ERROR ;
893: FND_MSG_PUB.Count_And_Get
894: ( p_count => x_msg_count ,
895: p_data => x_msg_data
896: );

Line 897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

893: FND_MSG_PUB.Count_And_Get
894: ( p_count => x_msg_count ,
895: p_data => x_msg_data
896: );
897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
898: ROLLBACK TO Delete_Alloc_Definition_PUB;
899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
900: FND_MSG_PUB.Count_And_Get
901: ( p_count => x_msg_count ,

Line 899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

895: p_data => x_msg_data
896: );
897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
898: ROLLBACK TO Delete_Alloc_Definition_PUB;
899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
900: FND_MSG_PUB.Count_And_Get
901: ( p_count => x_msg_count ,
902: p_data => x_msg_data
903: );

Line 906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

902: p_data => x_msg_data
903: );
904: WHEN OTHERS THEN
905: ROLLBACK TO Delete_Alloc_Definition_PUB;
906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
907: IF FND_MSG_PUB.Check_Msg_Level
908: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
909: THEN
910: FND_MSG_PUB.Add_Exc_Msg

Line 953: l_Alloc_id NUMBER ; -- := FND_API.G_MISS_NUM ;

949: ,x_return_status OUT NOCOPY VARCHAR2
950: )
951: IS
952: -- Bug 2659435. Commented all default assignments to increase performance.
953: l_Alloc_id NUMBER ; -- := FND_API.G_MISS_NUM ;
954: l_alloc_code gl_aloc_mst.alloc_code%TYPE ; -- := FND_API.G_MISS_CHAR ;
955: l_legal_entity_id gmf_legal_entities.legal_entity_id%TYPE ; -- := FND_API.G_MISS_CHAR ;
956: l_alloc_method NUMBER ; -- := FND_API.G_MISS_NUM ;
957: l_line_no NUMBER ; -- := FND_API.G_MISS_NUM ;

Line 954: l_alloc_code gl_aloc_mst.alloc_code%TYPE ; -- := FND_API.G_MISS_CHAR ;

950: )
951: IS
952: -- Bug 2659435. Commented all default assignments to increase performance.
953: l_Alloc_id NUMBER ; -- := FND_API.G_MISS_NUM ;
954: l_alloc_code gl_aloc_mst.alloc_code%TYPE ; -- := FND_API.G_MISS_CHAR ;
955: l_legal_entity_id gmf_legal_entities.legal_entity_id%TYPE ; -- := FND_API.G_MISS_CHAR ;
956: l_alloc_method NUMBER ; -- := FND_API.G_MISS_NUM ;
957: l_line_no NUMBER ; -- := FND_API.G_MISS_NUM ;
958: l_Item_Id NUMBER ; -- := FND_API.G_MISS_NUM ;

Line 955: l_legal_entity_id gmf_legal_entities.legal_entity_id%TYPE ; -- := FND_API.G_MISS_CHAR ;

951: IS
952: -- Bug 2659435. Commented all default assignments to increase performance.
953: l_Alloc_id NUMBER ; -- := FND_API.G_MISS_NUM ;
954: l_alloc_code gl_aloc_mst.alloc_code%TYPE ; -- := FND_API.G_MISS_CHAR ;
955: l_legal_entity_id gmf_legal_entities.legal_entity_id%TYPE ; -- := FND_API.G_MISS_CHAR ;
956: l_alloc_method NUMBER ; -- := FND_API.G_MISS_NUM ;
957: l_line_no NUMBER ; -- := FND_API.G_MISS_NUM ;
958: l_Item_Id NUMBER ; -- := FND_API.G_MISS_NUM ;
959: l_item_number mtl_item_flexfields.item_number%TYPE ; -- := FND_API.G_MISS_CHAR ;

Line 956: l_alloc_method NUMBER ; -- := FND_API.G_MISS_NUM ;

952: -- Bug 2659435. Commented all default assignments to increase performance.
953: l_Alloc_id NUMBER ; -- := FND_API.G_MISS_NUM ;
954: l_alloc_code gl_aloc_mst.alloc_code%TYPE ; -- := FND_API.G_MISS_CHAR ;
955: l_legal_entity_id gmf_legal_entities.legal_entity_id%TYPE ; -- := FND_API.G_MISS_CHAR ;
956: l_alloc_method NUMBER ; -- := FND_API.G_MISS_NUM ;
957: l_line_no NUMBER ; -- := FND_API.G_MISS_NUM ;
958: l_Item_Id NUMBER ; -- := FND_API.G_MISS_NUM ;
959: l_item_number mtl_item_flexfields.item_number%TYPE ; -- := FND_API.G_MISS_CHAR ;
960: l_basis_account_id gl_aloc_bas.basis_account_id%TYPE ;

Line 957: l_line_no NUMBER ; -- := FND_API.G_MISS_NUM ;

953: l_Alloc_id NUMBER ; -- := FND_API.G_MISS_NUM ;
954: l_alloc_code gl_aloc_mst.alloc_code%TYPE ; -- := FND_API.G_MISS_CHAR ;
955: l_legal_entity_id gmf_legal_entities.legal_entity_id%TYPE ; -- := FND_API.G_MISS_CHAR ;
956: l_alloc_method NUMBER ; -- := FND_API.G_MISS_NUM ;
957: l_line_no NUMBER ; -- := FND_API.G_MISS_NUM ;
958: l_Item_Id NUMBER ; -- := FND_API.G_MISS_NUM ;
959: l_item_number mtl_item_flexfields.item_number%TYPE ; -- := FND_API.G_MISS_CHAR ;
960: l_basis_account_id gl_aloc_bas.basis_account_id%TYPE ;
961: l_basis_account_key gl_aloc_bas.basis_account_key%TYPE ; -- := FND_API.G_MISS_CHAR ;

Line 958: l_Item_Id NUMBER ; -- := FND_API.G_MISS_NUM ;

954: l_alloc_code gl_aloc_mst.alloc_code%TYPE ; -- := FND_API.G_MISS_CHAR ;
955: l_legal_entity_id gmf_legal_entities.legal_entity_id%TYPE ; -- := FND_API.G_MISS_CHAR ;
956: l_alloc_method NUMBER ; -- := FND_API.G_MISS_NUM ;
957: l_line_no NUMBER ; -- := FND_API.G_MISS_NUM ;
958: l_Item_Id NUMBER ; -- := FND_API.G_MISS_NUM ;
959: l_item_number mtl_item_flexfields.item_number%TYPE ; -- := FND_API.G_MISS_CHAR ;
960: l_basis_account_id gl_aloc_bas.basis_account_id%TYPE ;
961: l_basis_account_key gl_aloc_bas.basis_account_key%TYPE ; -- := FND_API.G_MISS_CHAR ;
962: l_balance_type NUMBER ; -- := FND_API.G_MISS_NUM ;

Line 959: l_item_number mtl_item_flexfields.item_number%TYPE ; -- := FND_API.G_MISS_CHAR ;

955: l_legal_entity_id gmf_legal_entities.legal_entity_id%TYPE ; -- := FND_API.G_MISS_CHAR ;
956: l_alloc_method NUMBER ; -- := FND_API.G_MISS_NUM ;
957: l_line_no NUMBER ; -- := FND_API.G_MISS_NUM ;
958: l_Item_Id NUMBER ; -- := FND_API.G_MISS_NUM ;
959: l_item_number mtl_item_flexfields.item_number%TYPE ; -- := FND_API.G_MISS_CHAR ;
960: l_basis_account_id gl_aloc_bas.basis_account_id%TYPE ;
961: l_basis_account_key gl_aloc_bas.basis_account_key%TYPE ; -- := FND_API.G_MISS_CHAR ;
962: l_balance_type NUMBER ; -- := FND_API.G_MISS_NUM ;
963: l_bas_ytd_ptd NUMBER ; -- := FND_API.G_MISS_NUM ;

Line 961: l_basis_account_key gl_aloc_bas.basis_account_key%TYPE ; -- := FND_API.G_MISS_CHAR ;

957: l_line_no NUMBER ; -- := FND_API.G_MISS_NUM ;
958: l_Item_Id NUMBER ; -- := FND_API.G_MISS_NUM ;
959: l_item_number mtl_item_flexfields.item_number%TYPE ; -- := FND_API.G_MISS_CHAR ;
960: l_basis_account_id gl_aloc_bas.basis_account_id%TYPE ;
961: l_basis_account_key gl_aloc_bas.basis_account_key%TYPE ; -- := FND_API.G_MISS_CHAR ;
962: l_balance_type NUMBER ; -- := FND_API.G_MISS_NUM ;
963: l_bas_ytd_ptd NUMBER ; -- := FND_API.G_MISS_NUM ;
964: l_basis_type NUMBER;
965: l_fixed_percent NUMBER ; -- := FND_API.G_MISS_NUM ;

Line 962: l_balance_type NUMBER ; -- := FND_API.G_MISS_NUM ;

958: l_Item_Id NUMBER ; -- := FND_API.G_MISS_NUM ;
959: l_item_number mtl_item_flexfields.item_number%TYPE ; -- := FND_API.G_MISS_CHAR ;
960: l_basis_account_id gl_aloc_bas.basis_account_id%TYPE ;
961: l_basis_account_key gl_aloc_bas.basis_account_key%TYPE ; -- := FND_API.G_MISS_CHAR ;
962: l_balance_type NUMBER ; -- := FND_API.G_MISS_NUM ;
963: l_bas_ytd_ptd NUMBER ; -- := FND_API.G_MISS_NUM ;
964: l_basis_type NUMBER;
965: l_fixed_percent NUMBER ; -- := FND_API.G_MISS_NUM ;
966: l_cmpntcls_id NUMBER ; -- := FND_API.G_MISS_NUM ;

Line 963: l_bas_ytd_ptd NUMBER ; -- := FND_API.G_MISS_NUM ;

959: l_item_number mtl_item_flexfields.item_number%TYPE ; -- := FND_API.G_MISS_CHAR ;
960: l_basis_account_id gl_aloc_bas.basis_account_id%TYPE ;
961: l_basis_account_key gl_aloc_bas.basis_account_key%TYPE ; -- := FND_API.G_MISS_CHAR ;
962: l_balance_type NUMBER ; -- := FND_API.G_MISS_NUM ;
963: l_bas_ytd_ptd NUMBER ; -- := FND_API.G_MISS_NUM ;
964: l_basis_type NUMBER;
965: l_fixed_percent NUMBER ; -- := FND_API.G_MISS_NUM ;
966: l_cmpntcls_id NUMBER ; -- := FND_API.G_MISS_NUM ;
967: l_cost_cmpntcls_code cm_cmpt_mst.cost_cmpntcls_code%TYPE ; -- := FND_API.G_MISS_CHAR ;

Line 965: l_fixed_percent NUMBER ; -- := FND_API.G_MISS_NUM ;

961: l_basis_account_key gl_aloc_bas.basis_account_key%TYPE ; -- := FND_API.G_MISS_CHAR ;
962: l_balance_type NUMBER ; -- := FND_API.G_MISS_NUM ;
963: l_bas_ytd_ptd NUMBER ; -- := FND_API.G_MISS_NUM ;
964: l_basis_type NUMBER;
965: l_fixed_percent NUMBER ; -- := FND_API.G_MISS_NUM ;
966: l_cmpntcls_id NUMBER ; -- := FND_API.G_MISS_NUM ;
967: l_cost_cmpntcls_code cm_cmpt_mst.cost_cmpntcls_code%TYPE ; -- := FND_API.G_MISS_CHAR ;
968: l_analysis_code cm_alys_mst.cost_analysis_code%TYPE ; -- := FND_API.G_MISS_CHAR ;
969: l_organization_id NUMBER ; -- := FND_API.G_MISS_CHAR ;

Line 966: l_cmpntcls_id NUMBER ; -- := FND_API.G_MISS_NUM ;

962: l_balance_type NUMBER ; -- := FND_API.G_MISS_NUM ;
963: l_bas_ytd_ptd NUMBER ; -- := FND_API.G_MISS_NUM ;
964: l_basis_type NUMBER;
965: l_fixed_percent NUMBER ; -- := FND_API.G_MISS_NUM ;
966: l_cmpntcls_id NUMBER ; -- := FND_API.G_MISS_NUM ;
967: l_cost_cmpntcls_code cm_cmpt_mst.cost_cmpntcls_code%TYPE ; -- := FND_API.G_MISS_CHAR ;
968: l_analysis_code cm_alys_mst.cost_analysis_code%TYPE ; -- := FND_API.G_MISS_CHAR ;
969: l_organization_id NUMBER ; -- := FND_API.G_MISS_CHAR ;
970: l_delete_mark NUMBER ; -- := FND_API.G_MISS_NUM ;

Line 967: l_cost_cmpntcls_code cm_cmpt_mst.cost_cmpntcls_code%TYPE ; -- := FND_API.G_MISS_CHAR ;

963: l_bas_ytd_ptd NUMBER ; -- := FND_API.G_MISS_NUM ;
964: l_basis_type NUMBER;
965: l_fixed_percent NUMBER ; -- := FND_API.G_MISS_NUM ;
966: l_cmpntcls_id NUMBER ; -- := FND_API.G_MISS_NUM ;
967: l_cost_cmpntcls_code cm_cmpt_mst.cost_cmpntcls_code%TYPE ; -- := FND_API.G_MISS_CHAR ;
968: l_analysis_code cm_alys_mst.cost_analysis_code%TYPE ; -- := FND_API.G_MISS_CHAR ;
969: l_organization_id NUMBER ; -- := FND_API.G_MISS_CHAR ;
970: l_delete_mark NUMBER ; -- := FND_API.G_MISS_NUM ;
971: l_user_name fnd_user.user_name%TYPE ; -- := FND_API.G_MISS_CHAR ;

Line 968: l_analysis_code cm_alys_mst.cost_analysis_code%TYPE ; -- := FND_API.G_MISS_CHAR ;

964: l_basis_type NUMBER;
965: l_fixed_percent NUMBER ; -- := FND_API.G_MISS_NUM ;
966: l_cmpntcls_id NUMBER ; -- := FND_API.G_MISS_NUM ;
967: l_cost_cmpntcls_code cm_cmpt_mst.cost_cmpntcls_code%TYPE ; -- := FND_API.G_MISS_CHAR ;
968: l_analysis_code cm_alys_mst.cost_analysis_code%TYPE ; -- := FND_API.G_MISS_CHAR ;
969: l_organization_id NUMBER ; -- := FND_API.G_MISS_CHAR ;
970: l_delete_mark NUMBER ; -- := FND_API.G_MISS_NUM ;
971: l_user_name fnd_user.user_name%TYPE ; -- := FND_API.G_MISS_CHAR ;
972: l_user_id NUMBER ; -- := FND_API.G_MISS_NUM ;

Line 969: l_organization_id NUMBER ; -- := FND_API.G_MISS_CHAR ;

965: l_fixed_percent NUMBER ; -- := FND_API.G_MISS_NUM ;
966: l_cmpntcls_id NUMBER ; -- := FND_API.G_MISS_NUM ;
967: l_cost_cmpntcls_code cm_cmpt_mst.cost_cmpntcls_code%TYPE ; -- := FND_API.G_MISS_CHAR ;
968: l_analysis_code cm_alys_mst.cost_analysis_code%TYPE ; -- := FND_API.G_MISS_CHAR ;
969: l_organization_id NUMBER ; -- := FND_API.G_MISS_CHAR ;
970: l_delete_mark NUMBER ; -- := FND_API.G_MISS_NUM ;
971: l_user_name fnd_user.user_name%TYPE ; -- := FND_API.G_MISS_CHAR ;
972: l_user_id NUMBER ; -- := FND_API.G_MISS_NUM ;
973: l_usage_ind cm_cmpt_mst.usage_ind%TYPE ;

Line 970: l_delete_mark NUMBER ; -- := FND_API.G_MISS_NUM ;

966: l_cmpntcls_id NUMBER ; -- := FND_API.G_MISS_NUM ;
967: l_cost_cmpntcls_code cm_cmpt_mst.cost_cmpntcls_code%TYPE ; -- := FND_API.G_MISS_CHAR ;
968: l_analysis_code cm_alys_mst.cost_analysis_code%TYPE ; -- := FND_API.G_MISS_CHAR ;
969: l_organization_id NUMBER ; -- := FND_API.G_MISS_CHAR ;
970: l_delete_mark NUMBER ; -- := FND_API.G_MISS_NUM ;
971: l_user_name fnd_user.user_name%TYPE ; -- := FND_API.G_MISS_CHAR ;
972: l_user_id NUMBER ; -- := FND_API.G_MISS_NUM ;
973: l_usage_ind cm_cmpt_mst.usage_ind%TYPE ;
974: l_status NUMBER(2) ; -- used for validate basis account

Line 971: l_user_name fnd_user.user_name%TYPE ; -- := FND_API.G_MISS_CHAR ;

967: l_cost_cmpntcls_code cm_cmpt_mst.cost_cmpntcls_code%TYPE ; -- := FND_API.G_MISS_CHAR ;
968: l_analysis_code cm_alys_mst.cost_analysis_code%TYPE ; -- := FND_API.G_MISS_CHAR ;
969: l_organization_id NUMBER ; -- := FND_API.G_MISS_CHAR ;
970: l_delete_mark NUMBER ; -- := FND_API.G_MISS_NUM ;
971: l_user_name fnd_user.user_name%TYPE ; -- := FND_API.G_MISS_CHAR ;
972: l_user_id NUMBER ; -- := FND_API.G_MISS_NUM ;
973: l_usage_ind cm_cmpt_mst.usage_ind%TYPE ;
974: l_status NUMBER(2) ; -- used for validate basis account
975: l_organization_code mtl_parameters.organization_code%TYPE;

Line 972: l_user_id NUMBER ; -- := FND_API.G_MISS_NUM ;

968: l_analysis_code cm_alys_mst.cost_analysis_code%TYPE ; -- := FND_API.G_MISS_CHAR ;
969: l_organization_id NUMBER ; -- := FND_API.G_MISS_CHAR ;
970: l_delete_mark NUMBER ; -- := FND_API.G_MISS_NUM ;
971: l_user_name fnd_user.user_name%TYPE ; -- := FND_API.G_MISS_CHAR ;
972: l_user_id NUMBER ; -- := FND_API.G_MISS_NUM ;
973: l_usage_ind cm_cmpt_mst.usage_ind%TYPE ;
974: l_status NUMBER(2) ; -- used for validate basis account
975: l_organization_code mtl_parameters.organization_code%TYPE;
976:

Line 981: x_return_status := FND_API.G_RET_STS_SUCCESS;

977:
978: BEGIN
979:
980: -- Initialize API return status to success
981: x_return_status := FND_API.G_RET_STS_SUCCESS;
982:
983: l_Alloc_id := p_alloc_def_rec.Alloc_id ;
984: l_alloc_code := p_alloc_def_rec.alloc_code ;
985: l_legal_entity_id := p_alloc_def_rec.legal_entity_id ;

Line 1033: IF (l_alloc_id <> FND_API.G_MISS_NUM) AND

1029: -- If both are sent then use only alloc_id and ignore other params and log a message
1030: -- If both are not sent then raise error.
1031: --
1032:
1033: IF (l_alloc_id <> FND_API.G_MISS_NUM) AND
1034: (l_alloc_id IS NOT NULL) THEN
1035: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1036: log_msg('validating alloc_id : '|| l_alloc_id);
1037: END IF;

Line 1045: RAISE FND_API.G_EXC_ERROR;

1041: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1042: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ALLOC_ID');
1043: FND_MESSAGE.SET_TOKEN('ALLOC_ID',l_alloc_id);
1044: FND_MSG_PUB.Add;
1045: RAISE FND_API.G_EXC_ERROR;
1046: END IF;
1047:
1048: SELECT legal_entity_id
1049: INTO l_legal_entity_id

Line 1058: IF ((l_alloc_code <> FND_API.G_MISS_CHAR) AND

1054: log_msg('legal_entity_id : '|| l_legal_entity_id);
1055: END IF;
1056:
1057: -- Log message if alloc_code and company is also passed
1058: IF ((l_alloc_code <> FND_API.G_MISS_CHAR) AND
1059: (l_alloc_code IS NOT NULL)) OR
1060: ((p_alloc_def_rec.legal_entity_id <> FND_API.G_MISS_NUM) AND
1061: (p_alloc_def_rec.legal_entity_id IS NOT NULL)) THEN
1062: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

Line 1060: ((p_alloc_def_rec.legal_entity_id <> FND_API.G_MISS_NUM) AND

1056:
1057: -- Log message if alloc_code and company is also passed
1058: IF ((l_alloc_code <> FND_API.G_MISS_CHAR) AND
1059: (l_alloc_code IS NOT NULL)) OR
1060: ((p_alloc_def_rec.legal_entity_id <> FND_API.G_MISS_NUM) AND
1061: (p_alloc_def_rec.legal_entity_id IS NOT NULL)) THEN
1062: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1063: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1064: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ALLOC_CODE');

Line 1068: --RAISE FND_API.G_EXC_ERROR;

1064: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ALLOC_CODE');
1065: FND_MESSAGE.SET_TOKEN('ALLOC_CODE',l_alloc_code);
1066: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY',p_alloc_def_rec.legal_entity_id);
1067: FND_MSG_PUB.Add;
1068: --RAISE FND_API.G_EXC_ERROR;
1069: END IF;
1070: END IF;
1071: ELSIF ((l_alloc_code <> FND_API.G_MISS_CHAR) AND
1072: (l_alloc_code IS NOT NULL)) AND

Line 1071: ELSIF ((l_alloc_code <> FND_API.G_MISS_CHAR) AND

1067: FND_MSG_PUB.Add;
1068: --RAISE FND_API.G_EXC_ERROR;
1069: END IF;
1070: END IF;
1071: ELSIF ((l_alloc_code <> FND_API.G_MISS_CHAR) AND
1072: (l_alloc_code IS NOT NULL)) AND
1073: ((l_legal_entity_id <> FND_API.G_MISS_NUM) AND
1074: (l_legal_entity_id IS NOT NULL)) THEN
1075:

Line 1073: ((l_legal_entity_id <> FND_API.G_MISS_NUM) AND

1069: END IF;
1070: END IF;
1071: ELSIF ((l_alloc_code <> FND_API.G_MISS_CHAR) AND
1072: (l_alloc_code IS NOT NULL)) AND
1073: ((l_legal_entity_id <> FND_API.G_MISS_NUM) AND
1074: (l_legal_entity_id IS NOT NULL)) THEN
1075:
1076:
1077: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435

Line 1093: RAISE FND_API.G_EXC_ERROR;

1089: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ALLOC_CODE');
1090: FND_MESSAGE.SET_TOKEN('ALLOC_CODE',l_alloc_code);
1091: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY',l_legal_entity_id);
1092: FND_MSG_PUB.Add;
1093: RAISE FND_API.G_EXC_ERROR;
1094: END IF;
1095: ELSE
1096: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1097: FND_MESSAGE.SET_NAME('GMF','GMF_API_ALLOC_DTL_REQ');

Line 1099: RAISE FND_API.G_EXC_ERROR;

1095: ELSE
1096: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1097: FND_MESSAGE.SET_NAME('GMF','GMF_API_ALLOC_DTL_REQ');
1098: FND_MSG_PUB.Add;
1099: RAISE FND_API.G_EXC_ERROR;
1100: END IF;
1101: -- End Allocation Id
1102:
1103: --

Line 1111: IF (l_alloc_method <> FND_API.G_MISS_NUM) AND

1107: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1108: log_msg('validating alloc_mthd : '||l_alloc_method);
1109: END IF;
1110:
1111: IF (l_alloc_method <> FND_API.G_MISS_NUM) AND
1112: (l_alloc_method IS NOT NULL) THEN
1113: IF (l_alloc_method NOT IN (0,1)) THEN
1114: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1115: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ALLOC_MTHD');

Line 1118: RAISE FND_API.G_EXC_ERROR;

1114: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1115: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ALLOC_MTHD');
1116: FND_MESSAGE.SET_TOKEN('ALLOC_METHOD',l_alloc_method);
1117: FND_MSG_PUB.Add;
1118: RAISE FND_API.G_EXC_ERROR;
1119: END IF;
1120: ELSE
1121: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1122: FND_MESSAGE.SET_NAME('GMF','GMF_API_ALLOC_MTHD_REQ');

Line 1124: RAISE FND_API.G_EXC_ERROR;

1120: ELSE
1121: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1122: FND_MESSAGE.SET_NAME('GMF','GMF_API_ALLOC_MTHD_REQ');
1123: FND_MSG_PUB.Add;
1124: RAISE FND_API.G_EXC_ERROR;
1125: END IF;
1126: -- End Allocation Method
1127:
1128: --

Line 1142: RAISE FND_API.G_EXC_ERROR;

1138: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1139: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ALLOC_DEF');
1140: FND_MESSAGE.SET_TOKEN('ALLOC_METHOD',l_alloc_method);
1141: FND_MSG_PUB.Add;
1142: RAISE FND_API.G_EXC_ERROR;
1143: END IF ;
1144:
1145: --Organization Validation
1146: IF (l_organization_id <> FND_API.G_MISS_NUM)

Line 1146: IF (l_organization_id <> FND_API.G_MISS_NUM)

1142: RAISE FND_API.G_EXC_ERROR;
1143: END IF ;
1144:
1145: --Organization Validation
1146: IF (l_organization_id <> FND_API.G_MISS_NUM)
1147: AND (l_organization_id IS NOT NULL)
1148: THEN
1149: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1150: THEN

Line 1159: RAISE FND_API.G_EXC_ERROR;

1155: THEN
1156: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ORGN_ID');
1157: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',l_organization_id);
1158: FND_MSG_PUB.Add;
1159: RAISE FND_API.G_EXC_ERROR;
1160: END IF;
1161:
1162: -- Log message if organization_code is also passed
1163: IF (l_organization_code <> FND_API.G_MISS_CHAR) AND (l_organization_code IS NOT NULL)

Line 1163: IF (l_organization_code <> FND_API.G_MISS_CHAR) AND (l_organization_code IS NOT NULL)

1159: RAISE FND_API.G_EXC_ERROR;
1160: END IF;
1161:
1162: -- Log message if organization_code is also passed
1163: IF (l_organization_code <> FND_API.G_MISS_CHAR) AND (l_organization_code IS NOT NULL)
1164: THEN
1165:
1166: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1167: THEN

Line 1175: ELSIF ((l_organization_code <> FND_API.G_MISS_CHAR)AND (l_organization_code IS NOT NULL))

1171: FND_MSG_PUB.Add;
1172:
1173: END IF;
1174: END IF;
1175: ELSIF ((l_organization_code <> FND_API.G_MISS_CHAR)AND (l_organization_code IS NOT NULL))
1176: THEN
1177:
1178: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1179: THEN

Line 1195: RAISE FND_API.G_EXC_ERROR;

1191: THEN
1192: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ORGN_CODE');
1193: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
1194: FND_MSG_PUB.Add;
1195: RAISE FND_API.G_EXC_ERROR;
1196: END IF;
1197: ELSE
1198:
1199: FND_MESSAGE.SET_NAME('GMF','GMF_API_ORGN_ID_REQ');

Line 1201: RAISE FND_API.G_EXC_ERROR;

1197: ELSE
1198:
1199: FND_MESSAGE.SET_NAME('GMF','GMF_API_ORGN_ID_REQ');
1200: FND_MSG_PUB.Add;
1201: RAISE FND_API.G_EXC_ERROR;
1202: END IF;
1203:
1204:
1205:

Line 1213: IF (l_item_id <> FND_API.G_MISS_NUM) AND

1209: -- Use item_id if sent otherwise use item_number
1210: -- If both are sent then use only item_id and ignore other params and log a message
1211: -- If both are not sent then raise error.
1212: --
1213: IF (l_item_id <> FND_API.G_MISS_NUM) AND
1214: (l_item_id IS NOT NULL) THEN
1215: -- validate item_id
1216: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1217: log_msg('validating item_id : ' || l_item_id);

Line 1226: RAISE FND_API.G_EXC_ERROR;

1222: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_ID');
1223: FND_MESSAGE.SET_TOKEN('ITEM_ID',l_item_id);
1224: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',l_organization_id);
1225: FND_MSG_PUB.Add;
1226: RAISE FND_API.G_EXC_ERROR;
1227: END IF;
1228:
1229: -- Log message if item_number is also passed
1230: IF (l_item_number <> FND_API.G_MISS_CHAR) AND

Line 1230: IF (l_item_number <> FND_API.G_MISS_CHAR) AND

1226: RAISE FND_API.G_EXC_ERROR;
1227: END IF;
1228:
1229: -- Log message if item_number is also passed
1230: IF (l_item_number <> FND_API.G_MISS_CHAR) AND
1231: (l_item_number IS NOT NULL) THEN
1232: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1233: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1234: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ITEM_NO');

Line 1239: ELSIF (l_item_number <> FND_API.G_MISS_CHAR) AND

1235: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_number);
1236: FND_MSG_PUB.Add;
1237: END IF;
1238: END IF;
1239: ELSIF (l_item_number <> FND_API.G_MISS_CHAR) AND
1240: (l_item_number IS NOT NULL) THEN
1241: -- Convert value into ID.
1242: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1243: log_msg('validating item_number : ' || l_item_number);

Line 1258: RAISE FND_API.G_EXC_ERROR;

1254: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_NO');
1255: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_number);
1256: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',l_organization_id);
1257: FND_MSG_PUB.Add;
1258: RAISE FND_API.G_EXC_ERROR;
1259: END IF;
1260: ELSIF (l_item_number = FND_API.G_MISS_CHAR AND -- Bug 2659435
1261: G_operation = 'UPDATE') OR
1262: (G_operation = 'INSERT') THEN

Line 1260: ELSIF (l_item_number = FND_API.G_MISS_CHAR AND -- Bug 2659435

1256: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',l_organization_id);
1257: FND_MSG_PUB.Add;
1258: RAISE FND_API.G_EXC_ERROR;
1259: END IF;
1260: ELSIF (l_item_number = FND_API.G_MISS_CHAR AND -- Bug 2659435
1261: G_operation = 'UPDATE') OR
1262: (G_operation = 'INSERT') THEN
1263: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1264: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEM_ID_REQ');

Line 1266: RAISE FND_API.G_EXC_ERROR;

1262: (G_operation = 'INSERT') THEN
1263: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1264: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEM_ID_REQ');
1265: FND_MSG_PUB.Add;
1266: RAISE FND_API.G_EXC_ERROR;
1267: END IF;
1268: -- End Item Id
1269:
1270: --

Line 1280: IF (l_basis_account_id <> FND_API.G_MISS_NUM)

1276: log_msg('validating Basis Acct : '|| l_Basis_account_key);
1277: END IF;
1278:
1279: -- Validate Basis Account Key
1280: IF (l_basis_account_id <> FND_API.G_MISS_NUM)
1281: AND (l_basis_account_id IS NOT NULL)
1282: THEN
1283: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1284: THEN

Line 1293: RAISE FND_API.G_EXC_ERROR;

1289: THEN
1290: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ACCT_ID');
1291: FND_MESSAGE.SET_TOKEN('ACCOUNT_ID',l_basis_account_id);
1292: FND_MSG_PUB.Add;
1293: RAISE FND_API.G_EXC_ERROR;
1294: END IF;
1295:
1296:
1297: IF (l_basis_account_key <> FND_API.G_MISS_CHAR) AND (l_basis_account_key IS NOT NULL)

Line 1297: IF (l_basis_account_key <> FND_API.G_MISS_CHAR) AND (l_basis_account_key IS NOT NULL)

1293: RAISE FND_API.G_EXC_ERROR;
1294: END IF;
1295:
1296:
1297: IF (l_basis_account_key <> FND_API.G_MISS_CHAR) AND (l_basis_account_key IS NOT NULL)
1298: THEN
1299:
1300: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1301: THEN

Line 1309: ELSIF (l_Basis_account_key <> FND_API.G_MISS_CHAR) AND

1305: FND_MSG_PUB.Add;
1306:
1307: END IF;
1308: END IF;
1309: ELSIF (l_Basis_account_key <> FND_API.G_MISS_CHAR) AND
1310: (l_Basis_account_key IS NOT NULL) THEN
1311:
1312: l_basis_account_id := GMF_VALIDATIONS_PVT.Validate_Basis_account_key(l_Basis_account_key, l_legal_entity_id) ;
1313:

Line 1319: RAISE FND_API.G_EXC_ERROR;

1315: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1316: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ACCT_NO');
1317: FND_MESSAGE.SET_TOKEN('BAS_ACC_KEY',l_Basis_account_key);
1318: FND_MSG_PUB.Add;
1319: RAISE FND_API.G_EXC_ERROR;
1320: END IF;
1321: ELSIF (l_basis_account_key = FND_API.G_MISS_CHAR AND G_operation = 'UPDATE') OR
1322: (G_operation = 'INSERT') THEN
1323: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435

Line 1321: ELSIF (l_basis_account_key = FND_API.G_MISS_CHAR AND G_operation = 'UPDATE') OR

1317: FND_MESSAGE.SET_TOKEN('BAS_ACC_KEY',l_Basis_account_key);
1318: FND_MSG_PUB.Add;
1319: RAISE FND_API.G_EXC_ERROR;
1320: END IF;
1321: ELSIF (l_basis_account_key = FND_API.G_MISS_CHAR AND G_operation = 'UPDATE') OR
1322: (G_operation = 'INSERT') THEN
1323: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1324: FND_MESSAGE.SET_NAME('GMF','GMF_API_ACCOUNT_ID_REQ');
1325: FND_MSG_PUB.Add;

Line 1326: RAISE FND_API.G_EXC_ERROR;

1322: (G_operation = 'INSERT') THEN
1323: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1324: FND_MESSAGE.SET_NAME('GMF','GMF_API_ACCOUNT_ID_REQ');
1325: FND_MSG_PUB.Add;
1326: RAISE FND_API.G_EXC_ERROR;
1327: END IF;
1328: -- End Basis Account Key
1329:
1330: --

Line 1337: IF (l_balance_type <> FND_API.G_MISS_NUM) AND

1333: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1334: log_msg('validating Balance Type :'|| l_balance_type);
1335: END IF;
1336:
1337: IF (l_balance_type <> FND_API.G_MISS_NUM) AND
1338: (l_balance_type IS NOT NULL) THEN
1339: -- validate Basis Acct Key
1340: IF (l_balance_type NOT IN (0,1,2) ) THEN
1341: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435

Line 1345: RAISE FND_API.G_EXC_ERROR;

1341: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1342: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_BALANCE_TYPE');
1343: FND_MESSAGE.SET_TOKEN('BALANCE_TYPE',l_balance_type);
1344: FND_MSG_PUB.Add;
1345: RAISE FND_API.G_EXC_ERROR;
1346: END IF;
1347: ELSIF (l_balance_type = FND_API.G_MISS_NUM AND -- Bug 2659435
1348: G_operation = 'UPDATE') OR
1349: (G_operation = 'INSERT') THEN

Line 1347: ELSIF (l_balance_type = FND_API.G_MISS_NUM AND -- Bug 2659435

1343: FND_MESSAGE.SET_TOKEN('BALANCE_TYPE',l_balance_type);
1344: FND_MSG_PUB.Add;
1345: RAISE FND_API.G_EXC_ERROR;
1346: END IF;
1347: ELSIF (l_balance_type = FND_API.G_MISS_NUM AND -- Bug 2659435
1348: G_operation = 'UPDATE') OR
1349: (G_operation = 'INSERT') THEN
1350: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1351: FND_MESSAGE.SET_NAME('GMF','GMF_API_BALANCE_TYPE_REQ');

Line 1353: RAISE FND_API.G_EXC_ERROR;

1349: (G_operation = 'INSERT') THEN
1350: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1351: FND_MESSAGE.SET_NAME('GMF','GMF_API_BALANCE_TYPE_REQ');
1352: FND_MSG_PUB.Add;
1353: RAISE FND_API.G_EXC_ERROR;
1354: END IF;
1355: -- End Balance Type
1356:
1357: --

Line 1365: IF (l_bas_ytd_ptd <> FND_API.G_MISS_NUM) AND

1361: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1362: log_msg('validating Basis YTP/PTD :'|| l_bas_ytd_ptd);
1363: END IF;
1364:
1365: IF (l_bas_ytd_ptd <> FND_API.G_MISS_NUM) AND
1366: (l_bas_ytd_ptd IS NOT NULL) THEN
1367: -- validate Basis YTP/PTD
1368: IF (l_bas_ytd_ptd NOT IN (0,1) ) THEN
1369: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435

Line 1373: RAISE FND_API.G_EXC_ERROR;

1369: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1370: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_BAS_YTD_PTD');
1371: FND_MESSAGE.SET_TOKEN('BAS_YTD_PTD',l_bas_ytd_ptd);
1372: FND_MSG_PUB.Add;
1373: RAISE FND_API.G_EXC_ERROR;
1374: END IF;
1375: ELSIF (l_bas_ytd_ptd = FND_API.G_MISS_NUM AND -- Bug 2659435
1376: G_operation = 'UPDATE') OR
1377: (G_operation = 'INSERT') THEN

Line 1375: ELSIF (l_bas_ytd_ptd = FND_API.G_MISS_NUM AND -- Bug 2659435

1371: FND_MESSAGE.SET_TOKEN('BAS_YTD_PTD',l_bas_ytd_ptd);
1372: FND_MSG_PUB.Add;
1373: RAISE FND_API.G_EXC_ERROR;
1374: END IF;
1375: ELSIF (l_bas_ytd_ptd = FND_API.G_MISS_NUM AND -- Bug 2659435
1376: G_operation = 'UPDATE') OR
1377: (G_operation = 'INSERT') THEN
1378: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1379: FND_MESSAGE.SET_NAME('GMF','GMF_API_BAS_YTD_PTD_REQ');

Line 1381: RAISE FND_API.G_EXC_ERROR;

1377: (G_operation = 'INSERT') THEN
1378: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1379: FND_MESSAGE.SET_NAME('GMF','GMF_API_BAS_YTD_PTD_REQ');
1380: FND_MSG_PUB.Add;
1381: RAISE FND_API.G_EXC_ERROR;
1382: END IF;
1383: -- End Basis YTP/PTD
1384:
1385: IF (l_basis_type <> FND_API.G_MISS_NUM) AND

Line 1385: IF (l_basis_type <> FND_API.G_MISS_NUM) AND

1381: RAISE FND_API.G_EXC_ERROR;
1382: END IF;
1383: -- End Basis YTP/PTD
1384:
1385: IF (l_basis_type <> FND_API.G_MISS_NUM) AND
1386: (l_basis_type IS NOT NULL) THEN
1387: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1388: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1389: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_BASIS_TYPE');

Line 1394: IF (l_fixed_percent <> FND_API.G_MISS_NUM) AND

1390: FND_MESSAGE.SET_TOKEN('BASIS_TYPE',l_basis_type);
1391: FND_MSG_PUB.Add;
1392: END IF;
1393: END IF;
1394: IF (l_fixed_percent <> FND_API.G_MISS_NUM) AND
1395: (l_fixed_percent IS NOT NULL) THEN
1396: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1397: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1398: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_FIXED_PERCENT');

Line 1420: IF (l_basis_type <> FND_API.G_MISS_NUM) AND(l_basis_type IS NOT NULL) THEN

1416: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1417: log_msg('validating basis type :'||l_basis_type);
1418: END IF;
1419:
1420: IF (l_basis_type <> FND_API.G_MISS_NUM) AND(l_basis_type IS NOT NULL) THEN
1421: IF (l_basis_type <> 1) THEN
1422: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1423: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_BASIS_TYPE');
1424: FND_MESSAGE.SET_TOKEN('BASIS_TYPE',l_basis_type);

Line 1426: RAISE FND_API.G_EXC_ERROR;

1422: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1423: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_BASIS_TYPE');
1424: FND_MESSAGE.SET_TOKEN('BASIS_TYPE',l_basis_type);
1425: FND_MSG_PUB.Add;
1426: RAISE FND_API.G_EXC_ERROR;
1427: END IF;
1428: ELSE
1429: l_basis_type := 1;
1430: END IF;

Line 1438: IF (l_fixed_percent <> FND_API.G_MISS_NUM) AND(l_fixed_percent IS NOT NULL) THEN

1434: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1435: log_msg('validating fixed percentage :'||l_fixed_percent);
1436: END IF;
1437:
1438: IF (l_fixed_percent <> FND_API.G_MISS_NUM) AND(l_fixed_percent IS NOT NULL) THEN
1439: IF (l_fixed_percent < 0 OR l_fixed_percent > 100) THEN
1440: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1441: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_FIXED_PERCENT');
1442: FND_MESSAGE.SET_TOKEN('FIXED_PERCENT',l_fixed_percent);

Line 1444: RAISE FND_API.G_EXC_ERROR;

1440: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1441: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_FIXED_PERCENT');
1442: FND_MESSAGE.SET_TOKEN('FIXED_PERCENT',l_fixed_percent);
1443: FND_MSG_PUB.Add;
1444: RAISE FND_API.G_EXC_ERROR;
1445: END IF;
1446: ELSIF (l_fixed_percent = FND_API.G_MISS_NUM AND G_operation = 'UPDATE') OR
1447: (G_operation = 'INSERT') THEN
1448: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435

Line 1446: ELSIF (l_fixed_percent = FND_API.G_MISS_NUM AND G_operation = 'UPDATE') OR

1442: FND_MESSAGE.SET_TOKEN('FIXED_PERCENT',l_fixed_percent);
1443: FND_MSG_PUB.Add;
1444: RAISE FND_API.G_EXC_ERROR;
1445: END IF;
1446: ELSIF (l_fixed_percent = FND_API.G_MISS_NUM AND G_operation = 'UPDATE') OR
1447: (G_operation = 'INSERT') THEN
1448: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1449: FND_MESSAGE.SET_NAME('GMF','GMF_API_FIXED_PERCENT_REQ');
1450: FND_MSG_PUB.Add;

Line 1451: RAISE FND_API.G_EXC_ERROR;

1447: (G_operation = 'INSERT') THEN
1448: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1449: FND_MESSAGE.SET_NAME('GMF','GMF_API_FIXED_PERCENT_REQ');
1450: FND_MSG_PUB.Add;
1451: RAISE FND_API.G_EXC_ERROR;
1452: END IF;
1453: IF( ((p_alloc_def_rec.basis_account_id <> FND_API.G_MISS_NUM) AND
1454: (p_alloc_def_rec.basis_account_id IS NOT NULL)) OR
1455: ((p_alloc_def_rec.basis_account_key <> FND_API.G_MISS_CHAR) AND

Line 1453: IF( ((p_alloc_def_rec.basis_account_id <> FND_API.G_MISS_NUM) AND

1449: FND_MESSAGE.SET_NAME('GMF','GMF_API_FIXED_PERCENT_REQ');
1450: FND_MSG_PUB.Add;
1451: RAISE FND_API.G_EXC_ERROR;
1452: END IF;
1453: IF( ((p_alloc_def_rec.basis_account_id <> FND_API.G_MISS_NUM) AND
1454: (p_alloc_def_rec.basis_account_id IS NOT NULL)) OR
1455: ((p_alloc_def_rec.basis_account_key <> FND_API.G_MISS_CHAR) AND
1456: (p_alloc_def_rec.basis_account_key IS NOT NULL)) OR
1457: ((p_alloc_def_rec.balance_type <> FND_API.G_MISS_NUM) AND

Line 1455: ((p_alloc_def_rec.basis_account_key <> FND_API.G_MISS_CHAR) AND

1451: RAISE FND_API.G_EXC_ERROR;
1452: END IF;
1453: IF( ((p_alloc_def_rec.basis_account_id <> FND_API.G_MISS_NUM) AND
1454: (p_alloc_def_rec.basis_account_id IS NOT NULL)) OR
1455: ((p_alloc_def_rec.basis_account_key <> FND_API.G_MISS_CHAR) AND
1456: (p_alloc_def_rec.basis_account_key IS NOT NULL)) OR
1457: ((p_alloc_def_rec.balance_type <> FND_API.G_MISS_NUM) AND
1458: (p_alloc_def_rec.balance_type IS NOT NULL)) OR
1459: ((p_alloc_def_rec.bas_ytd_ptd <> FND_API.G_MISS_NUM) AND

Line 1457: ((p_alloc_def_rec.balance_type <> FND_API.G_MISS_NUM) AND

1453: IF( ((p_alloc_def_rec.basis_account_id <> FND_API.G_MISS_NUM) AND
1454: (p_alloc_def_rec.basis_account_id IS NOT NULL)) OR
1455: ((p_alloc_def_rec.basis_account_key <> FND_API.G_MISS_CHAR) AND
1456: (p_alloc_def_rec.basis_account_key IS NOT NULL)) OR
1457: ((p_alloc_def_rec.balance_type <> FND_API.G_MISS_NUM) AND
1458: (p_alloc_def_rec.balance_type IS NOT NULL)) OR
1459: ((p_alloc_def_rec.bas_ytd_ptd <> FND_API.G_MISS_NUM) AND
1460: (p_alloc_def_rec.bas_ytd_ptd IS NOT NULL))
1461: ) THEN

Line 1459: ((p_alloc_def_rec.bas_ytd_ptd <> FND_API.G_MISS_NUM) AND

1455: ((p_alloc_def_rec.basis_account_key <> FND_API.G_MISS_CHAR) AND
1456: (p_alloc_def_rec.basis_account_key IS NOT NULL)) OR
1457: ((p_alloc_def_rec.balance_type <> FND_API.G_MISS_NUM) AND
1458: (p_alloc_def_rec.balance_type IS NOT NULL)) OR
1459: ((p_alloc_def_rec.bas_ytd_ptd <> FND_API.G_MISS_NUM) AND
1460: (p_alloc_def_rec.bas_ytd_ptd IS NOT NULL))
1461: ) THEN
1462: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1463: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435

Line 1481: IF (l_cmpntcls_id <> FND_API.G_MISS_NUM) AND

1477: -- Use cmpntcls_id if sent otherwise use cmpntcls_code
1478: -- If both are sent then use only cmpntcls_id and ignore other params and log a message
1479: -- If both are not sent then raise error.
1480: --
1481: IF (l_cmpntcls_id <> FND_API.G_MISS_NUM) AND
1482: (l_cmpntcls_id IS NOT NULL) THEN
1483: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1484: log_msg('validating Cmpt Cls ID :'|| l_cmpntcls_id);
1485: END IF;

Line 1496: RAISE FND_API.G_EXC_ERROR;

1492: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1493: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CMPNTCLS_ID');
1494: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID',l_cmpntcls_id);
1495: FND_MSG_PUB.Add;
1496: RAISE FND_API.G_EXC_ERROR;
1497: ELSIF l_usage_ind <> 4 THEN
1498: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1499: FND_MESSAGE.SET_NAME('GMF','GMF_API_CMPNTCLS_USG_NOT_ALC');
1500: FND_MESSAGE.SET_TOKEN('CMPNTCLS',l_cmpntcls_id);

Line 1502: RAISE FND_API.G_EXC_ERROR;

1498: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1499: FND_MESSAGE.SET_NAME('GMF','GMF_API_CMPNTCLS_USG_NOT_ALC');
1500: FND_MESSAGE.SET_TOKEN('CMPNTCLS',l_cmpntcls_id);
1501: FND_MSG_PUB.Add;
1502: RAISE FND_API.G_EXC_ERROR;
1503: END IF;
1504:
1505: -- Log message if cost_cmpntcls_code is also passed
1506: IF (p_alloc_def_rec.cost_cmpntcls_code <> FND_API.G_MISS_CHAR) AND

Line 1506: IF (p_alloc_def_rec.cost_cmpntcls_code <> FND_API.G_MISS_CHAR) AND

1502: RAISE FND_API.G_EXC_ERROR;
1503: END IF;
1504:
1505: -- Log message if cost_cmpntcls_code is also passed
1506: IF (p_alloc_def_rec.cost_cmpntcls_code <> FND_API.G_MISS_CHAR) AND
1507: (p_alloc_def_rec.cost_cmpntcls_code IS NOT NULL) THEN
1508: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1509: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1510: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_CMPNTCLS_CODE');

Line 1515: ELSIF (l_cost_cmpntcls_code <> FND_API.G_MISS_CHAR) AND

1511: FND_MESSAGE.SET_TOKEN('CMPNTCLS_CODE',p_alloc_def_rec.cost_cmpntcls_code);
1512: FND_MSG_PUB.Add;
1513: END IF;
1514: END IF;
1515: ELSIF (l_cost_cmpntcls_code <> FND_API.G_MISS_CHAR) AND
1516: (l_cost_cmpntcls_code IS NOT NULL) THEN
1517: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1518: log_msg('validating Cmpt Cls Code :'|| l_cost_cmpntcls_code);
1519: END IF;

Line 1537: RAISE FND_API.G_EXC_ERROR;

1533: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1534: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CMPNTCLS_CODE');
1535: FND_MESSAGE.SET_TOKEN('CMPNTCLS_CODE',l_cost_cmpntcls_code);
1536: FND_MSG_PUB.Add;
1537: RAISE FND_API.G_EXC_ERROR;
1538: ELSIF l_usage_ind <> 4 THEN
1539: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1540: FND_MESSAGE.SET_NAME('GMF','GMF_API_CMPNTCLS_USG_NOT_ALC');
1541: FND_MESSAGE.SET_TOKEN('CMPNTCLS',l_cost_cmpntcls_code);

Line 1543: RAISE FND_API.G_EXC_ERROR;

1539: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1540: FND_MESSAGE.SET_NAME('GMF','GMF_API_CMPNTCLS_USG_NOT_ALC');
1541: FND_MESSAGE.SET_TOKEN('CMPNTCLS',l_cost_cmpntcls_code);
1542: FND_MSG_PUB.Add;
1543: RAISE FND_API.G_EXC_ERROR;
1544: END IF;
1545: ELSIF (l_cmpntcls_id = FND_API.G_MISS_NUM AND -- Bug 2659435
1546: G_operation = 'UPDATE') OR
1547: (G_operation = 'INSERT') THEN

Line 1545: ELSIF (l_cmpntcls_id = FND_API.G_MISS_NUM AND -- Bug 2659435

1541: FND_MESSAGE.SET_TOKEN('CMPNTCLS',l_cost_cmpntcls_code);
1542: FND_MSG_PUB.Add;
1543: RAISE FND_API.G_EXC_ERROR;
1544: END IF;
1545: ELSIF (l_cmpntcls_id = FND_API.G_MISS_NUM AND -- Bug 2659435
1546: G_operation = 'UPDATE') OR
1547: (G_operation = 'INSERT') THEN
1548: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1549: FND_MESSAGE.SET_NAME('GMF','GMF_API_CMPNTCLS_ID_REQ');

Line 1551: RAISE FND_API.G_EXC_ERROR;

1547: (G_operation = 'INSERT') THEN
1548: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1549: FND_MESSAGE.SET_NAME('GMF','GMF_API_CMPNTCLS_ID_REQ');
1550: FND_MSG_PUB.Add;
1551: RAISE FND_API.G_EXC_ERROR;
1552: END IF;
1553: -- End CmpntCls Id
1554:
1555: --

Line 1562: IF (l_analysis_code <> FND_API.G_MISS_CHAR) AND

1558: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1559: log_msg('validating analysis_code :' || l_analysis_code);
1560: END IF;
1561:
1562: IF (l_analysis_code <> FND_API.G_MISS_CHAR) AND
1563: (l_analysis_code IS NOT NULL) THEN
1564: IF NOT GMF_VALIDATIONS_PVT.Validate_Analysis_Code(l_analysis_code)
1565: THEN
1566: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435

Line 1570: RAISE FND_API.G_EXC_ERROR;

1566: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1567: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ANALYSIS_CODE');
1568: FND_MESSAGE.SET_TOKEN('ANALYSIS_CODE',l_analysis_code);
1569: FND_MSG_PUB.Add;
1570: RAISE FND_API.G_EXC_ERROR;
1571: END IF;
1572: ELSIF (l_analysis_code = FND_API.G_MISS_CHAR AND -- Bug 2659435
1573: G_operation = 'UPDATE') OR
1574: (G_operation = 'INSERT') THEN

Line 1572: ELSIF (l_analysis_code = FND_API.G_MISS_CHAR AND -- Bug 2659435

1568: FND_MESSAGE.SET_TOKEN('ANALYSIS_CODE',l_analysis_code);
1569: FND_MSG_PUB.Add;
1570: RAISE FND_API.G_EXC_ERROR;
1571: END IF;
1572: ELSIF (l_analysis_code = FND_API.G_MISS_CHAR AND -- Bug 2659435
1573: G_operation = 'UPDATE') OR
1574: (G_operation = 'INSERT') THEN
1575: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1576: FND_MESSAGE.SET_NAME('GMF','GMF_API_ANALYSIS_CODE_REQ');

Line 1578: RAISE FND_API.G_EXC_ERROR;

1574: (G_operation = 'INSERT') THEN
1575: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1576: FND_MESSAGE.SET_NAME('GMF','GMF_API_ANALYSIS_CODE_REQ');
1577: FND_MSG_PUB.Add;
1578: RAISE FND_API.G_EXC_ERROR;
1579: END IF;
1580: -- End Analysis Code
1581: --
1582: -- Delete Mark

Line 1584: IF (l_delete_mark <> FND_API.G_MISS_NUM) AND

1580: -- End Analysis Code
1581: --
1582: -- Delete Mark
1583: --
1584: IF (l_delete_mark <> FND_API.G_MISS_NUM) AND
1585: (l_delete_mark IS NOT NULL) THEN
1586: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1587: log_msg('validating delete_mark :' || l_delete_mark);
1588: END IF;

Line 1595: RAISE FND_API.G_EXC_ERROR;

1591: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1592: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_DELETE_MARK');
1593: FND_MESSAGE.SET_TOKEN('DELETE_MARK',l_delete_mark);
1594: FND_MSG_PUB.Add;
1595: RAISE FND_API.G_EXC_ERROR;
1596: END IF;
1597: ELSIF (l_delete_mark = FND_API.G_MISS_NUM AND G_operation = 'UPDATE') OR
1598: (G_operation = 'INSERT') THEN
1599: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435

Line 1597: ELSIF (l_delete_mark = FND_API.G_MISS_NUM AND G_operation = 'UPDATE') OR

1593: FND_MESSAGE.SET_TOKEN('DELETE_MARK',l_delete_mark);
1594: FND_MSG_PUB.Add;
1595: RAISE FND_API.G_EXC_ERROR;
1596: END IF;
1597: ELSIF (l_delete_mark = FND_API.G_MISS_NUM AND G_operation = 'UPDATE') OR
1598: (G_operation = 'INSERT') THEN
1599: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1600: FND_MESSAGE.SET_NAME('GMF','GMF_API_DELETE_MARK_REQ');
1601: FND_MSG_PUB.Add;

Line 1602: RAISE FND_API.G_EXC_ERROR;

1598: (G_operation = 'INSERT') THEN
1599: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1600: FND_MESSAGE.SET_NAME('GMF','GMF_API_DELETE_MARK_REQ');
1601: FND_MSG_PUB.Add;
1602: RAISE FND_API.G_EXC_ERROR;
1603: END IF;
1604: -- End Delete Mark
1605:
1606: -- Populate WHO columns

Line 1611: IF (l_user_name <> FND_API.G_MISS_CHAR) AND

1607: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1608: log_msg('Validating user name : ' || l_user_name);
1609: END IF;
1610:
1611: IF (l_user_name <> FND_API.G_MISS_CHAR) AND
1612: (l_user_name IS NOT NULL) THEN
1613: GMA_GLOBAL_GRP.Get_who( p_user_name => l_user_name
1614: , x_user_id => l_user_id
1615: );

Line 1622: RAISE FND_API.G_EXC_ERROR;

1618: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1619: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_USER_NAME');
1620: FND_MESSAGE.SET_TOKEN('USER_NAME',l_user_name);
1621: FND_MSG_PUB.Add;
1622: RAISE FND_API.G_EXC_ERROR;
1623: END IF;
1624: ELSE
1625: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1626: FND_MESSAGE.SET_NAME('GMF','GMF_API_USER_NAME_REQ');

Line 1628: RAISE FND_API.G_EXC_ERROR;

1624: ELSE
1625: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1626: FND_MESSAGE.SET_NAME('GMF','GMF_API_USER_NAME_REQ');
1627: FND_MSG_PUB.Add;
1628: RAISE FND_API.G_EXC_ERROR;
1629: END IF;
1630: -- End User Name
1631:
1632:

Line 1655: WHEN FND_API.G_EXC_ERROR THEN

1651: x_alloc_def_rec.user_name := l_user_name ;
1652: x_user_id := l_user_id ;
1653:
1654: EXCEPTION -- Bug 2681243: removed when others to capture ORA errors.
1655: WHEN FND_API.G_EXC_ERROR THEN
1656: x_return_status := FND_API.G_RET_STS_ERROR ;
1657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1659: END Validate_Input_Params;

Line 1656: x_return_status := FND_API.G_RET_STS_ERROR ;

1652: x_user_id := l_user_id ;
1653:
1654: EXCEPTION -- Bug 2681243: removed when others to capture ORA errors.
1655: WHEN FND_API.G_EXC_ERROR THEN
1656: x_return_status := FND_API.G_RET_STS_ERROR ;
1657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1659: END Validate_Input_Params;
1660:

Line 1657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1653:
1654: EXCEPTION -- Bug 2681243: removed when others to capture ORA errors.
1655: WHEN FND_API.G_EXC_ERROR THEN
1656: x_return_status := FND_API.G_RET_STS_ERROR ;
1657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1659: END Validate_Input_Params;
1660:
1661: -- Func start of comments

Line 1658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1654: EXCEPTION -- Bug 2681243: removed when others to capture ORA errors.
1655: WHEN FND_API.G_EXC_ERROR THEN
1656: x_return_status := FND_API.G_RET_STS_ERROR ;
1657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1659: END Validate_Input_Params;
1660:
1661: -- Func start of comments
1662: --+==========================================================================+