eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_THIRD_PARTY_MERGE dependencies on XLA_MESSAGES_PKG

Line 250: v_message := xla_messages_pkg.get_message

246: WHERE s.APPLICATION_ID = f.APPLICATION_ID
247: AND s.APPLICATION_ID = p_application_id;
248: EXCEPTION
249: WHEN NO_DATA_FOUND THEN
250: v_message := xla_messages_pkg.get_message
251: ( p_appli_s_name => 'XLA'
252: , p_msg_name => 'XLA_MERGE_INVALID_PARAM'
253: , p_token_1 => 'PARAMETER_VALUE'
254: , p_value_1 => p_application_id

Line 292: v_message := xla_messages_pkg.get_message

288: AND gl.complete_flag = 'Y'
289: AND rs.SLA_ACCOUNTING_METHOD_CODE IS NOT NULL;
290: EXCEPTION
291: WHEN NO_DATA_FOUND THEN
292: v_message := xla_messages_pkg.get_message
293: ( p_appli_s_name => 'XLA'
294: , p_msg_name => 'XLA_MERGE_INVALID_PARAM'
295: , p_token_1 => 'PARAMETER_VALUE'
296: , p_value_1 => p_ledger_id

Line 306: v_message := xla_messages_pkg.get_message

302:
303: -- Validate the third party merge date is passed
304: IF (p_third_party_merge_date IS NULL)
305: THEN
306: v_message := xla_messages_pkg.get_message
307: ( p_appli_s_name => 'XLA'
308: , p_msg_name => 'XLA_MERGE_INVALID_PARAM'
309: , p_token_1 => 'PARAMETER_VALUE'
310: , p_value_1 => ''''||p_third_party_merge_date||''''

Line 319: v_message := xla_messages_pkg.get_message

315:
316: -- Validate the passed third party type
317: IF (p_third_party_type <> 'C' AND p_third_party_type <> 'S')
318: THEN
319: v_message := xla_messages_pkg.get_message
320: ( p_appli_s_name => 'XLA'
321: , p_msg_name => 'XLA_MERGE_INVALID_PARAM'
322: , p_token_1 => 'PARAMETER_VALUE'
323: , p_value_1 => ''''||p_third_party_type||''''

Line 338: v_message := xla_messages_pkg.get_message

334: WHERE THIRD_PARTY_ID = p_original_third_party_id
335: AND THIRD_PARTY_TYPE = p_third_party_type;
336: EXCEPTION
337: WHEN NO_DATA_FOUND THEN
338: v_message := xla_messages_pkg.get_message
339: ( p_appli_s_name => 'XLA'
340: , p_msg_name => 'XLA_MERGE_INVALID_PARAM'
341: , p_token_1 => 'PARAMETER_VALUE'
342: , p_value_1 => p_original_third_party_id

Line 357: v_message := xla_messages_pkg.get_message

353: WHERE THIRD_PARTY_ID = p_new_third_party_id
354: AND THIRD_PARTY_TYPE = p_third_party_type;
355: EXCEPTION
356: WHEN NO_DATA_FOUND THEN
357: v_message := xla_messages_pkg.get_message
358: ( p_appli_s_name => 'XLA'
359: , p_msg_name => 'XLA_MERGE_INVALID_PARAM'
360: , p_token_1 => 'PARAMETER_VALUE'
361: , p_value_1 => p_new_third_party_id

Line 372: v_message := xla_messages_pkg.get_message

368: THEN
369: -- Validate the new site is passed if the original site is passed
370: IF (p_new_site_id IS NULL)
371: THEN
372: v_message := xla_messages_pkg.get_message
373: ( p_appli_s_name => 'XLA'
374: , p_msg_name => 'XLA_MERGE_SITE_ERR');
375: RAISE ValidationError;
376: END IF; -- IF (p_new_site_id IS NULL)

Line 389: v_message := xla_messages_pkg.get_message

385: AND THIRD_PARTY_TYPE = p_third_party_type
386: AND ROWNUM = 1; -- May return multiple sites (e.g. different ship tos)
387: EXCEPTION
388: WHEN NO_DATA_FOUND THEN
389: v_message := xla_messages_pkg.get_message
390: ( p_appli_s_name => 'XLA'
391: , p_msg_name => 'XLA_MERGE_INVALID_PARAM'
392: , p_token_1 => 'PARAMETER_VALUE'
393: , p_value_1 => p_original_site_id

Line 410: v_message := xla_messages_pkg.get_message

406: AND THIRD_PARTY_TYPE = p_third_party_type
407: AND ROWNUM = 1; -- May return multiple sites (e.g. different ship tos)
408: EXCEPTION
409: WHEN NO_DATA_FOUND THEN
410: v_message := xla_messages_pkg.get_message
411: ( p_appli_s_name => 'XLA'
412: , p_msg_name => 'XLA_MERGE_INVALID_PARAM'
413: , p_token_1 => 'PARAMETER_VALUE'
414: , p_value_1 => p_new_site_id

Line 426: v_message := xla_messages_pkg.get_message

422: -- Validate the passed third party merge type
423: IF (p_type_of_third_party_merge <> 'FULL'
424: AND p_type_of_third_party_merge <> 'PARTIAL')
425: THEN
426: v_message := xla_messages_pkg.get_message
427: ( p_appli_s_name => 'XLA'
428: , p_msg_name => 'XLA_MERGE_INVALID_PARAM'
429: , p_token_1 => 'PARAMETER_VALUE'
430: , p_value_1 => ''''||p_type_of_third_party_merge||''''

Line 453: v_message := xla_messages_pkg.get_message

449:
450: IF (v_dummy = 'Y')
451: THEN
452: -- The segment code is not unqiue per applicaiton/ledger
453: v_message := xla_messages_pkg.get_message
454: ( p_appli_s_name => 'XLA'
455: , p_msg_name => 'XLA_MERGE_MAPPING_ERR');
456: RAISE ValidationError;
457: END IF; -- IF (v_dummy = 'Y')

Line 465: v_message := xla_messages_pkg.get_message

461: -- Validate the passed execution mode
462: IF (p_execution_mode <> 'ASYNC_NOREQ' AND p_execution_mode <> 'ASYNC_REQ'
463: AND p_execution_mode <> 'SYNC')
464: THEN
465: v_message := xla_messages_pkg.get_message
466: ( p_appli_s_name => 'XLA'
467: , p_msg_name => 'XLA_MERGE_INVALID_PARAM'
468: , p_token_1 => 'PARAMETER_VALUE'
469: , p_value_1 => ''''||p_execution_mode||''''

Line 597: v_message := xla_messages_pkg.get_message

593: v_mapping_flag := 'N';
594: END;
595:
596: IF(v_mapping_flag = 'N') THEN
597: v_message := xla_messages_pkg.get_message
598: ( p_appli_s_name => 'XLA'
599: , p_msg_name => 'XLA_MERGE_NO_MAPPING');
600: RAISE ValidationError;
601: END IF;

Line 771: v_message := xla_messages_pkg.get_message

767: || ' rows into XLA_PARTIAL_MERGE_TXNS'
768: , p_level => C_LEVEL_STATEMENT
769: , p_module => v_module);
770: IF(v_row_count = 0) THEN
771: v_message := xla_messages_pkg.get_message
772: ( p_appli_s_name => 'XLA'
773: , p_msg_name => 'XLA_MERGE_NO_TRX_SET');
774: RAISE ValidationError;
775: END IF;

Line 871: v_message := xla_messages_pkg.get_message

867:
868: IF (v_event_count = 0)
869: THEN
870: -- No events are created
871: v_message := xla_messages_pkg.get_message
872: ( p_appli_s_name => 'XLA'
873: , p_msg_name => 'XLA_MERGE_NO_LG_ERR'
874: , p_token_1 => 'SUBLEDGER_APPLICATION_NAME'
875: , p_value_1 => v_application_name);

Line 965: x_errbuf := xla_messages_pkg.get_message

961: trace( p_msg => v_message
962: , p_level => C_LEVEL_ERROR
963: , p_module => v_module);
964: -- Set the out parameters
965: x_errbuf := xla_messages_pkg.get_message
966: ( p_appli_s_name => 'XLA'
967: , p_msg_name => 'XLA_MERGE_FATAL_ERR'
968: , p_token_1 => 'FUNCTION'
969: , p_value_1 => v_function

Line 1022: x_errbuf := xla_messages_pkg.get_message

1018: trace( p_msg => v_message
1019: , p_level => C_LEVEL_UNEXPECTED
1020: , p_module => v_module);
1021: -- Set the out parameters
1022: x_errbuf := xla_messages_pkg.get_message
1023: ( p_appli_s_name => 'XLA'
1024: , p_msg_name => 'XLA_MERGE_FATAL_ERR'
1025: , p_token_1 => 'FUNCTION'
1026: , p_value_1 => v_function

Line 3864: v_aeh_desc := xla_messages_pkg.get_message

3860: , p_level => C_LEVEL_PROCEDURE
3861: , p_module => v_module);
3862: END IF; -- IF (C_LEVEL_PROCEDURE >= g_log_level)
3863:
3864: v_aeh_desc := xla_messages_pkg.get_message
3865: ( p_appli_s_name => 'XLA'
3866: , p_msg_name => 'XLA_MERGE_AEH_DESC'
3867: , p_token_1 => 'MERGE_DATE'
3868: , p_value_1 => p_merge_date);

Line 5317: v_message := xla_messages_pkg.get_message

5313: WHERE s.APPLICATION_ID = f.APPLICATION_ID
5314: AND s.APPLICATION_ID = p_application_id;
5315: EXCEPTION
5316: WHEN NO_DATA_FOUND THEN
5317: v_message := xla_messages_pkg.get_message
5318: ( p_appli_s_name => 'XLA'
5319: , p_msg_name => 'XLA_MERGE_INVALID_PARAM'
5320: , p_token_1 => 'PARAMETER_VALUE'
5321: , p_value_1 => p_application_id

Line 5347: v_message := xla_messages_pkg.get_message

5343: WHERE EVENT_ID = p_merge_event_set_id
5344: AND EVENT_TYPE_CODE IN ('PARTIAL_MERGE', 'FULL_MERGE');
5345: EXCEPTION
5346: WHEN NO_DATA_FOUND THEN
5347: v_message := xla_messages_pkg.get_message
5348: ( p_appli_s_name => 'XLA'
5349: , p_msg_name => 'XLA_MERGE_INVALID_PARAM'
5350: , p_token_1 => 'PARAMETER_VALUE'
5351: , p_value_1 => p_merge_event_set_id

Line 5367: v_message := xla_messages_pkg.get_message

5363: WHERE EVENT_ID = p_event_id
5364: AND EVENT_TYPE_CODE IN ('PARTIAL_MERGE', 'FULL_MERGE');
5365: EXCEPTION
5366: WHEN NO_DATA_FOUND THEN
5367: v_message := xla_messages_pkg.get_message
5368: ( p_appli_s_name => 'XLA'
5369: , p_msg_name => 'XLA_MERGE_INVALID_PARAM'
5370: , p_token_1 => 'PARAMETER_VALUE'
5371: , p_value_1 => p_event_id

Line 5520: v_ael_desc1 := xla_messages_pkg.get_message

5516:
5517: -- Get messages for AE header and lines descriptions
5518: -- this is the description for reverse and rebooking header
5519: -- and the line desc for 'change' option
5520: v_ael_desc1 := xla_messages_pkg.get_message
5521: ( p_appli_s_name => 'XLA'
5522: , p_msg_name => 'XLA_MERGE_AE_DESC1'
5523: , p_token_1 => 'ORIGINAL'
5524: , p_value_1 => v_original_party_number

Line 5529: v_ael_desc2 := xla_messages_pkg.get_message

5525: , p_token_2 => 'NEW'
5526: , p_value_2 => v_new_party_number);
5527:
5528: -- this is the description for transfer balance, both line and header
5529: v_ael_desc2 := xla_messages_pkg.get_message
5530: ( p_appli_s_name => 'XLA'
5531: , p_msg_name => 'XLA_MERGE_AE_DESC2'
5532: , p_token_1 => 'ORIGINAL'
5533: , p_value_1 => v_original_party_number

Line 5538: v_ael_desc3 := xla_messages_pkg.get_message

5534: , p_token_2 => 'NEW'
5535: , p_value_2 => v_new_party_number);
5536:
5537: -- this is the description for reverse lines
5538: v_ael_desc3 := xla_messages_pkg.get_message
5539: ( p_appli_s_name => 'XLA'
5540: , p_msg_name => 'XLA_MERGE_AE_DESC3'
5541: , p_token_1 => 'ORIGINAL'
5542: , p_value_1 => v_original_party_number

Line 5547: v_ael_desc4 := xla_messages_pkg.get_message

5543: , p_token_2 => 'NEW'
5544: , p_value_2 => v_new_party_number);
5545:
5546: -- this is the description for rebooking lines
5547: v_ael_desc4 := xla_messages_pkg.get_message
5548: ( p_appli_s_name => 'XLA'
5549: , p_msg_name => 'XLA_MERGE_AE_DESC4'
5550: , p_token_1 => 'ORIGINAL'
5551: , p_value_1 => v_original_party_number

Line 5564: v_ael_desc1 := xla_messages_pkg.get_message

5560: -- and the line desc for 'change' option
5561: --
5562: -- Use message XLA_MERGE_AE_DESC_SITE as site code is populated
5563: --
5564: v_ael_desc1 := xla_messages_pkg.get_message
5565: ( p_appli_s_name => 'XLA'
5566: , p_msg_name => 'XLA_MERGE_AE_DESC_SITE1'
5567: , p_token_1 => 'ORIGINAL_PARTY_NUMBER'
5568: , p_value_1 => v_original_party_number

Line 5577: v_ael_desc2 := xla_messages_pkg.get_message

5573: , p_token_4 => 'NEW_PARTY_SITE_CODE'
5574: , p_value_4 => v_new_site_code);
5575:
5576: -- this is the description for transfer balance, both line and header
5577: v_ael_desc2 := xla_messages_pkg.get_message
5578: ( p_appli_s_name => 'XLA'
5579: , p_msg_name => 'XLA_MERGE_AE_DESC_SITE2'
5580: , p_token_1 => 'ORIGINAL_PARTY_NUMBER'
5581: , p_value_1 => v_original_party_number

Line 5590: v_ael_desc3 := xla_messages_pkg.get_message

5586: , p_token_4 => 'NEW_PARTY_SITE_CODE'
5587: , p_value_4 => v_new_site_code);
5588:
5589: -- this is the description for reverse lines
5590: v_ael_desc3 := xla_messages_pkg.get_message
5591: ( p_appli_s_name => 'XLA'
5592: , p_msg_name => 'XLA_MERGE_AE_DESC_SITE3'
5593: , p_token_1 => 'ORIGINAL_PARTY_NUMBER'
5594: , p_value_1 => v_original_party_number

Line 5603: v_ael_desc4 := xla_messages_pkg.get_message

5599: , p_token_4 => 'NEW_PARTY_SITE_CODE'
5600: , p_value_4 => v_new_site_code);
5601:
5602: -- this is the description for rebooking lines
5603: v_ael_desc4 := xla_messages_pkg.get_message
5604: ( p_appli_s_name => 'XLA'
5605: , p_msg_name => 'XLA_MERGE_AE_DESC_SITE4'
5606: , p_token_1 => 'ORIGINAL_PARTY_NUMBER'
5607: , p_value_1 => v_original_party_number

Line 5755: x_errbuf := xla_messages_pkg.get_message

5751:
5752: IF (v_processed_event_count = 0)
5753: THEN
5754: -- No events are processed
5755: x_errbuf := xla_messages_pkg.get_message
5756: ( p_appli_s_name => 'XLA'
5757: , p_msg_name => 'XLA_MERGE_ACCT_NO_EVENT'
5758: , p_token_1 => 'SUBLEDGER_APPLICATION_NAME'
5759: , p_value_1 => v_application_name);

Line 5814: x_errbuf := xla_messages_pkg.get_message

5810: trace( p_msg => v_message
5811: , p_level => C_LEVEL_ERROR
5812: , p_module => v_module);
5813: -- Set the out parameters
5814: x_errbuf := xla_messages_pkg.get_message
5815: ( p_appli_s_name => 'XLA'
5816: , p_msg_name => 'XLA_MERGE_FATAL_ERR'
5817: , p_token_1 => 'FUNCTION'
5818: , p_value_1 => v_function

Line 5841: x_errbuf := xla_messages_pkg.get_message

5837: trace( p_msg => v_message
5838: , p_level => C_LEVEL_UNEXPECTED
5839: , p_module => v_module);
5840: -- Set the out parameters
5841: x_errbuf := xla_messages_pkg.get_message
5842: ( p_appli_s_name => 'XLA'
5843: , p_msg_name => 'XLA_MERGE_FATAL_ERR'
5844: , p_token_1 => 'FUNCTION'
5845: , p_value_1 => v_function