APPS.VEA_RELEASE_DETAILS_SV dependencies on VEA_TPA_UTIL_PVT

Line 47: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

43: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
44: l_location VARCHAR2(32767);
45: --
46: --
47: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
48: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
49: --}
50: BEGIN
51: --{

Line 48: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

44: l_location VARCHAR2(32767);
45: --
46: --
47: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
48: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
49: --}
50: BEGIN
51: --{
52: l_location := '0010';

Line 84: vea_tpa_util_pvt.add_exc_message_and_raise

80: --{
81: WHEN OTHERS
82: THEN
83: --{
84: vea_tpa_util_pvt.add_exc_message_and_raise
85: (
86: p_package_name => G_PACKAGE_NAME,
87: p_api_name => l_api_name,
88: p_location => l_location

Line 122: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

118: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
119: l_location VARCHAR2(32767);
120: --
121: --
122: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
123: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
124: --}
125: BEGIN
126: --{

Line 123: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

119: l_location VARCHAR2(32767);
120: --
121: --
122: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
123: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
124: --}
125: BEGIN
126: --{
127: l_location := '0010';

Line 149: vea_tpa_util_pvt.add_exc_message_and_raise

145: --{
146: WHEN OTHERS
147: THEN
148: --{
149: vea_tpa_util_pvt.add_exc_message_and_raise
150: (
151: p_package_name => G_PACKAGE_NAME,
152: p_api_name => l_api_name,
153: p_location => l_location

Line 192: l_api_type CONSTANT VARCHAR2(3) := vea_tpa_util_pvt.G_PUBLIC_API;

188: IS
189: --{
190: l_api_name CONSTANT VARCHAR2(30) := 'process';
191: l_api_version CONSTANT NUMBER := 1.0;
192: l_api_type CONSTANT VARCHAR2(3) := vea_tpa_util_pvt.G_PUBLIC_API;
193: --
194: --
195: l_location VARCHAR2(32767);
196: l_savepoint_name VARCHAR2(30);

Line 226: IF NOT( vea_tpa_util_pvt.is_vea_installed() )

222: BEGIN
223: --{
224: l_location := '0010';
225: --
226: IF NOT( vea_tpa_util_pvt.is_vea_installed() )
227: THEN
228: RETURN;
229: END IF;
230: --

Line 236: vea_tpa_util_pvt.api_header

232: -- Standard API Header
233: --
234: l_location := '0020';
235: --
236: vea_tpa_util_pvt.api_header
237: (
238: p_package_name => G_PACKAGE_NAME,
239: p_api_name => l_api_name,
240: p_api_type => l_api_type,

Line 258: IF (VEA_TPA_UTIL_PVT.isLayerMergeOn) THEN

254: l_layer_id := NULL;
255: l_release_id := p_release_id;
256: g_release_id := p_release_id;
257: --
258: IF (VEA_TPA_UTIL_PVT.isLayerMergeOn) THEN
259: --{
260: l_tp_layer_id := nvl(vea_tp_layers_sv.g_tp_layer_id,p_tp_layer_id);
261: --}
262: ELSE

Line 340: vea_tpa_util_pvt.api_footer

336: -- Standard API Footer
337: --
338: l_location := '0090';
339: --
340: vea_tpa_util_pvt.api_footer
341: (
342: p_commit => p_commit,
343: x_msg_count => x_msg_count,
344: x_msg_data => x_msg_data

Line 353: vea_tpa_util_pvt.handle_error

349: WHEN FND_API.G_EXC_ERROR
350: THEN
351: --{
352: --RAISE;
353: vea_tpa_util_pvt.handle_error
354: (
355: p_error_type => vea_tpa_util_pvt.G_ERROR,
356: p_savepoint_name => l_savepoint_name,
357: p_package_name => G_PACKAGE_NAME,

Line 355: p_error_type => vea_tpa_util_pvt.G_ERROR,

351: --{
352: --RAISE;
353: vea_tpa_util_pvt.handle_error
354: (
355: p_error_type => vea_tpa_util_pvt.G_ERROR,
356: p_savepoint_name => l_savepoint_name,
357: p_package_name => G_PACKAGE_NAME,
358: p_api_name => l_api_name,
359: p_location => l_location,

Line 369: vea_tpa_util_pvt.handle_error

365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
366: THEN
367: --{
368: --RAISE;
369: vea_tpa_util_pvt.handle_error
370: (
371: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,
372: p_savepoint_name => l_savepoint_name,
373: p_package_name => G_PACKAGE_NAME,

Line 371: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,

367: --{
368: --RAISE;
369: vea_tpa_util_pvt.handle_error
370: (
371: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,
372: p_savepoint_name => l_savepoint_name,
373: p_package_name => G_PACKAGE_NAME,
374: p_api_name => l_api_name,
375: p_location => l_location,

Line 385: vea_tpa_util_pvt.handle_error

381: WHEN OTHERS
382: THEN
383: --{
384: --RAISE;
385: vea_tpa_util_pvt.handle_error
386: (
387: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,
388: p_savepoint_name => l_savepoint_name,
389: p_package_name => G_PACKAGE_NAME,

Line 387: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,

383: --{
384: --RAISE;
385: vea_tpa_util_pvt.handle_error
386: (
387: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,
388: p_savepoint_name => l_savepoint_name,
389: p_package_name => G_PACKAGE_NAME,
390: p_api_name => l_api_name,
391: p_location => l_location,