DBA Data[Home] [Help]

APPS.XLA_AAD_MERGE_PVT dependencies on XLA_AAD_LOADER_UTIL_PVT

Line 121: l_retcode := xla_aad_loader_util_pvt.lock_area

117: CLOSE c;
118: l_lock_error := FALSE;
119:
120: IF (l_retcode = 'SUCCESS') THEN
121: l_retcode := xla_aad_loader_util_pvt.lock_area
122: (p_application_id => g_application_id
123: ,p_amb_context_code => g_amb_context_code);
124:
125: IF (l_retcode <> 'SUCCESS') THEN

Line 126: xla_aad_loader_util_pvt.stack_error

122: (p_application_id => g_application_id
123: ,p_amb_context_code => g_amb_context_code);
124:
125: IF (l_retcode <> 'SUCCESS') THEN
126: xla_aad_loader_util_pvt.stack_error
127: (p_appli_s_name => 'XLA'
128: ,p_msg_name => 'XLA_AAD_MGR_LOCK_FAILED');
129: l_retcode := 'WARNING';
130: END IF;

Line 155: xla_aad_loader_util_pvt.stack_error

151: p_module => l_log_module,
152: p_level => C_LEVEL_PROCEDURE);
153: END IF;
154:
155: xla_aad_loader_util_pvt.stack_error
156: (p_appli_s_name => 'XLA'
157: ,p_msg_name => 'XLA_AAD_MGR_LOCK_FAILED');
158:
159: RETURN l_retcode;

Line 161: xla_aad_loader_util_pvt.stack_error

157: ,p_msg_name => 'XLA_AAD_MGR_LOCK_FAILED');
158:
159: RETURN l_retcode;
160: ELSE
161: xla_aad_loader_util_pvt.stack_error
162: (p_appli_s_name => 'XLA'
163: ,p_msg_name => 'XLA_COMMON_ERROR'
164: ,p_token_1 => 'LOCATION'
165: ,p_value_1 => 'xla_aad_merge_pvt.pre_merge'

Line 241: l_retcode := xla_aad_loader_util_pvt.validate_adr_compatibility

237: END IF;
238:
239: l_retcode := 'SUCCESS';
240:
241: l_retcode := xla_aad_loader_util_pvt.validate_adr_compatibility
242: (p_application_id => g_application_id
243: ,p_amb_context_code => g_amb_context_code
244: ,p_staging_context_code => g_staging_context_code);
245:

Line 254: xla_aad_loader_util_pvt.stack_error

250: OPEN c_updated;
251: FETCH c_updated INTO l_exists;
252: IF (c_updated%NOTFOUND) THEN
253: l_retcode := 'WARNING';
254: xla_aad_loader_util_pvt.stack_error
255: (p_appli_s_name => 'XLA'
256: ,p_msg_name => 'XLA_AAD_MER_AMB_UPDATED');
257: END IF;
258: CLOSE c_updated;

Line 265: xla_aad_loader_util_pvt.stack_error

261: -- If merge analysis is not run, make sure no AAD has a higher version in
262: -- working area than the original version of the one in the staging area
263: FOR l_err in c_invalid_versions LOOP
264: l_retcode := 'WARNING';
265: xla_aad_loader_util_pvt.stack_error
266: (p_appli_s_name => 'XLA'
267: ,p_msg_name => 'XLA_AAD_MER_INVALID_AAD_VERS'
268: ,p_token_1 => 'PROD_RULE_NAME'
269: ,p_value_1 => l_err.name);

Line 282: xla_aad_loader_util_pvt.stack_error

278:
279: return l_retcode;
280: EXCEPTION
281: WHEN OTHERS THEN
282: xla_aad_loader_util_pvt.stack_error
283: (p_appli_s_name => 'XLA'
284: ,p_msg_name => 'XLA_COMMON_ERROR'
285: ,p_token_1 => 'LOCATION'
286: ,p_value_1 => 'xla_aad_merge_pvt.validation'

Line 503: xla_aad_loader_util_pvt.stack_error

499: END IF;
500:
501: EXCEPTION
502: WHEN OTHERS THEN
503: xla_aad_loader_util_pvt.stack_error
504: (p_appli_s_name => 'XLA'
505: ,p_msg_name => 'XLA_COMMON_ERROR'
506: ,p_token_1 => 'LOCATION'
507: ,p_value_1 => 'xla_aad_merge_pvt.clean_oracle_aads'

Line 789: xla_aad_loader_util_pvt.stack_error

785: END IF;
786:
787: EXCEPTION
788: WHEN OTHERS THEN
789: xla_aad_loader_util_pvt.stack_error
790: (p_appli_s_name => 'XLA'
791: ,p_msg_name => 'XLA_COMMON_ERROR'
792: ,p_token_1 => 'LOCATION'
793: ,p_value_1 => 'xla_aad_merge_pvt.clean_oracle_jlds'

Line 1001: xla_aad_loader_util_pvt.stack_error

997: END IF;
998:
999: EXCEPTION
1000: WHEN OTHERS THEN
1001: xla_aad_loader_util_pvt.stack_error
1002: (p_appli_s_name => 'XLA'
1003: ,p_msg_name => 'XLA_COMMON_ERROR'
1004: ,p_token_1 => 'LOCATION'
1005: ,p_value_1 => 'xla_aad_merge_pvt.clean_oracle_jlts'

Line 1171: xla_aad_loader_util_pvt.stack_error

1167: END IF;
1168:
1169: EXCEPTION
1170: WHEN OTHERS THEN
1171: xla_aad_loader_util_pvt.stack_error
1172: (p_appli_s_name => 'XLA'
1173: ,p_msg_name => 'XLA_COMMON_ERROR'
1174: ,p_token_1 => 'LOCATION'
1175: ,p_value_1 => 'xla_aad_merge_pvt.clean_oracle_descriptions'

Line 1399: xla_aad_loader_util_pvt.stack_error

1395: END IF;
1396:
1397: EXCEPTION
1398: WHEN OTHERS THEN
1399: xla_aad_loader_util_pvt.stack_error
1400: (p_appli_s_name => 'XLA'
1401: ,p_msg_name => 'XLA_COMMON_ERROR'
1402: ,p_token_1 => 'LOCATION'
1403: ,p_value_1 => 'xla_aad_merge_pvt.clean_oracle_adrs'

Line 1596: xla_aad_loader_util_pvt.stack_error

1592: END IF;
1593:
1594: EXCEPTION
1595: WHEN OTHERS THEN
1596: xla_aad_loader_util_pvt.stack_error
1597: (p_appli_s_name => 'XLA'
1598: ,p_msg_name => 'XLA_COMMON_ERROR'
1599: ,p_token_1 => 'LOCATION'
1600: ,p_value_1 => 'xla_aad_merge_pvt.clean_oracle_acs'

Line 1643: xla_aad_loader_util_pvt.stack_error

1639: END IF;
1640:
1641: EXCEPTION
1642: WHEN OTHERS THEN
1643: xla_aad_loader_util_pvt.stack_error
1644: (p_appli_s_name => 'XLA'
1645: ,p_msg_name => 'XLA_COMMON_ERROR'
1646: ,p_token_1 => 'LOCATION'
1647: ,p_value_1 => 'xla_aad_merge_pvt.clean_oracle_components'

Line 1937: xla_aad_loader_util_pvt.stack_error

1933: END IF;
1934:
1935: EXCEPTION
1936: WHEN OTHERS THEN
1937: xla_aad_loader_util_pvt.stack_error
1938: (p_appli_s_name => 'XLA'
1939: ,p_msg_name => 'XLA_COMMON_ERROR'
1940: ,p_token_1 => 'LOCATION'
1941: ,p_value_1 => 'xla_aad_merge_pvt.merge_aads'

Line 2344: xla_aad_loader_util_pvt.stack_error

2340: END IF;
2341:
2342: EXCEPTION
2343: WHEN OTHERS THEN
2344: xla_aad_loader_util_pvt.stack_error
2345: (p_appli_s_name => 'XLA'
2346: ,p_msg_name => 'XLA_COMMON_ERROR'
2347: ,p_token_1 => 'LOCATION'
2348: ,p_value_1 => 'xla_aad_merge_pvt.merge_journal_line_defns'

Line 2537: xla_aad_loader_util_pvt.stack_error

2533: END IF;
2534:
2535: EXCEPTION
2536: WHEN OTHERS THEN
2537: xla_aad_loader_util_pvt.stack_error
2538: (p_appli_s_name => 'XLA'
2539: ,p_msg_name => 'XLA_COMMON_ERROR'
2540: ,p_token_1 => 'LOCATION'
2541: ,p_value_1 => 'xla_aad_merge_pvt.merge_journal_line_types'

Line 2784: xla_aad_loader_util_pvt.stack_error

2780: END IF;
2781:
2782: EXCEPTION
2783: WHEN OTHERS THEN
2784: xla_aad_loader_util_pvt.stack_error
2785: (p_appli_s_name => 'XLA'
2786: ,p_msg_name => 'XLA_COMMON_ERROR'
2787: ,p_token_1 => 'LOCATION'
2788: ,p_value_1 => 'xla_aad_merge_pvt.merge_descriptions'

Line 3137: xla_aad_loader_util_pvt.stack_error

3133: END IF;
3134:
3135: EXCEPTION
3136: WHEN OTHERS THEN
3137: xla_aad_loader_util_pvt.stack_error
3138: (p_appli_s_name => 'XLA'
3139: ,p_msg_name => 'XLA_COMMON_ERROR'
3140: ,p_token_1 => 'LOCATION'
3141: ,p_value_1 => 'xla_aad_merge_pvt.merge_analytical_criteria'

Line 3332: xla_aad_loader_util_pvt.stack_error

3328: END IF;
3329:
3330: EXCEPTION
3331: WHEN OTHERS THEN
3332: xla_aad_loader_util_pvt.stack_error
3333: (p_appli_s_name => 'XLA'
3334: ,p_msg_name => 'XLA_COMMON_ERROR'
3335: ,p_token_1 => 'LOCATION'
3336: ,p_value_1 => 'xla_aad_merge_pvt.merge_adrs'

Line 3495: xla_aad_loader_util_pvt.stack_error

3491: END IF;
3492:
3493: EXCEPTION
3494: WHEN OTHERS THEN
3495: xla_aad_loader_util_pvt.stack_error
3496: (p_appli_s_name => 'XLA'
3497: ,p_msg_name => 'XLA_COMMON_ERROR'
3498: ,p_token_1 => 'LOCATION'
3499: ,p_value_1 => 'xla_aad_merge_pvt.merge_mapping_sets'

Line 3677: xla_aad_loader_util_pvt.stack_error

3673: END IF;
3674:
3675: EXCEPTION
3676: WHEN OTHERS THEN
3677: xla_aad_loader_util_pvt.stack_error
3678: (p_appli_s_name => 'XLA'
3679: ,p_msg_name => 'XLA_COMMON_ERROR'
3680: ,p_token_1 => 'LOCATION'
3681: ,p_value_1 => 'xla_aad_merge_pvt.merge_acctg_methods'

Line 3743: xla_aad_loader_util_pvt.stack_error

3739: END IF;
3740:
3741: EXCEPTION
3742: WHEN OTHERS THEN
3743: xla_aad_loader_util_pvt.stack_error
3744: (p_appli_s_name => 'XLA'
3745: ,p_msg_name => 'XLA_COMMON_ERROR'
3746: ,p_token_1 => 'LOCATION'
3747: ,p_value_1 => 'xla_aad_merge_pvt.merge_aads_and_setups'

Line 3810: xla_aad_loader_util_pvt.stack_error

3806: END IF;
3807:
3808: EXCEPTION
3809: WHEN OTHERS THEN
3810: xla_aad_loader_util_pvt.stack_error
3811: (p_appli_s_name => 'XLA'
3812: ,p_msg_name => 'XLA_COMMON_ERROR'
3813: ,p_token_1 => 'LOCATION'
3814: ,p_value_1 => 'xla_aad_merge_pvt.purge_mapping_sets'

Line 3895: xla_aad_loader_util_pvt.stack_error

3891: END IF;
3892:
3893: EXCEPTION
3894: WHEN OTHERS THEN
3895: xla_aad_loader_util_pvt.stack_error
3896: (p_appli_s_name => 'XLA'
3897: ,p_msg_name => 'XLA_COMMON_ERROR'
3898: ,p_token_1 => 'LOCATION'
3899: ,p_value_1 => 'xla_aad_merge_pvt.purge_analytical_criteria'

Line 3972: xla_aad_loader_util_pvt.stack_error

3968: END IF;
3969:
3970: EXCEPTION
3971: WHEN OTHERS THEN
3972: xla_aad_loader_util_pvt.stack_error
3973: (p_appli_s_name => 'XLA'
3974: ,p_msg_name => 'XLA_COMMON_ERROR'
3975: ,p_token_1 => 'LOCATION'
3976: ,p_value_1 => 'xla_aad_merge_pvt.purge_adrs'

Line 4004: xla_aad_loader_util_pvt.purge

4000: p_module => l_log_module,
4001: p_level => C_LEVEL_PROCEDURE);
4002: END IF;
4003:
4004: xla_aad_loader_util_pvt.purge
4005: (p_application_id => g_application_id
4006: ,p_amb_context_code => g_staging_context_code);
4007:
4008: purge_mapping_sets;

Line 4020: xla_aad_loader_util_pvt.stack_error

4016: END IF;
4017:
4018: EXCEPTION
4019: WHEN OTHERS THEN
4020: xla_aad_loader_util_pvt.stack_error
4021: (p_appli_s_name => 'XLA'
4022: ,p_msg_name => 'XLA_COMMON_ERROR'
4023: ,p_token_1 => 'LOCATION'
4024: ,p_value_1 => 'xla_aad_merge_pvt.purge_staging_area'

Line 4060: xla_aad_loader_util_pvt.stack_error

4056: END IF;
4057:
4058: EXCEPTION
4059: WHEN OTHERS THEN
4060: xla_aad_loader_util_pvt.stack_error
4061: (p_appli_s_name => 'XLA'
4062: ,p_msg_name => 'XLA_COMMON_ERROR'
4063: ,p_token_1 => 'LOCATION'
4064: ,p_value_1 => 'xla_aad_merge_pvt.template_api'

Line 4117: l_staging_context_code := xla_aad_loader_util_pvt.get_staging_context_code

4113: p_module => l_log_module,
4114: p_level => C_LEVEL_PROCEDURE);
4115: END IF;
4116:
4117: l_staging_context_code := xla_aad_loader_util_pvt.get_staging_context_code
4118: (p_application_id => p_application_id
4119: ,p_amb_context_code => p_amb_context_code);
4120:
4121: xla_aad_merge_pvt.merge

Line 4156: xla_aad_loader_util_pvt.stack_error

4152: ROLLBACK;
4153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4154: x_merge_status := 'ERROR';
4155:
4156: xla_aad_loader_util_pvt.stack_error
4157: (p_appli_s_name => 'XLA'
4158: ,p_msg_name => 'XLA_COMMON_ERROR'
4159: ,p_token_1 => 'LOCATION'
4160: ,p_value_1 => 'xla_aad_merge_pvt.merge'

Line 4207: IF (NOT xla_aad_loader_util_pvt.compatible_api_call

4203: p_level => C_LEVEL_PROCEDURE);
4204: END IF;
4205:
4206: -- Standard call to check for call compatibility.
4207: IF (NOT xla_aad_loader_util_pvt.compatible_api_call
4208: (p_current_version_number => l_api_version
4209: ,p_caller_version_number => p_api_version
4210: ,p_api_name => l_api_name
4211: ,p_pkg_name => C_DEFAULT_MODULE))

Line 4241: xla_aad_loader_util_pvt.merge_history

4237: END IF;
4238:
4239: merge_aads_and_setups;
4240:
4241: xla_aad_loader_util_pvt.merge_history
4242: (p_application_id => g_application_id
4243: ,p_staging_context_code => g_staging_context_code);
4244:
4245: purge_staging_area;

Line 4247: xla_aad_loader_util_pvt.rebuild_ac_views;

4243: ,p_staging_context_code => g_staging_context_code);
4244:
4245: purge_staging_area;
4246:
4247: xla_aad_loader_util_pvt.rebuild_ac_views;
4248:
4249: IF (p_compile_flag = 'Y') THEN
4250: IF (NOT xla_aad_loader_util_pvt.compile
4251: (p_application_id => g_application_id

Line 4250: IF (NOT xla_aad_loader_util_pvt.compile

4246:
4247: xla_aad_loader_util_pvt.rebuild_ac_views;
4248:
4249: IF (p_compile_flag = 'Y') THEN
4250: IF (NOT xla_aad_loader_util_pvt.compile
4251: (p_application_id => g_application_id
4252: ,p_amb_context_code => g_amb_context_code)) THEN
4253: RAISE G_EXC_WARNING;
4254: END IF;

Line 4281: xla_aad_loader_util_pvt.stack_error

4277: ROLLBACK;
4278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4279: x_merge_status := 'ERROR';
4280:
4281: xla_aad_loader_util_pvt.stack_error
4282: (p_appli_s_name => 'XLA'
4283: ,p_msg_name => 'XLA_COMMON_ERROR'
4284: ,p_token_1 => 'LOCATION'
4285: ,p_value_1 => 'xla_aad_merge_pvt.merge'