DBA Data[Home] [Help]

APPS.FUN_WEBADI_PKG dependencies on FND_API

Line 401: l_insert := FND_API.G_TRUE;

397: End Loop;
398: End If;
399:
400: IF (p_batch_insert ='Y') THEN
401: l_insert := FND_API.G_TRUE;
402: ELSE
403: l_insert := FND_API.G_FALSE;
404: END IF;
405:

Line 403: l_insert := FND_API.G_FALSE;

399:
400: IF (p_batch_insert ='Y') THEN
401: l_insert := FND_API.G_TRUE;
402: ELSE
403: l_insert := FND_API.G_FALSE;
404: END IF;
405:
406: Fun_Trx_Pvt.Init_Batch_Validate (
407: 1.0,

Line 408: Fnd_Api.G_TRUE,

404: END IF;
405:
406: Fun_Trx_Pvt.Init_Batch_Validate (
407: 1.0,
408: Fnd_Api.G_TRUE,
409: l_validation_level,
410: l_return_status,
411: l_msg_count,
412: l_msg_data,

Line 418: If l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR Then

414: l_batch_rec,
415: l_trx_tbl,
416: l_init_dist_tbl,
417: l_dist_lines_tbl);
418: If l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR Then
419: Raise Fnd_Api.G_EXC_UNEXPECTED_ERROR;
420: Elsif l_return_status = Fnd_Api.G_RET_STS_ERROR Then
421: Raise Fnd_Api.G_EXC_ERROR;
422: End If;

Line 419: Raise Fnd_Api.G_EXC_UNEXPECTED_ERROR;

415: l_trx_tbl,
416: l_init_dist_tbl,
417: l_dist_lines_tbl);
418: If l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR Then
419: Raise Fnd_Api.G_EXC_UNEXPECTED_ERROR;
420: Elsif l_return_status = Fnd_Api.G_RET_STS_ERROR Then
421: Raise Fnd_Api.G_EXC_ERROR;
422: End If;
423:

Line 420: Elsif l_return_status = Fnd_Api.G_RET_STS_ERROR Then

416: l_init_dist_tbl,
417: l_dist_lines_tbl);
418: If l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR Then
419: Raise Fnd_Api.G_EXC_UNEXPECTED_ERROR;
420: Elsif l_return_status = Fnd_Api.G_RET_STS_ERROR Then
421: Raise Fnd_Api.G_EXC_ERROR;
422: End If;
423:
424: l_trx_tbl.Delete;

Line 421: Raise Fnd_Api.G_EXC_ERROR;

417: l_dist_lines_tbl);
418: If l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR Then
419: Raise Fnd_Api.G_EXC_UNEXPECTED_ERROR;
420: Elsif l_return_status = Fnd_Api.G_RET_STS_ERROR Then
421: Raise Fnd_Api.G_EXC_ERROR;
422: End If;
423:
424: l_trx_tbl.Delete;
425: l_init_dist_tbl.Delete;

Line 473: Fnd_Api.G_TRUE,

469: l_msg_data := null;
470:
471: Fun_Trx_Pvt.Init_Trx_Validate (
472: 1.0,
473: Fnd_Api.G_TRUE,
474: l_validation_level,
475: l_return_status,
476: l_msg_count,
477: l_msg_data,

Line 484: If l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR Then

480: l_batch_rec.currency_code,
481: l_batch_rec.gl_date,
482: l_batch_rec.batch_date,
483: l_batch_rec.exchange_rate_type);
484: If l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR Then
485: Raise Fnd_Api.G_EXC_UNEXPECTED_ERROR;
486: Elsif l_return_status = Fnd_Api.G_RET_STS_ERROR Then
487: Raise Fnd_Api.G_EXC_ERROR;
488: End If;

Line 485: Raise Fnd_Api.G_EXC_UNEXPECTED_ERROR;

481: l_batch_rec.gl_date,
482: l_batch_rec.batch_date,
483: l_batch_rec.exchange_rate_type);
484: If l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR Then
485: Raise Fnd_Api.G_EXC_UNEXPECTED_ERROR;
486: Elsif l_return_status = Fnd_Api.G_RET_STS_ERROR Then
487: Raise Fnd_Api.G_EXC_ERROR;
488: End If;
489:

Line 486: Elsif l_return_status = Fnd_Api.G_RET_STS_ERROR Then

482: l_batch_rec.batch_date,
483: l_batch_rec.exchange_rate_type);
484: If l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR Then
485: Raise Fnd_Api.G_EXC_UNEXPECTED_ERROR;
486: Elsif l_return_status = Fnd_Api.G_RET_STS_ERROR Then
487: Raise Fnd_Api.G_EXC_ERROR;
488: End If;
489:
490: If p_dist_lines_tbl is not null Then

Line 487: Raise Fnd_Api.G_EXC_ERROR;

483: l_batch_rec.exchange_rate_type);
484: If l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR Then
485: Raise Fnd_Api.G_EXC_UNEXPECTED_ERROR;
486: Elsif l_return_status = Fnd_Api.G_RET_STS_ERROR Then
487: Raise Fnd_Api.G_EXC_ERROR;
488: End If;
489:
490: If p_dist_lines_tbl is not null Then
491: For l_count In 1..p_dist_lines_tbl.count Loop

Line 526: Fnd_Api.G_TRUE,

522: -- Pass Recipient Legal entity Id
523:
524: Fun_Trx_Pvt.Init_IC_Dist_Validate (
525: 1.0,
526: Fnd_Api.G_TRUE,
527: l_validation_level,
528: l_to_le_id,
529: l_trx_rec_type.to_ledger_id,
530: --p_batch_rec.from_ledger_id,

Line 541: Fnd_Api.G_TRUE,

537: -- Changes complete for Bug # 6249898
538:
539: Fun_Trx_Pvt.Init_IC_Dist_Validate (
540: 1.0,
541: Fnd_Api.G_TRUE,
542: l_validation_level,
543: p_batch_rec.from_le_id,
544: p_batch_rec.from_ledger_id,
545: l_return_status,

Line 552: If l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR Then

548: l_dist_lines_rec_type);
549:
550: End If;
551:
552: If l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR Then
553: Raise Fnd_Api.G_EXC_UNEXPECTED_ERROR;
554: Elsif l_return_status = Fnd_Api.G_RET_STS_ERROR Then
555: Raise Fnd_Api.G_EXC_ERROR;
556: End If;

Line 553: Raise Fnd_Api.G_EXC_UNEXPECTED_ERROR;

549:
550: End If;
551:
552: If l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR Then
553: Raise Fnd_Api.G_EXC_UNEXPECTED_ERROR;
554: Elsif l_return_status = Fnd_Api.G_RET_STS_ERROR Then
555: Raise Fnd_Api.G_EXC_ERROR;
556: End If;
557: End Loop;

Line 554: Elsif l_return_status = Fnd_Api.G_RET_STS_ERROR Then

550: End If;
551:
552: If l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR Then
553: Raise Fnd_Api.G_EXC_UNEXPECTED_ERROR;
554: Elsif l_return_status = Fnd_Api.G_RET_STS_ERROR Then
555: Raise Fnd_Api.G_EXC_ERROR;
556: End If;
557: End Loop;
558: End If;

Line 555: Raise Fnd_Api.G_EXC_ERROR;

551:
552: If l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR Then
553: Raise Fnd_Api.G_EXC_UNEXPECTED_ERROR;
554: Elsif l_return_status = Fnd_Api.G_RET_STS_ERROR Then
555: Raise Fnd_Api.G_EXC_ERROR;
556: End If;
557: End Loop;
558: End If;
559: End Validate_Record;

Line 565: p_encoded => Fnd_Api.G_FALSE);

561: Procedure Get_Message_Text(p_data In Out NOCOPY Varchar2) Is
562: Begin
563: p_data := Fnd_Msg_Pub.Get(
564: p_msg_index => Fnd_Msg_Pub.G_FIRST,
565: p_encoded => Fnd_Api.G_FALSE);
566: End Get_Message_Text;
567:
568: Procedure Upload_Batch(
569: p_batch_number In Fun_Interface_Batches.batch_number%type,

Line 1392: When Fnd_Api.G_EXC_UNEXPECTED_ERROR Then

1388: Rollback;
1389: Fnd_Message.Set_Name('FUN','FUN_ADI_INVALID_DRCR_DIST');
1390: Fnd_Message.Set_Token('TRX_NUMBER', p_trx_number);
1391: Fnd_Message.Raise_Error;
1392: When Fnd_Api.G_EXC_UNEXPECTED_ERROR Then
1393: Rollback;
1394: Get_Message_Text(l_data);
1395: Fnd_Message.Set_Name('FUN', 'FUN_ADI_ERROR');
1396: Fnd_Message.Set_Token('ERROR', l_data);

Line 1398: When Fnd_Api.G_EXC_ERROR Then

1394: Get_Message_Text(l_data);
1395: Fnd_Message.Set_Name('FUN', 'FUN_ADI_ERROR');
1396: Fnd_Message.Set_Token('ERROR', l_data);
1397: Fnd_Message.Raise_Error;
1398: When Fnd_Api.G_EXC_ERROR Then
1399: Rollback;
1400: Get_Message_Text(l_data);
1401: Fnd_Message.Set_Name('FUN', 'FUN_ADI_ERROR');
1402: Fnd_Message.Set_Token('ERROR', l_data);