DBA Data[Home] [Help]

APPS.AP_PMT_CALLOUT_PKG dependencies on FND_API

Line 181: x_return_status := FND_API.G_RET_STS_SUCCESS;

177:
178: BEGIN
179:
180: /* Initialize return status */
181: x_return_status := FND_API.G_RET_STS_SUCCESS;
182:
183: if p_seq_num_profile = 'P' and
184: x_msg_data is not null then
185: return; --return without raising an error

Line 208: x_return_status:= FND_API.G_RET_STS_ERROR;

204:
205: if (l_return_code <> 0 or l_int_seqval is null) and
206: p_seq_num_profile = 'A' then
207:
208: x_return_status:= FND_API.G_RET_STS_ERROR;
209: x_msg_count:= 1;
210: x_msg_data := 'Invalid Interest Invoice Sequence';
211: return;
212:

Line 280: x_return_status := FND_API.G_RET_STS_SUCCESS;

276: BEGIN
277:
278:
279: /* Initialize return status */
280: x_return_status := FND_API.G_RET_STS_SUCCESS;
281:
282: l_api_name := 'assign_sequences';
283:
284: -- Bug 5512197.Adding Fnd_Logging for this procedure

Line 318: -- x_return_status:= FND_API.G_RET_STS_ERROR; --Bug6258525

314: -- Bug 5555642. Added fnd-logging and messages for sequence numbering
315: --if p_seq_num_profile = 'A' and l_doc_category_code = '-1' then
316: -- Bug 5555642
317: if l_doc_category_code = '-1' then
318: -- x_return_status:= FND_API.G_RET_STS_ERROR; --Bug6258525
319: x_msg_count:= 1;
320: if p_seq_num_profile = 'P' then
321: x_msg_data := 'No document category found and sequential number is set to partially used';
322: l_debug_info := 'No document category found from CE API and sequential number is set to '||

Line 328: x_return_status:= FND_API.G_RET_STS_ERROR; --Bug6258525

324: elsif p_seq_num_profile = 'A' then
325: x_msg_data := 'No document category found and sequential number is set to always used';
326: l_debug_info := 'No document category found from CE API and sequential number is set to '||
327: 'always used';
328: x_return_status:= FND_API.G_RET_STS_ERROR; --Bug6258525
329: end if;
330: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
331: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
332: END IF;

Line 417: x_return_status:= FND_API.G_RET_STS_ERROR;

413: END IF;
414:
415:
416: if x_msg_data is not null then
417: x_return_status:= FND_API.G_RET_STS_ERROR;
418: x_msg_count:= 1;
419: l_debug_info := x_msg_data;
420: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
421: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 457: x_return_status:= FND_API.G_RET_STS_ERROR;

453: END IF;
454:
455: if l_return_code <> 0 or l_seqval is null then
456:
457: x_return_status:= FND_API.G_RET_STS_ERROR;
458: x_msg_count:= 1;
459: x_msg_data := 'Invalid Sequence';
460: return;
461:

Line 514: x_return_status:= FND_API.G_RET_STS_ERROR;

510: x_msg_data := 'Invalid document sequence setup for interest invoices';
511: end if;
512:
513: if x_msg_data is not null and p_seq_num_profile = 'A' then
514: x_return_status:= FND_API.G_RET_STS_ERROR;
515: x_msg_count:= 1;
516: return;
517: end if;
518:

Line 528: if x_return_status = FND_API.G_RET_STS_ERROR then

524: x_return_status,
525: x_msg_count,
526: x_msg_data);
527:
528: if x_return_status = FND_API.G_RET_STS_ERROR then
529: return;
530: end if;
531:
532:

Line 660: x_return_status := FND_API.G_RET_STS_SUCCESS;

656: from iby_fd_docs_payable_v
657: where rejected_docs_group_id = p_rejected_docs_group_id);
658:
659:
660: x_return_status := FND_API.G_RET_STS_SUCCESS;
661:
662: EXCEPTION
663: WHEN OTHERS THEN
664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

660: x_return_status := FND_API.G_RET_STS_SUCCESS;
661:
662: EXCEPTION
663: WHEN OTHERS THEN
664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
665:
666: END documents_payable_rejected;
667:
668:

Line 916: /* IF FND_API.to_boolean(p_init_msg_list) THEN

912:
913: --Bug 5115310
914:
915: /* Initialize message list if p_init_msg_list is set to TRUE */
916: /* IF FND_API.to_boolean(p_init_msg_list) THEN
917: FND_MSG_PUB.initialize;
918: END IF;
919: */
920: /* Initialize return status */

Line 921: x_return_status := FND_API.G_RET_STS_SUCCESS;

917: FND_MSG_PUB.initialize;
918: END IF;
919: */
920: /* Initialize return status */
921: x_return_status := FND_API.G_RET_STS_SUCCESS;
922:
923: l_debug_info := 'get_relevant_checkrun_ids';
924: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
925: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 2410: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

2406: l_interest_invoice_count,
2407: l_check_date,
2408: l_current_org_id);
2409:
2410: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2411: RETURN;
2412: END IF;
2413:
2414: END IF;

Line 2522: x_return_status := FND_API.G_RET_STS_ERROR;

2518: --Bug 5115363
2519: IF (l_total_check_count <> l_iby_check_count) OR
2520: (l_total_docs_count <> l_iby_docs_count) THEN
2521:
2522: x_return_status := FND_API.G_RET_STS_ERROR;
2523:
2524: FND_MESSAGE.set_name('SQLAP', 'AP_IBY_PMT_MISMATCH');
2525: FND_MSG_PUB.ADD;
2526: FND_MSG_PUB.COUNT_AND_GET(

Line 2533: x_return_status := FND_API.G_RET_STS_SUCCESS;

2529: );
2530:
2531: ELSE
2532:
2533: x_return_status := FND_API.G_RET_STS_SUCCESS;
2534:
2535: END IF;
2536:
2537:

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

2590: END;
2591:
2592: PROCEDURE Payment_Voided
2593: ( p_api_version IN NUMBER,
2594: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2595: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2596: p_payment_id IN NUMBER,
2597: p_void_date IN DATE,
2598: -- p_accounting_date IN DATE, /* Bug 4775938 */

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

2591:
2592: PROCEDURE Payment_Voided
2593: ( p_api_version IN NUMBER,
2594: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2595: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2596: p_payment_id IN NUMBER,
2597: p_void_date IN DATE,
2598: -- p_accounting_date IN DATE, /* Bug 4775938 */
2599: x_return_status OUT nocopy VARCHAR2,

Line 2622: IF NOT FND_API.Compatible_API_Call ( l_api_version,

2618: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2619: END IF;
2620:
2621: -- Standard call to check for call compatibility.
2622: IF NOT FND_API.Compatible_API_Call ( l_api_version,
2623: p_api_version,
2624: l_api_name,
2625: G_PKG_NAME )
2626: THEN

Line 2627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2623: p_api_version,
2624: l_api_name,
2625: G_PKG_NAME )
2626: THEN
2627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2628: END IF;
2629:
2630: -- Initialize message list if p_init_msg_list is set to TRUE.
2631: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2631: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2628: END IF;
2629:
2630: -- Initialize message list if p_init_msg_list is set to TRUE.
2631: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2632: FND_MSG_PUB.initialize;
2633: END IF;
2634:
2635: l_debug_info := 'Calling AP Void Pkg.Iby_Void_Check';

Line 2641: x_return_status := FND_API.G_RET_STS_SUCCESS;

2637: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2638: END IF;
2639:
2640: -- Initialize API return status to success
2641: x_return_status := FND_API.G_RET_STS_SUCCESS;
2642:
2643: Ap_Void_Pkg.Iby_Void_Check
2644: (p_api_version => 1.0,
2645: p_init_msg_list => p_init_msg_list,

Line 2653: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2649: x_return_status => x_return_status,
2650: x_msg_count => x_msg_count,
2651: x_msg_data => x_msg_data);
2652:
2653: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2654:
2655: l_debug_info := 'AP Void Pkg.Iby_Void_Check returns error';
2656: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2657: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 2672: WHEN FND_API.G_EXC_ERROR THEN

2668: END IF;
2669:
2670:
2671: EXCEPTION
2672: WHEN FND_API.G_EXC_ERROR THEN
2673: ROLLBACK TO Payments_Voided_PUB; --4945922
2674: x_return_status := FND_API.G_RET_STS_ERROR ;
2675: FND_MSG_PUB.Count_And_Get
2676: ( p_count => x_msg_count,

Line 2674: x_return_status := FND_API.G_RET_STS_ERROR ;

2670:
2671: EXCEPTION
2672: WHEN FND_API.G_EXC_ERROR THEN
2673: ROLLBACK TO Payments_Voided_PUB; --4945922
2674: x_return_status := FND_API.G_RET_STS_ERROR ;
2675: FND_MSG_PUB.Count_And_Get
2676: ( p_count => x_msg_count,
2677: p_data => x_msg_data
2678: );

Line 2679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2675: FND_MSG_PUB.Count_And_Get
2676: ( p_count => x_msg_count,
2677: p_data => x_msg_data
2678: );
2679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2680: ROLLBACK TO Payments_Voided_PUB;
2681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2682: FND_MSG_PUB.Count_And_Get
2683: ( p_count => x_msg_count,

Line 2681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2677: p_data => x_msg_data
2678: );
2679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2680: ROLLBACK TO Payments_Voided_PUB;
2681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2682: FND_MSG_PUB.Count_And_Get
2683: ( p_count => x_msg_count,
2684: p_data => x_msg_data
2685: );

Line 2688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2684: p_data => x_msg_data
2685: );
2686: WHEN OTHERS THEN
2687: ROLLBACK TO Payments_Voided_PUB;
2688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2689: IF FND_MSG_PUB.Check_Msg_Level
2690: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2691: FND_MSG_PUB.Add_Exc_Msg
2692: ( G_PKG_NAME,

Line 2727: IF NOT FND_API.Compatible_API_Call ( l_api_version,

2723: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2724: END IF;
2725:
2726: -- Standard call to check for call compatibility.
2727: IF NOT FND_API.Compatible_API_Call ( l_api_version,
2728: p_api_version,
2729: l_api_name,
2730: G_PKG_NAME )
2731: THEN

Line 2732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2728: p_api_version,
2729: l_api_name,
2730: G_PKG_NAME )
2731: THEN
2732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2733: END IF;
2734:
2735: -- Initialize message list if p_init_msg_list is set to TRUE.
2736: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2736: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2733: END IF;
2734:
2735: -- Initialize message list if p_init_msg_list is set to TRUE.
2736: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2737: FND_MSG_PUB.initialize;
2738: END IF;
2739:
2740: l_debug_info := 'Calling ap_bank_charge_pkg.ap_JapanBankChargeHook';

Line 2754: WHEN FND_API.G_EXC_ERROR THEN

2750: x_msg_count ,
2751: x_msg_data );
2752:
2753: EXCEPTION
2754: WHEN FND_API.G_EXC_ERROR THEN
2755: x_return_status := FND_API.G_RET_STS_ERROR ;
2756: FND_MSG_PUB.Count_And_Get
2757: ( p_count => x_msg_count,
2758: p_data => x_msg_data

Line 2755: x_return_status := FND_API.G_RET_STS_ERROR ;

2751: x_msg_data );
2752:
2753: EXCEPTION
2754: WHEN FND_API.G_EXC_ERROR THEN
2755: x_return_status := FND_API.G_RET_STS_ERROR ;
2756: FND_MSG_PUB.Count_And_Get
2757: ( p_count => x_msg_count,
2758: p_data => x_msg_data
2759: );

Line 2760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2756: FND_MSG_PUB.Count_And_Get
2757: ( p_count => x_msg_count,
2758: p_data => x_msg_data
2759: );
2760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2762: FND_MSG_PUB.Count_And_Get
2763: ( p_count => x_msg_count,
2764: p_data => x_msg_data

Line 2761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2757: ( p_count => x_msg_count,
2758: p_data => x_msg_data
2759: );
2760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2762: FND_MSG_PUB.Count_And_Get
2763: ( p_count => x_msg_count,
2764: p_data => x_msg_data
2765: );

Line 2767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2763: ( p_count => x_msg_count,
2764: p_data => x_msg_data
2765: );
2766: WHEN OTHERS THEN
2767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2768: IF FND_MSG_PUB.Check_Msg_Level
2769: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2770: FND_MSG_PUB.Add_Exc_Msg
2771: ( G_PKG_NAME,

Line 2815: x_return_status := FND_API.G_RET_STS_SUCCESS;

2811: stopped_date= p_stopped_date, -- Bug 6957071
2812: stopped_by= p_stopped_by -- Bug 6957071
2813: where payment_id = p_payment_id;
2814:
2815: x_return_status := FND_API.G_RET_STS_SUCCESS;
2816:
2817: EXCEPTION
2818: WHEN OTHERS THEN
2819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2815: x_return_status := FND_API.G_RET_STS_SUCCESS;
2816:
2817: EXCEPTION
2818: WHEN OTHERS THEN
2819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2820: x_msg_count := 1;
2821: x_msg_data := substr(SQLERRM,1,25);
2822:
2823: END Payment_Stop_Initiated;

Line 2854: x_return_status := FND_API.G_RET_STS_SUCCESS;

2850: stopped_date=null, -- Bug 6957071
2851: stopped_by=null -- Bug 6957071
2852: where payment_id = p_payment_id;
2853:
2854: x_return_status := FND_API.G_RET_STS_SUCCESS;
2855:
2856: EXCEPTION
2857: WHEN OTHERS THEN
2858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2854: x_return_status := FND_API.G_RET_STS_SUCCESS;
2855:
2856: EXCEPTION
2857: WHEN OTHERS THEN
2858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2859: x_msg_count := 1;
2860: x_msg_data := substr(SQLERRM,1,25);
2861:
2862: END Payment_Stop_Released;