DBA Data[Home] [Help]

APPS.AME_RULE_API dependencies on FND_GLOBAL

Line 175: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) then

171: if actionTypeIds.count = 0 then
172: --+
173: -- if this call is not made from an SWI package, raise an exception and return false
174: --+
175: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) then
176: fnd_message.set_name('PER','AME_400724_NO_ACTION_IN_RULE');
177: hr_multi_message.add (p_associated_column1 =>'RULE_ID');
178: return(false);
179: else

Line 524: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK, l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) then

520: savepoint create_ame_rule;
521: l_swi_call := true;
522: l_item_class_id := p_item_class_id;
523: l_effective_date := sysdate;
524: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK, l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) then
525: --+ this procedure is not invoked from the UI.
526: l_swi_call := false;
527: --+
528: --+ Check the application id.

Line 1040: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK, l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) then

1036: l_effective_date := sysdate;
1037: l_rlu_start_date := p_start_date;
1038: l_rlu_end_date := p_end_date;
1039: l_swi_call := true;
1040: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK, l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) then
1041: l_swi_call := false;
1042: end if;
1043:
1044: -- If call is from the UI set the effective date to rule start date non future dated rules

Line 1271: -- if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) and

1267: --
1268: -- Check if the start date and end date for the rule has changed
1269: --
1270:
1271: -- if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) and
1272: l_create_ame_rule_call := true;
1273: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,'AME_RULE_API.CREATE_AME_RULE' ||fnd_global.local_chr(ascii_chr => 10)) = 0)then
1274: l_create_ame_rule_call := false;
1275: end if;

Line 1273: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,'AME_RULE_API.CREATE_AME_RULE' ||fnd_global.local_chr(ascii_chr => 10)) = 0)then

1269: --
1270:
1271: -- if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) and
1272: l_create_ame_rule_call := true;
1273: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,'AME_RULE_API.CREATE_AME_RULE' ||fnd_global.local_chr(ascii_chr => 10)) = 0)then
1274: l_create_ame_rule_call := false;
1275: end if;
1276: if not l_create_ame_rule_call and not l_swi_call then
1277: fetchNewRuleDates(p_rule_id => p_rule_id

Line 1538: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) then

1534:
1535: l_swi_call := true;
1536: ame_rule_utility_pkg.checkRuleId(p_rule_id => p_rule_id);
1537: ame_rule_utility_pkg.checkConditionId(p_condition_id => p_condition_id);
1538: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) then
1539: ame_rule_utility_pkg.chk_rule_and_item_class(p_rule_id => p_rule_id
1540: ,p_condition_id => p_condition_id);
1541: l_swi_call := false;
1542: end if;

Line 1622: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) then

1618: -- existing.
1619: --
1620: -- Fetch conditions and actions for rule
1621:
1622: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) then
1623: --+
1624: --+ Check if the rule is LM/SUB/LM COMB and error out if these rules already have an LM Condition.
1625: --+
1626: select count(*)

Line 2012: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) then

2008: ,actionIdIn => p_action_id);
2009: --+
2010: -- Fetch conditions and actions for rule
2011: l_swi_call := true;
2012: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) then
2013: --+
2014: --+ Check Rule Id.
2015: --+
2016: l_swi_call := false;

Line 2265: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) then

2261: --
2262: -- Check if the API is called from the SWI layer. If yes, update start and end dates for rules.
2263: -- Else only update Description.
2264: l_swi_call := true;
2265: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) then
2266: l_swi_call := false;
2267: -- If Description is null and call is not made from SWI layer, then raise an exception.
2268: if(p_description is null or
2269: p_description = hr_api.g_varchar2) then

Line 2491: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) then

2487: --+
2488: --+ Check the dates for the rule usage.
2489: --+
2490: l_swi_call := true;
2491: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) then
2492: l_swi_call := false ;
2493: if p_start_date < l_effective_date then
2494: fnd_message.set_name('PER','AME_400213_RUL_STRT_GRTR_CUR');
2495: hr_multi_message.add (p_associated_column1 => 'START_DATE');

Line 2558: /*if ((instrb(DBMS_UTILITY.FORMAT_CALL_STACK,l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) and

2554: --
2555: -- Perform check to see if rule dates have changed only if the usage dates are being changed and
2556: -- the call is not from an SWI package
2557: --
2558: /*if ((instrb(DBMS_UTILITY.FORMAT_CALL_STACK,l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) and
2559: p_start_date is null and
2560: p_end_date is null) then
2561: fetchNewRuleDates(p_rule_id => p_rule_id
2562: ,p_rlu_start_date => l_rlu_start_date

Line 2611: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) then

2607: end loop;
2608: end if;
2609: end if;*/
2610: --+
2611: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) then
2612: ame_rule_utility_pkg.syncRuleObjects(p_rule_id => p_rule_id);
2613: end if;
2614: --
2615: -- Call After Process User Hook

Line 2873: --if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) then

2869: -- If call is not made from an SWI package then
2870: -- Check number of usages which exist for this rule. If future and current usages at this
2871: -- point are = 0 delete the Condition Usage, Action Usage and Rule row too.
2872: --
2873: --if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) then
2874: select count(*)
2875: into l_usage_count
2876: from ame_rule_usages
2877: where rule_id = p_rule_id

Line 2921: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) then

2917: ,p_start_date => l_rul_start_date
2918: ,p_end_date => l_rul_end_date
2919: );
2920: else
2921: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) then
2922: ame_rule_utility_pkg.syncRuleObjects(p_rule_id => p_rule_id);
2923: end if;
2924: --+
2925: end if;

Line 3155: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) then

3151: hr_multi_message.add(p_associated_column1 => 'RULE_ID');
3152: end if;
3153: close getRuleDetails;
3154: l_swi_call := true;
3155: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) then
3156: l_swi_call := false;
3157: if not ame_rule_utility_pkg.is_cond_exist_in_rule(p_rule_id => p_rule_id
3158: ,p_condition_id => p_condition_id) then
3159: fnd_message.set_name('PER','AME_400772_CON_NOT_EXIST_RULE');

Line 3439: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) then

3435: savepoint delete_ame_rule_action ;
3436: --
3437: --
3438: l_swi_call := true;
3439: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) then
3440: l_swi_call := false;
3441: end if;
3442: --
3443: -- Call Before Process User Hook