DBA Data[Home] [Help]

APPS.OKC_UTIL dependencies on FND_API

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

57: --p_dff_name: the name of the descriptive flexfield, e.g., 'DELIVERABLES_FLEX'
58: ----------------------------------------------------------------------------
59:
60: FUNCTION Dff_Displayed ( p_api_version IN NUMBER,
61: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
62: p_application_short_name VARCHAR2,
63: p_dff_name VARCHAR2,
64: x_return_status OUT NOCOPY VARCHAR2,
65: x_msg_data OUT NOCOPY VARCHAR2,

Line 3338: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

3334: p_chr_id => p_chr_id,
3335: x_doc_id => x_doc_id,
3336: x_doc_type => x_doc_type
3337: );
3338: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3340: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3341: RAISE FND_API.G_EXC_ERROR ;
3342: END IF;

Line 3339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3335: x_doc_id => x_doc_id,
3336: x_doc_type => x_doc_type
3337: );
3338: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3340: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3341: RAISE FND_API.G_EXC_ERROR ;
3342: END IF;
3343:

Line 3340: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

3336: x_doc_type => x_doc_type
3337: );
3338: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3340: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3341: RAISE FND_API.G_EXC_ERROR ;
3342: END IF;
3343:
3344: OPEN get_doc_usage_crs;

Line 3341: RAISE FND_API.G_EXC_ERROR ;

3337: );
3338: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3340: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3341: RAISE FND_API.G_EXC_ERROR ;
3342: END IF;
3343:
3344: OPEN get_doc_usage_crs;
3345: FETCH get_doc_usage_crs INTO l_tmpl_id;

Line 3431: p_commit => FND_API.G_TRUE,

3427: p_api_version => 1,
3428: x_return_status => x_return_status,
3429: x_msg_data => l_msg_data,
3430: x_msg_count => l_msg_count,
3431: p_commit => FND_API.G_TRUE,
3432:
3433: p_template_id => l_tmpl_id,
3434: p_target_doc_type => x_doc_type,
3435: p_target_doc_id => x_doc_id,

Line 3439: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

3435: p_target_doc_id => x_doc_id,
3436: p_article_effective_date => l_start_date,
3437: p_validation_string => NULL
3438: );
3439: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3441: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3442: RAISE FND_API.G_EXC_ERROR ;
3443: END IF;

Line 3440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3436: p_article_effective_date => l_start_date,
3437: p_validation_string => NULL
3438: );
3439: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3441: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3442: RAISE FND_API.G_EXC_ERROR ;
3443: END IF;
3444: END IF;

Line 3441: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

3437: p_validation_string => NULL
3438: );
3439: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3441: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3442: RAISE FND_API.G_EXC_ERROR ;
3443: END IF;
3444: END IF;
3445: END IF;

Line 3442: RAISE FND_API.G_EXC_ERROR ;

3438: );
3439: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3441: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3442: RAISE FND_API.G_EXC_ERROR ;
3443: END IF;
3444: END IF;
3445: END IF;
3446:

Line 3453: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3449: END IF;
3450:
3451: EXCEPTION
3452:
3453: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3454: IF (l_debug = 'Y') THEN
3455: okc_debug.log('500: Leaving Prepare_Contract_Terms because of FND_API.G_EXC_UNEXPECTED_ERROR ', 2);
3456: END IF;
3457:

Line 3455: okc_debug.log('500: Leaving Prepare_Contract_Terms because of FND_API.G_EXC_UNEXPECTED_ERROR ', 2);

3451: EXCEPTION
3452:
3453: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3454: IF (l_debug = 'Y') THEN
3455: okc_debug.log('500: Leaving Prepare_Contract_Terms because of FND_API.G_EXC_UNEXPECTED_ERROR ', 2);
3456: END IF;
3457:
3458: IF get_doc_usage_crs%ISOPEN THEN
3459: CLOSE get_doc_usage_crs;

Line 3470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3466: IF start_date_crs%ISOPEN THEN
3467: CLOSE start_date_crs;
3468: END IF;
3469:
3470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3471:
3472: WHEN FND_API.G_EXC_ERROR THEN
3473: IF (l_debug = 'Y') THEN
3474: okc_debug.log('500: Leaving Prepare_Contract_Terms because of FND_API.G_EXC_ERROR. ', 2);

Line 3472: WHEN FND_API.G_EXC_ERROR THEN

3468: END IF;
3469:
3470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3471:
3472: WHEN FND_API.G_EXC_ERROR THEN
3473: IF (l_debug = 'Y') THEN
3474: okc_debug.log('500: Leaving Prepare_Contract_Terms because of FND_API.G_EXC_ERROR. ', 2);
3475: END IF;
3476:

Line 3474: okc_debug.log('500: Leaving Prepare_Contract_Terms because of FND_API.G_EXC_ERROR. ', 2);

3470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3471:
3472: WHEN FND_API.G_EXC_ERROR THEN
3473: IF (l_debug = 'Y') THEN
3474: okc_debug.log('500: Leaving Prepare_Contract_Terms because of FND_API.G_EXC_ERROR. ', 2);
3475: END IF;
3476:
3477: IF get_doc_usage_crs%ISOPEN THEN
3478: CLOSE get_doc_usage_crs;

Line 3489: x_return_status := FND_API.G_RET_STS_ERROR ;

3485: IF start_date_crs%ISOPEN THEN
3486: CLOSE start_date_crs;
3487: END IF;
3488:
3489: x_return_status := FND_API.G_RET_STS_ERROR ;
3490:
3491: WHEN OTHERS THEN
3492: IF (l_debug = 'Y') THEN
3493: okc_debug.log('500: Leaving Prepare_Contract_Terms because of EXCEPTION: '||sqlerrm, 2);

Line 3508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3504: IF start_date_crs%ISOPEN THEN
3505: CLOSE start_date_crs;
3506: END IF;
3507:
3508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3509: END Prepare_Contract_Terms;
3510:
3511:
3512: