DBA Data[Home] [Help]

APPS.FEM_RULE_SET_MANAGER dependencies on FND_API

Line 1384: RAISE FND_API.G_EXC_ERROR;

1380: );
1381: p_Other_Error_Status := G_RSM_DEPTH_FAILURE;
1382:
1383: -- hard error.. fail out..
1384: RAISE FND_API.G_EXC_ERROR;
1385: End If;
1386: END IF;
1387:
1388:

Line 1396: WHEN FND_API.G_EXC_ERROR THEN

1392:
1393: RETURN l_ruleset_already_used;
1394:
1395: EXCEPTION
1396: WHEN FND_API.G_EXC_ERROR THEN
1397: -- top calling routine will handle this one.
1398: RAISE;
1399: WHEN OTHERS THEN
1400: -- todo:: useful? z_Err_Code := -1;

Line 2575: RAISE FND_API.G_EXC_ERROR;

2571:
2572: -- capture error state and react accordingly
2573: If (z_master_err_state = FEM_UTILS.G_RSM_FATAL_ERR ) THEN
2574: -- this is a backstop err capture routine.. we (hopefully) should never get here..
2575: RAISE FND_API.G_EXC_ERROR;
2576:
2577: Elsif (z_master_err_state = FEM_UTILS.G_RSM_NONFATAL_ERR) then
2578:
2579: If NOT z_continue_on_error then

Line 2652: WHEN FND_API.G_EXC_ERROR THEN

2648: p_msg_text=> 'EXIT');
2649:
2650:
2651: EXCEPTION
2652: WHEN FND_API.G_EXC_ERROR THEN
2653: -- top caller will handle this one..
2654: RAISE;
2655: WHEN OTHERS THEN
2656: -- todo:: useful?? z_Err_Code := -1;

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

2964:
2965:
2966:
2967: Procedure Validate_Rule_Public(p_api_version IN NUMBER
2968: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2969: ,p_encoded IN VARCHAR2 := FND_API.G_TRUE
2970: ,p_Rule_Object_ID IN DEF_OBJECT_ID%TYPE
2971: ,p_DS_IO_Def_ID IN DEF_OBJECT_DEFINITION_ID%TYPE
2972: ,p_Rule_Effective_Date IN VARCHAR2

Line 2969: ,p_encoded IN VARCHAR2 := FND_API.G_TRUE

2965:
2966:
2967: Procedure Validate_Rule_Public(p_api_version IN NUMBER
2968: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2969: ,p_encoded IN VARCHAR2 := FND_API.G_TRUE
2970: ,p_Rule_Object_ID IN DEF_OBJECT_ID%TYPE
2971: ,p_DS_IO_Def_ID IN DEF_OBJECT_DEFINITION_ID%TYPE
2972: ,p_Rule_Effective_Date IN VARCHAR2
2973: ,p_Reference_Period_ID IN NUMBER

Line 2993: IF NOT FND_API.Compatible_API_Call(l_api_version

2989: -- HISTORY
2990: -- 27-Jun-2006 dyung initial version
2991: --
2992: -- *******************************************************************************************
2993: IF NOT FND_API.Compatible_API_Call(l_api_version
2994: ,p_api_version
2995: ,l_api_name
2996: ,G_PKG_NAME)
2997: THEN

Line 2998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2994: ,p_api_version
2995: ,l_api_name
2996: ,G_PKG_NAME)
2997: THEN
2998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2999: END IF;
3000:
3001: IF FND_API.to_Boolean(p_init_msg_list) THEN
3002: FND_MSG_PUB.Initialize;

Line 3001: IF FND_API.to_Boolean(p_init_msg_list) THEN

2997: THEN
2998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2999: END IF;
3000:
3001: IF FND_API.to_Boolean(p_init_msg_list) THEN
3002: FND_MSG_PUB.Initialize;
3003: END IF;
3004:
3005: Validate_Rule_Public(l_Err_Code

Line 3018: x_return_status := FND_API.G_RET_STS_ERROR;

3014: FND_MSG_PUB.Count_And_Get(p_encoded => p_encoded, p_count => x_msg_count,
3015: p_data => x_msg_data);
3016:
3017: IF (l_Err_Code > 0) THEN
3018: x_return_status := FND_API.G_RET_STS_ERROR;
3019: ELSE
3020: IF (l_Err_Code = 0) THEN
3021: x_return_status := FND_API.G_RET_STS_SUCCESS;
3022: ELSE

Line 3021: x_return_status := FND_API.G_RET_STS_SUCCESS;

3017: IF (l_Err_Code > 0) THEN
3018: x_return_status := FND_API.G_RET_STS_ERROR;
3019: ELSE
3020: IF (l_Err_Code = 0) THEN
3021: x_return_status := FND_API.G_RET_STS_SUCCESS;
3022: ELSE
3023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3024: END IF;
3025: END IF;

Line 3023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3019: ELSE
3020: IF (l_Err_Code = 0) THEN
3021: x_return_status := FND_API.G_RET_STS_SUCCESS;
3022: ELSE
3023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3024: END IF;
3025: END IF;
3026:
3027: EXCEPTION

Line 3029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3025: END IF;
3026:
3027: EXCEPTION
3028: WHEN OTHERS THEN
3029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3030: FND_MSG_PUB.Count_And_Get(p_encoded => p_encoded, p_count => x_msg_count, p_data => x_msg_data);
3031:
3032: End Validate_Rule_Public;
3033:

Line 3250: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

3246: -- Parameters
3247: -- IN
3248: -- p_api_version IN NUMBER
3249: -- Current version of this API
3250: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3251: -- If set to:
3252: -- FND_API.G_TRUE - Initialize FND_MSG_PUB
3253: -- FND_API.G_FALSE - DO NOT Initialize FND_MSG_PUB
3254: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 3252: -- FND_API.G_TRUE - Initialize FND_MSG_PUB

3248: -- p_api_version IN NUMBER
3249: -- Current version of this API
3250: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3251: -- If set to:
3252: -- FND_API.G_TRUE - Initialize FND_MSG_PUB
3253: -- FND_API.G_FALSE - DO NOT Initialize FND_MSG_PUB
3254: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
3255: -- If set to:
3256: -- FND_API.G_TRUE - Commit data at exit of this routine

Line 3253: -- FND_API.G_FALSE - DO NOT Initialize FND_MSG_PUB

3249: -- Current version of this API
3250: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3251: -- If set to:
3252: -- FND_API.G_TRUE - Initialize FND_MSG_PUB
3253: -- FND_API.G_FALSE - DO NOT Initialize FND_MSG_PUB
3254: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
3255: -- If set to:
3256: -- FND_API.G_TRUE - Commit data at exit of this routine
3257: -- FND_API.G_FALSE - DO NOT commit data at exit of this routine

Line 3254: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

3250: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3251: -- If set to:
3252: -- FND_API.G_TRUE - Initialize FND_MSG_PUB
3253: -- FND_API.G_FALSE - DO NOT Initialize FND_MSG_PUB
3254: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
3255: -- If set to:
3256: -- FND_API.G_TRUE - Commit data at exit of this routine
3257: -- FND_API.G_FALSE - DO NOT commit data at exit of this routine
3258: -- p_Orig_RuleSet_Object_ID IN DEF_OBJECT_ID%TYPE

Line 3256: -- FND_API.G_TRUE - Commit data at exit of this routine

3252: -- FND_API.G_TRUE - Initialize FND_MSG_PUB
3253: -- FND_API.G_FALSE - DO NOT Initialize FND_MSG_PUB
3254: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
3255: -- If set to:
3256: -- FND_API.G_TRUE - Commit data at exit of this routine
3257: -- FND_API.G_FALSE - DO NOT commit data at exit of this routine
3258: -- p_Orig_RuleSet_Object_ID IN DEF_OBJECT_ID%TYPE
3259: -- the object id associated with the list to delete.
3260: --

Line 3257: -- FND_API.G_FALSE - DO NOT commit data at exit of this routine

3253: -- FND_API.G_FALSE - DO NOT Initialize FND_MSG_PUB
3254: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
3255: -- If set to:
3256: -- FND_API.G_TRUE - Commit data at exit of this routine
3257: -- FND_API.G_FALSE - DO NOT commit data at exit of this routine
3258: -- p_Orig_RuleSet_Object_ID IN DEF_OBJECT_ID%TYPE
3259: -- the object id associated with the list to delete.
3260: --
3261: --

Line 3265: -- FND_API.G_RET_STS_SUCCESS - Call was successful, msgs may

3261: --
3262: -- OUT
3263: -- x_return_status OUT VARCHAR2
3264: -- Possible return status:
3265: -- FND_API.G_RET_STS_SUCCESS - Call was successful, msgs may
3266: -- still be present (check x_msg_count)
3267: -- FND_API.G_RET_STS_ERROR - Call was not successful, msgs should
3268: -- be present (check x_msg_count)
3269: -- FND_API.G_RET_STS_UNEXP_ERROR - Unexpected errors occurred which are

Line 3267: -- FND_API.G_RET_STS_ERROR - Call was not successful, msgs should

3263: -- x_return_status OUT VARCHAR2
3264: -- Possible return status:
3265: -- FND_API.G_RET_STS_SUCCESS - Call was successful, msgs may
3266: -- still be present (check x_msg_count)
3267: -- FND_API.G_RET_STS_ERROR - Call was not successful, msgs should
3268: -- be present (check x_msg_count)
3269: -- FND_API.G_RET_STS_UNEXP_ERROR - Unexpected errors occurred which are
3270: -- unrecoverable (check x_msg_count)
3271: --

Line 3269: -- FND_API.G_RET_STS_UNEXP_ERROR - Unexpected errors occurred which are

3265: -- FND_API.G_RET_STS_SUCCESS - Call was successful, msgs may
3266: -- still be present (check x_msg_count)
3267: -- FND_API.G_RET_STS_ERROR - Call was not successful, msgs should
3268: -- be present (check x_msg_count)
3269: -- FND_API.G_RET_STS_UNEXP_ERROR - Unexpected errors occurred which are
3270: -- unrecoverable (check x_msg_count)
3271: --
3272: -- x_msg_count OUT NUMBER
3273: -- Count of messages returned. If x_msg_count = 1, then the message is returned

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

3282: -- Initial version 1.0
3283: -- *******************************************************************************************
3284: PROCEDURE FEM_DeleteFlatRuleList_PVT(
3285: p_api_version IN NUMBER
3286: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3287: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3288: ,p_encoded IN VARCHAR2 := FND_API.G_TRUE
3289: ,x_return_status OUT NOCOPY VARCHAR2
3290: ,x_msg_count OUT NOCOPY NUMBER

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

3283: -- *******************************************************************************************
3284: PROCEDURE FEM_DeleteFlatRuleList_PVT(
3285: p_api_version IN NUMBER
3286: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3287: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3288: ,p_encoded IN VARCHAR2 := FND_API.G_TRUE
3289: ,x_return_status OUT NOCOPY VARCHAR2
3290: ,x_msg_count OUT NOCOPY NUMBER
3291: ,x_msg_data OUT NOCOPY VARCHAR2

Line 3288: ,p_encoded IN VARCHAR2 := FND_API.G_TRUE

3284: PROCEDURE FEM_DeleteFlatRuleList_PVT(
3285: p_api_version IN NUMBER
3286: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3287: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3288: ,p_encoded IN VARCHAR2 := FND_API.G_TRUE
3289: ,x_return_status OUT NOCOPY VARCHAR2
3290: ,x_msg_count OUT NOCOPY NUMBER
3291: ,x_msg_data OUT NOCOPY VARCHAR2
3292: ,p_RuleSet_Object_ID IN DEF_OBJECT_ID%TYPE

Line 3306: x_return_status := FND_API.G_RET_STS_SUCCESS;

3302: p_module=> l_module_name,
3303: p_msg_text=> 'ENTER');
3304:
3305: -- initialize our status to 'we are good!'
3306: x_return_status := FND_API.G_RET_STS_SUCCESS;
3307:
3308: -- setup save point for rollbacks..
3309: SAVEPOINT FEM_DeleteFlatRuleList_SvPt;
3310:

Line 3312: IF fnd_api.to_Boolean(p_init_msg_list) THEN

3308: -- setup save point for rollbacks..
3309: SAVEPOINT FEM_DeleteFlatRuleList_SvPt;
3310:
3311: -- initialize msg stack?
3312: IF fnd_api.to_Boolean(p_init_msg_list) THEN
3313: fnd_msg_pub.initialize;
3314: END IF;
3315:
3316: -- check API version...

Line 3317: IF NOT fnd_api.Compatible_API_Call (l_api_version,

3313: fnd_msg_pub.initialize;
3314: END IF;
3315:
3316: -- check API version...
3317: IF NOT fnd_api.Compatible_API_Call (l_api_version,
3318: p_api_version,
3319: l_api_name,
3320: G_PKG_NAME ) THEN
3321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3317: IF NOT fnd_api.Compatible_API_Call (l_api_version,
3318: p_api_version,
3319: l_api_name,
3320: G_PKG_NAME ) THEN
3321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3322: END IF;
3323:
3324: -- and on to the real code...
3325: DELETE FROM fem_ruleset_process_DATA

Line 3331: IF fnd_api.to_boolean(p_commit) THEN

3327: AND rule_set_obj_id = p_RuleSet_Object_ID;
3328:
3329:
3330: -- and the required post work code...
3331: IF fnd_api.to_boolean(p_commit) THEN
3332: COMMIT WORK;
3333: END IF;
3334:
3335: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,

Line 3361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3357: FND_MSG_PUB.Count_And_Get ( p_encoded,
3358: x_msg_count,
3359: x_msg_data );
3360:
3361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3362:
3363: END FEM_DeleteFlatRuleList_PVT;
3364:
3365:

Line 3379: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

3375: -- Parameters
3376: -- IN
3377: -- p_api_version IN NUMBER
3378: -- Current version of this API
3379: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3380: -- If set to:
3381: -- FND_API.G_TRUE - Initialize FND_MSG_PUB
3382: -- FND_API.G_FALSE - DO NOT Initialize FND_MSG_PUB
3383: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 3381: -- FND_API.G_TRUE - Initialize FND_MSG_PUB

3377: -- p_api_version IN NUMBER
3378: -- Current version of this API
3379: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3380: -- If set to:
3381: -- FND_API.G_TRUE - Initialize FND_MSG_PUB
3382: -- FND_API.G_FALSE - DO NOT Initialize FND_MSG_PUB
3383: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
3384: -- If set to:
3385: -- FND_API.G_TRUE - Commit data at exit of this routine

Line 3382: -- FND_API.G_FALSE - DO NOT Initialize FND_MSG_PUB

3378: -- Current version of this API
3379: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3380: -- If set to:
3381: -- FND_API.G_TRUE - Initialize FND_MSG_PUB
3382: -- FND_API.G_FALSE - DO NOT Initialize FND_MSG_PUB
3383: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
3384: -- If set to:
3385: -- FND_API.G_TRUE - Commit data at exit of this routine
3386: -- FND_API.G_FALSE - DO NOT commit data at exit of this routine

Line 3383: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

3379: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3380: -- If set to:
3381: -- FND_API.G_TRUE - Initialize FND_MSG_PUB
3382: -- FND_API.G_FALSE - DO NOT Initialize FND_MSG_PUB
3383: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
3384: -- If set to:
3385: -- FND_API.G_TRUE - Commit data at exit of this routine
3386: -- FND_API.G_FALSE - DO NOT commit data at exit of this routine
3387: -- p_Orig_RuleSet_Object_ID IN DEF_OBJECT_ID%TYPE

Line 3385: -- FND_API.G_TRUE - Commit data at exit of this routine

3381: -- FND_API.G_TRUE - Initialize FND_MSG_PUB
3382: -- FND_API.G_FALSE - DO NOT Initialize FND_MSG_PUB
3383: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
3384: -- If set to:
3385: -- FND_API.G_TRUE - Commit data at exit of this routine
3386: -- FND_API.G_FALSE - DO NOT commit data at exit of this routine
3387: -- p_Orig_RuleSet_Object_ID IN DEF_OBJECT_ID%TYPE
3388: --
3389: -- p_DS_IO_Def_ID IN DEF_OBJECT_DEFINITION_ID%TYPE

Line 3386: -- FND_API.G_FALSE - DO NOT commit data at exit of this routine

3382: -- FND_API.G_FALSE - DO NOT Initialize FND_MSG_PUB
3383: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
3384: -- If set to:
3385: -- FND_API.G_TRUE - Commit data at exit of this routine
3386: -- FND_API.G_FALSE - DO NOT commit data at exit of this routine
3387: -- p_Orig_RuleSet_Object_ID IN DEF_OBJECT_ID%TYPE
3388: --
3389: -- p_DS_IO_Def_ID IN DEF_OBJECT_DEFINITION_ID%TYPE
3390: --

Line 3418: -- FND_API.G_RET_STS_SUCCESS - Call was successful, msgs may

3414: --
3415: -- OUT
3416: -- x_return_status OUT VARCHAR2
3417: -- Possible return status:
3418: -- FND_API.G_RET_STS_SUCCESS - Call was successful, msgs may
3419: -- still be present (check x_msg_count)
3420: -- FND_API.G_RET_STS_ERROR - Call was not successful, msgs should
3421: -- be present (check x_msg_count)
3422: -- FND_API.G_RET_STS_UNEXP_ERROR - Unexpected errors occurred which are

Line 3420: -- FND_API.G_RET_STS_ERROR - Call was not successful, msgs should

3416: -- x_return_status OUT VARCHAR2
3417: -- Possible return status:
3418: -- FND_API.G_RET_STS_SUCCESS - Call was successful, msgs may
3419: -- still be present (check x_msg_count)
3420: -- FND_API.G_RET_STS_ERROR - Call was not successful, msgs should
3421: -- be present (check x_msg_count)
3422: -- FND_API.G_RET_STS_UNEXP_ERROR - Unexpected errors occurred which are
3423: -- unrecoverable (check x_msg_count)
3424: --

Line 3422: -- FND_API.G_RET_STS_UNEXP_ERROR - Unexpected errors occurred which are

3418: -- FND_API.G_RET_STS_SUCCESS - Call was successful, msgs may
3419: -- still be present (check x_msg_count)
3420: -- FND_API.G_RET_STS_ERROR - Call was not successful, msgs should
3421: -- be present (check x_msg_count)
3422: -- FND_API.G_RET_STS_UNEXP_ERROR - Unexpected errors occurred which are
3423: -- unrecoverable (check x_msg_count)
3424: --
3425: -- x_msg_count OUT NUMBER
3426: -- Count of messages returned. If x_msg_count = 1, then the message is returned

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

3436: -- *******************************************************************************************
3437:
3438: PROCEDURE FEM_Preprocess_RuleSet_PVT(
3439: p_api_version IN NUMBER
3440: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3441: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3442: ,p_encoded IN VARCHAR2 := FND_API.G_TRUE
3443: ,x_return_status OUT NOCOPY VARCHAR2
3444: ,x_msg_count OUT NOCOPY NUMBER

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

3437:
3438: PROCEDURE FEM_Preprocess_RuleSet_PVT(
3439: p_api_version IN NUMBER
3440: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3441: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3442: ,p_encoded IN VARCHAR2 := FND_API.G_TRUE
3443: ,x_return_status OUT NOCOPY VARCHAR2
3444: ,x_msg_count OUT NOCOPY NUMBER
3445: ,x_msg_data OUT NOCOPY VARCHAR2

Line 3442: ,p_encoded IN VARCHAR2 := FND_API.G_TRUE

3438: PROCEDURE FEM_Preprocess_RuleSet_PVT(
3439: p_api_version IN NUMBER
3440: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3441: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3442: ,p_encoded IN VARCHAR2 := FND_API.G_TRUE
3443: ,x_return_status OUT NOCOPY VARCHAR2
3444: ,x_msg_count OUT NOCOPY NUMBER
3445: ,x_msg_data OUT NOCOPY VARCHAR2
3446: ,p_Orig_RuleSet_Object_ID IN DEF_OBJECT_ID%TYPE

Line 3506: x_return_status := FND_API.G_RET_STS_SUCCESS;

3502: -- standard API support header ------------------------
3503: -------------------------------------------------------
3504:
3505: -- initialize our status to 'we are good!'
3506: x_return_status := FND_API.G_RET_STS_SUCCESS;
3507:
3508: -- setup save point for rollbacks..
3509: SAVEPOINT FEM_Preprocess_RuleSet_SvPt;
3510:

Line 3545: IF fnd_api.to_Boolean(p_init_msg_list) THEN

3541: p_msg_text=> 'p_Execution_Mode(' || p_Execution_Mode || ')');
3542:
3543:
3544: -- initialize msg stack?
3545: IF fnd_api.to_Boolean(p_init_msg_list) THEN
3546: fnd_msg_pub.initialize;
3547: END IF;
3548:
3549: -- since this interface is PVT, this use is trusted and error capture

Line 3564: IF NOT fnd_api.Compatible_API_Call (l_api_version,

3560: p_msg_text=> 'z_continue_on_error := TRUE');
3561: END IF;
3562:
3563: -- check API version...
3564: IF NOT fnd_api.Compatible_API_Call (l_api_version,
3565: p_api_version,
3566: l_api_name,
3567: G_PKG_NAME ) THEN
3568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3564: IF NOT fnd_api.Compatible_API_Call (l_api_version,
3565: p_api_version,
3566: l_api_name,
3567: G_PKG_NAME ) THEN
3568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3569: END IF;
3570:
3571: -------------------------------------------------------
3572: -- end of standard API support header -----------------

Line 3591: RAISE FND_API.G_EXC_ERROR;

3587: G_APP_NAME,
3588: G_ERRMSG_NO_DSG_FOR_LID );
3589:
3590: -- this one is bad.. our master rule/ruleset has an invalid VS combo ID.. bomb out now
3591: RAISE FND_API.G_EXC_ERROR;
3592: End If;
3593:
3594: Begin /*--Check Local VS of Rule Set being run --*/
3595: select local_vs_combo_id

Line 3609: RAISE FND_API.G_EXC_ERROR;

3605: G_ERRMSG_NO_VALID_VALSETS,
3606: G_ERRMAC_RULE_NAME,
3607: GetObjectDisplayName(p_Orig_RuleSet_Object_ID));
3608:
3609: RAISE FND_API.G_EXC_ERROR;
3610: End If;
3611: End;
3612:
3613: l_Rule_Effective_Date := FND_DATE.CANONICAL_TO_DATE(p_Rule_Effective_Date);

Line 3673: RAISE FND_API.G_EXC_ERROR;

3669: FEM_UTILS.set_master_err_state( z_master_err_state,
3670: FEM_UTILS.G_RSM_NONFATAL_ERR,
3671: G_APP_NAME,
3672: G_ERRMSG_DSGRP_NOT_FOUND );
3673: RAISE FND_API.G_EXC_ERROR;
3674: End If;
3675:
3676: -- For fatal errors, force a rollback and get out..
3677: IF (z_master_err_state = FEM_UTILS.G_RSM_FATAL_ERR) THEN

Line 3678: RAISE FND_API.G_EXC_ERROR;

3674: End If;
3675:
3676: -- For fatal errors, force a rollback and get out..
3677: IF (z_master_err_state = FEM_UTILS.G_RSM_FATAL_ERR) THEN
3678: RAISE FND_API.G_EXC_ERROR;
3679: -- For nonfatal errors, report error if "continue to process on error"
3680: -- is set to No. In either case, do not rollback what was stored
3681: -- in fem_ruleset_process_data so the engines can run.
3682: -- Ideally, we want to differentiate between a fatal and nonfatal error

Line 3683: -- but since the FND API Standard has only one expected error code,

3679: -- For nonfatal errors, report error if "continue to process on error"
3680: -- is set to No. In either case, do not rollback what was stored
3681: -- in fem_ruleset_process_data so the engines can run.
3682: -- Ideally, we want to differentiate between a fatal and nonfatal error
3683: -- but since the FND API Standard has only one expected error code,
3684: -- we have to continue to report error for the same cases as before this
3685: -- change for backward compatability.
3686: ELSIF ((z_master_err_state = FEM_UTILS.G_RSM_NONFATAL_ERR) AND
3687: (NOT z_continue_on_error)) THEN

Line 3688: x_return_status := FND_API.G_RET_STS_ERROR;

3684: -- we have to continue to report error for the same cases as before this
3685: -- change for backward compatability.
3686: ELSIF ((z_master_err_state = FEM_UTILS.G_RSM_NONFATAL_ERR) AND
3687: (NOT z_continue_on_error)) THEN
3688: x_return_status := FND_API.G_RET_STS_ERROR;
3689: END IF;
3690:
3691:
3692: -------------------------------------------------------

Line 3695: IF fnd_api.to_boolean(p_commit) THEN

3691:
3692: -------------------------------------------------------
3693: -- standard API support
3694: -------------------------------------------------------
3695: IF fnd_api.to_boolean(p_commit) THEN
3696: COMMIT WORK;
3697: END IF;
3698:
3699: fem_engines_pkg.tech_message(p_severity=>G_LOG_PROCEDURE ,

Line 3708: WHEN FND_API.G_EXC_ERROR THEN

3704: x_msg_count,
3705: x_msg_data );
3706:
3707: EXCEPTION
3708: WHEN FND_API.G_EXC_ERROR THEN
3709: ROLLBACK TO FEM_Preprocess_RuleSet_SvPt;
3710: FND_MSG_PUB.Count_And_Get ( p_encoded,
3711: x_msg_count,
3712: x_msg_data );

Line 3713: x_return_status := FND_API.G_RET_STS_ERROR;

3709: ROLLBACK TO FEM_Preprocess_RuleSet_SvPt;
3710: FND_MSG_PUB.Count_And_Get ( p_encoded,
3711: x_msg_count,
3712: x_msg_data );
3713: x_return_status := FND_API.G_RET_STS_ERROR;
3714:
3715:
3716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3717: ROLLBACK TO FEM_Preprocess_RuleSet_SvPt;

Line 3716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3712: x_msg_data );
3713: x_return_status := FND_API.G_RET_STS_ERROR;
3714:
3715:
3716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3717: ROLLBACK TO FEM_Preprocess_RuleSet_SvPt;
3718: FND_MSG_PUB.Count_And_Get ( p_encoded,
3719: x_msg_count,
3720: x_msg_data );

Line 3722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3718: FND_MSG_PUB.Count_And_Get ( p_encoded,
3719: x_msg_count,
3720: x_msg_data );
3721:
3722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3723:
3724: WHEN OTHERS THEN
3725: FEM_UTILS.set_master_err_state( z_master_err_state,
3726: FEM_UTILS.G_RSM_FATAL_ERR,

Line 3741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3737: FND_MSG_PUB.Count_And_Get ( p_encoded,
3738: x_msg_count,
3739: x_msg_data );
3740:
3741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3742:
3743:
3744: END FEM_Preprocess_RuleSet_PVT;
3745: