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

Line 217: x_return_status := FND_API.G_RET_STS_SUCCESS;

213: l_api_name := 'assign_int_inv_sequence';
214: /* End - BUG 14364091 - Logging */
215:
216: /* Initialize return status */
217: x_return_status := FND_API.G_RET_STS_SUCCESS;
218:
219: if p_seq_num_profile = 'P' and
220: x_msg_data is not null then
221: return; --return without raising an error

Line 246: x_return_status:= FND_API.G_RET_STS_ERROR;

242:
243: if (l_return_code <> 0 or l_int_seqval is null) and
244: p_seq_num_profile = 'A' then
245:
246: x_return_status:= FND_API.G_RET_STS_ERROR;
247: x_msg_count:= 1;
248: x_msg_data := 'Invalid Interest Invoice Sequence';
249: return;
250:

Line 330: x_return_status := FND_API.G_RET_STS_SUCCESS;

326: BEGIN
327:
328:
329: /* Initialize return status */
330: x_return_status := FND_API.G_RET_STS_SUCCESS;
331:
332: l_api_name := 'assign_sequences';
333:
334: -- Bug 5512197.Adding Fnd_Logging for this procedure

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

364: -- Bug 5555642. Added fnd-logging and messages for sequence numbering
365: --if p_seq_num_profile = 'A' and l_doc_category_code = '-1' then
366: -- Bug 5555642
367: if l_doc_category_code = '-1' then
368: -- x_return_status:= FND_API.G_RET_STS_ERROR; --Bug6258525
369: x_msg_count:= 1;
370: if p_seq_num_profile = 'P' then
371: x_msg_data := 'No document category found and sequential number is set to partially used';
372: l_debug_info := 'No document category found from CE API and sequential number is set to '||

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

374: elsif p_seq_num_profile = 'A' then
375: x_msg_data := 'No document category found and sequential number is set to always used';
376: l_debug_info := 'No document category found from CE API and sequential number is set to '||
377: 'always used';
378: x_return_status:= FND_API.G_RET_STS_ERROR; --Bug6258525
379: end if;
380: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
381: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
382: END IF;

Line 467: x_return_status:= FND_API.G_RET_STS_ERROR;

463: END IF;
464:
465:
466: if x_msg_data is not null then
467: x_return_status:= FND_API.G_RET_STS_ERROR;
468: x_msg_count:= 1;
469: l_debug_info := x_msg_data;
470: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
471: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 507: x_return_status:= FND_API.G_RET_STS_ERROR;

503: END IF;
504:
505: if l_return_code <> 0 or l_seqval is null then
506:
507: x_return_status:= FND_API.G_RET_STS_ERROR;
508: x_msg_count:= 1;
509: x_msg_data := 'Invalid Sequence';
510: return;
511:

Line 564: x_return_status:= FND_API.G_RET_STS_ERROR;

560: x_msg_data := 'Invalid document sequence setup for interest invoices';
561: end if;
562:
563: if x_msg_data is not null and p_seq_num_profile = 'A' then
564: x_return_status:= FND_API.G_RET_STS_ERROR;
565: x_msg_count:= 1;
566: return;
567: end if;
568:

Line 578: if x_return_status = FND_API.G_RET_STS_ERROR then

574: x_return_status,
575: x_msg_count,
576: x_msg_data);
577:
578: if x_return_status = FND_API.G_RET_STS_ERROR then
579: return;
580: end if;
581:
582:

Line 736: x_return_status := FND_API.G_RET_STS_SUCCESS;

732: from iby_fd_docs_payable_v
733: where rejected_docs_group_id = p_rejected_docs_group_id);
734:
735:
736: x_return_status := FND_API.G_RET_STS_SUCCESS;
737:
738: END;
739: END LOOP;
740:

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

1109:
1110: --Bug 5115310
1111:
1112: /* Initialize message list if p_init_msg_list is set to TRUE */
1113: /* IF FND_API.to_boolean(p_init_msg_list) THEN
1114: FND_MSG_PUB.initialize;
1115: END IF;
1116: */
1117: /* Initialize return status */

Line 1118: x_return_status := FND_API.G_RET_STS_SUCCESS;

1114: FND_MSG_PUB.initialize;
1115: END IF;
1116: */
1117: /* Initialize return status */
1118: x_return_status := FND_API.G_RET_STS_SUCCESS;
1119:
1120: l_debug_info := 'get_relevant_checkrun_ids';
1121: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1122: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

2625: l_interest_invoice_count,
2626: l_check_date,
2627: l_current_org_id);
2628:
2629: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2630: RETURN;
2631: END IF;
2632:
2633: END IF;

Line 2773: x_return_status := FND_API.G_RET_STS_ERROR;

2769: --Bug 5115363
2770: IF (l_total_check_count <> l_iby_check_count) OR
2771: (l_total_docs_count <> l_iby_docs_count) THEN
2772:
2773: x_return_status := FND_API.G_RET_STS_ERROR;
2774:
2775: FND_MESSAGE.set_name('SQLAP', 'AP_IBY_PMT_MISMATCH');
2776:
2777: --Bug 9074840 Add additional debug queries

Line 2819: x_return_status := FND_API.G_RET_STS_SUCCESS;

2815: --End Bug 9074840
2816:
2817: ELSE
2818:
2819: x_return_status := FND_API.G_RET_STS_SUCCESS;
2820:
2821: END IF;
2822:
2823:

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

2891: END;
2892:
2893: PROCEDURE Payment_Voided
2894: ( p_api_version IN NUMBER,
2895: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2896: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2897: p_payment_id IN NUMBER,
2898: p_void_date IN DATE,
2899: -- p_accounting_date IN DATE, /* Bug 4775938 */

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

2892:
2893: PROCEDURE Payment_Voided
2894: ( p_api_version IN NUMBER,
2895: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2896: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2897: p_payment_id IN NUMBER,
2898: p_void_date IN DATE,
2899: -- p_accounting_date IN DATE, /* Bug 4775938 */
2900: x_return_status OUT nocopy VARCHAR2,

Line 2923: IF NOT FND_API.Compatible_API_Call ( l_api_version,

2919: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2920: END IF;
2921:
2922: -- Standard call to check for call compatibility.
2923: IF NOT FND_API.Compatible_API_Call ( l_api_version,
2924: p_api_version,
2925: l_api_name,
2926: G_PKG_NAME )
2927: THEN

Line 2928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2924: p_api_version,
2925: l_api_name,
2926: G_PKG_NAME )
2927: THEN
2928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2929: END IF;
2930:
2931: -- Initialize message list if p_init_msg_list is set to TRUE.
2932: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2932: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2929: END IF;
2930:
2931: -- Initialize message list if p_init_msg_list is set to TRUE.
2932: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2933: FND_MSG_PUB.initialize;
2934: END IF;
2935:
2936: l_debug_info := 'Calling AP Void Pkg.Iby_Void_Check';

Line 2942: x_return_status := FND_API.G_RET_STS_SUCCESS;

2938: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2939: END IF;
2940:
2941: -- Initialize API return status to success
2942: x_return_status := FND_API.G_RET_STS_SUCCESS;
2943:
2944: Ap_Void_Pkg.Iby_Void_Check
2945: (p_api_version => 1.0,
2946: p_init_msg_list => p_init_msg_list,

Line 2954: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2950: x_return_status => x_return_status,
2951: x_msg_count => x_msg_count,
2952: x_msg_data => x_msg_data);
2953:
2954: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2955:
2956: l_debug_info := 'AP Void Pkg.Iby_Void_Check returns error';
2957: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2958: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 2973: WHEN FND_API.G_EXC_ERROR THEN

2969: END IF;
2970:
2971:
2972: EXCEPTION
2973: WHEN FND_API.G_EXC_ERROR THEN
2974: ROLLBACK TO Payments_Voided_PUB; --4945922
2975: x_return_status := FND_API.G_RET_STS_ERROR ;
2976: FND_MSG_PUB.Count_And_Get
2977: ( p_count => x_msg_count,

Line 2975: x_return_status := FND_API.G_RET_STS_ERROR ;

2971:
2972: EXCEPTION
2973: WHEN FND_API.G_EXC_ERROR THEN
2974: ROLLBACK TO Payments_Voided_PUB; --4945922
2975: x_return_status := FND_API.G_RET_STS_ERROR ;
2976: FND_MSG_PUB.Count_And_Get
2977: ( p_count => x_msg_count,
2978: p_data => x_msg_data
2979: );

Line 2980: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2976: FND_MSG_PUB.Count_And_Get
2977: ( p_count => x_msg_count,
2978: p_data => x_msg_data
2979: );
2980: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2981: ROLLBACK TO Payments_Voided_PUB;
2982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2983: FND_MSG_PUB.Count_And_Get
2984: ( p_count => x_msg_count,

Line 2982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2978: p_data => x_msg_data
2979: );
2980: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2981: ROLLBACK TO Payments_Voided_PUB;
2982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2983: FND_MSG_PUB.Count_And_Get
2984: ( p_count => x_msg_count,
2985: p_data => x_msg_data
2986: );

Line 2989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2985: p_data => x_msg_data
2986: );
2987: WHEN OTHERS THEN
2988: ROLLBACK TO Payments_Voided_PUB;
2989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2990: IF FND_MSG_PUB.Check_Msg_Level
2991: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2992: FND_MSG_PUB.Add_Exc_Msg
2993: ( G_PKG_NAME,

Line 3028: IF NOT FND_API.Compatible_API_Call ( l_api_version,

3024: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3025: END IF;
3026:
3027: -- Standard call to check for call compatibility.
3028: IF NOT FND_API.Compatible_API_Call ( l_api_version,
3029: p_api_version,
3030: l_api_name,
3031: G_PKG_NAME )
3032: THEN

Line 3033: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3029: p_api_version,
3030: l_api_name,
3031: G_PKG_NAME )
3032: THEN
3033: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3034: END IF;
3035:
3036: -- Initialize message list if p_init_msg_list is set to TRUE.
3037: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 3037: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3033: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3034: END IF;
3035:
3036: -- Initialize message list if p_init_msg_list is set to TRUE.
3037: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3038: FND_MSG_PUB.initialize;
3039: END IF;
3040:
3041: l_debug_info := 'Calling ap_bank_charge_pkg.ap_JapanBankChargeHook';

Line 3055: WHEN FND_API.G_EXC_ERROR THEN

3051: x_msg_count ,
3052: x_msg_data );
3053:
3054: EXCEPTION
3055: WHEN FND_API.G_EXC_ERROR THEN
3056: x_return_status := FND_API.G_RET_STS_ERROR ;
3057: FND_MSG_PUB.Count_And_Get
3058: ( p_count => x_msg_count,
3059: p_data => x_msg_data

Line 3056: x_return_status := FND_API.G_RET_STS_ERROR ;

3052: x_msg_data );
3053:
3054: EXCEPTION
3055: WHEN FND_API.G_EXC_ERROR THEN
3056: x_return_status := FND_API.G_RET_STS_ERROR ;
3057: FND_MSG_PUB.Count_And_Get
3058: ( p_count => x_msg_count,
3059: p_data => x_msg_data
3060: );

Line 3061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3057: FND_MSG_PUB.Count_And_Get
3058: ( p_count => x_msg_count,
3059: p_data => x_msg_data
3060: );
3061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3063: FND_MSG_PUB.Count_And_Get
3064: ( p_count => x_msg_count,
3065: p_data => x_msg_data

Line 3062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3058: ( p_count => x_msg_count,
3059: p_data => x_msg_data
3060: );
3061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3063: FND_MSG_PUB.Count_And_Get
3064: ( p_count => x_msg_count,
3065: p_data => x_msg_data
3066: );

Line 3068: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3064: ( p_count => x_msg_count,
3065: p_data => x_msg_data
3066: );
3067: WHEN OTHERS THEN
3068: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3069: IF FND_MSG_PUB.Check_Msg_Level
3070: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3071: FND_MSG_PUB.Add_Exc_Msg
3072: ( G_PKG_NAME,

Line 3116: x_return_status := FND_API.G_RET_STS_SUCCESS;

3112: stopped_date= p_stopped_date, -- Bug 6957071
3113: stopped_by= p_stopped_by -- Bug 6957071
3114: where payment_id = p_payment_id;
3115:
3116: x_return_status := FND_API.G_RET_STS_SUCCESS;
3117:
3118: EXCEPTION
3119: WHEN OTHERS THEN
3120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3116: x_return_status := FND_API.G_RET_STS_SUCCESS;
3117:
3118: EXCEPTION
3119: WHEN OTHERS THEN
3120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3121: x_msg_count := 1;
3122: x_msg_data := substr(SQLERRM,1,25);
3123:
3124: END Payment_Stop_Initiated;

Line 3155: x_return_status := FND_API.G_RET_STS_SUCCESS;

3151: stopped_date=null, -- Bug 6957071
3152: stopped_by=null -- Bug 6957071
3153: where payment_id = p_payment_id;
3154:
3155: x_return_status := FND_API.G_RET_STS_SUCCESS;
3156:
3157: EXCEPTION
3158: WHEN OTHERS THEN
3159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3155: x_return_status := FND_API.G_RET_STS_SUCCESS;
3156:
3157: EXCEPTION
3158: WHEN OTHERS THEN
3159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3160: x_msg_count := 1;
3161: x_msg_data := substr(SQLERRM,1,25);
3162:
3163: END Payment_Stop_Released;

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

3165: /* End of fix for bug 6756063 */
3166:
3167: PROCEDURE void_payment_allowed
3168: ( p_api_version IN NUMBER,
3169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3170: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3171: p_payment_id IN NUMBER,
3172: x_return_flag OUT nocopy VARCHAR2,
3173: x_return_status OUT nocopy VARCHAR2,

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

3166:
3167: PROCEDURE void_payment_allowed
3168: ( p_api_version IN NUMBER,
3169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3170: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3171: p_payment_id IN NUMBER,
3172: x_return_flag OUT nocopy VARCHAR2,
3173: x_return_status OUT nocopy VARCHAR2,
3174: x_msg_count OUT nocopy NUMBER,

Line 3188: IF NOT FND_API.Compatible_API_Call ( l_api_version,

3184:
3185: BEGIN
3186:
3187: -- Standard call to check for call compatibility.
3188: IF NOT FND_API.Compatible_API_Call ( l_api_version,
3189: p_api_version,
3190: l_api_name,
3191: G_PKG_NAME )
3192: THEN

Line 3193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3189: p_api_version,
3190: l_api_name,
3191: G_PKG_NAME )
3192: THEN
3193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3194: END IF;
3195: -- Initialize message list if p_init_msg_list is set to TRUE.
3196: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3197: FND_MSG_PUB.initialize;

Line 3196: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3192: THEN
3193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3194: END IF;
3195: -- Initialize message list if p_init_msg_list is set to TRUE.
3196: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3197: FND_MSG_PUB.initialize;
3198: END IF;
3199: -- Initialize API return status to success
3200:

Line 3201: x_return_status := FND_API.G_RET_STS_SUCCESS;

3197: FND_MSG_PUB.initialize;
3198: END IF;
3199: -- Initialize API return status to success
3200:
3201: x_return_status := FND_API.G_RET_STS_SUCCESS;
3202:
3203: BEGIN
3204: SELECT status_lookup_code
3205: INTO l_payment_status

Line 3283: WHEN FND_API.G_EXC_ERROR THEN

3279:
3280: end if ;
3281:
3282: EXCEPTION
3283: WHEN FND_API.G_EXC_ERROR THEN
3284: x_return_status := FND_API.G_RET_STS_ERROR ;
3285: FND_MSG_PUB.Count_And_Get
3286: ( p_count => x_msg_count,
3287: p_data => x_msg_data

Line 3284: x_return_status := FND_API.G_RET_STS_ERROR ;

3280: end if ;
3281:
3282: EXCEPTION
3283: WHEN FND_API.G_EXC_ERROR THEN
3284: x_return_status := FND_API.G_RET_STS_ERROR ;
3285: FND_MSG_PUB.Count_And_Get
3286: ( p_count => x_msg_count,
3287: p_data => x_msg_data
3288: );

Line 3289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3285: FND_MSG_PUB.Count_And_Get
3286: ( p_count => x_msg_count,
3287: p_data => x_msg_data
3288: );
3289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3291: FND_MSG_PUB.Count_And_Get
3292: ( p_count => x_msg_count,
3293: p_data => x_msg_data

Line 3290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3286: ( p_count => x_msg_count,
3287: p_data => x_msg_data
3288: );
3289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3291: FND_MSG_PUB.Count_And_Get
3292: ( p_count => x_msg_count,
3293: p_data => x_msg_data
3294: );

Line 3296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3292: ( p_count => x_msg_count,
3293: p_data => x_msg_data
3294: );
3295: WHEN OTHERS THEN
3296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3297: IF FND_MSG_PUB.Check_Msg_Level
3298: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3299: FND_MSG_PUB.Add_Exc_Msg
3300: ( G_PKG_NAME,