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 252: v_message := xla_messages_pkg.get_message

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

Line 294: v_message := xla_messages_pkg.get_message

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

Line 308: v_message := xla_messages_pkg.get_message

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

Line 321: v_message := xla_messages_pkg.get_message

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

Line 340: v_message := xla_messages_pkg.get_message

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

Line 359: v_message := xla_messages_pkg.get_message

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

Line 374: v_message := xla_messages_pkg.get_message

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

Line 391: v_message := xla_messages_pkg.get_message

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

Line 412: v_message := xla_messages_pkg.get_message

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

Line 428: v_message := xla_messages_pkg.get_message

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

Line 455: v_message := xla_messages_pkg.get_message

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

Line 467: v_message := xla_messages_pkg.get_message

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

Line 602: v_message := xla_messages_pkg.get_message

598: v_mapping_flag := 'N';
599: END;
600:
601: IF(v_mapping_flag = 'N') THEN
602: v_message := xla_messages_pkg.get_message
603: ( p_appli_s_name => 'XLA'
604: , p_msg_name => 'XLA_MERGE_NO_MAPPING');
605: RAISE ValidationError;
606: END IF;

Line 778: v_message := xla_messages_pkg.get_message

774: || ' rows into XLA_PARTIAL_MERGE_TXNS'
775: , p_level => C_LEVEL_STATEMENT
776: , p_module => v_module);
777: IF(v_row_count = 0) THEN
778: v_message := xla_messages_pkg.get_message
779: ( p_appli_s_name => 'XLA'
780: , p_msg_name => 'XLA_MERGE_NO_TRX_SET');
781: RAISE ValidationError;
782: END IF;

Line 878: v_message := xla_messages_pkg.get_message

874:
875: IF (v_event_count = 0)
876: THEN
877: -- No events are created
878: v_message := xla_messages_pkg.get_message
879: ( p_appli_s_name => 'XLA'
880: , p_msg_name => 'XLA_MERGE_NO_LG_ERR'
881: , p_token_1 => 'SUBLEDGER_APPLICATION_NAME'
882: , p_value_1 => v_application_name);

Line 975: x_errbuf := xla_messages_pkg.get_message

971: trace( p_msg => v_message
972: , p_level => C_LEVEL_ERROR
973: , p_module => v_module);
974: -- Set the out parameters
975: x_errbuf := xla_messages_pkg.get_message
976: ( p_appli_s_name => 'XLA'
977: , p_msg_name => 'XLA_MERGE_FATAL_ERR'
978: , p_token_1 => 'FUNCTION'
979: , p_value_1 => v_function

Line 1032: x_errbuf := xla_messages_pkg.get_message

1028: trace( p_msg => v_message
1029: , p_level => C_LEVEL_UNEXPECTED
1030: , p_module => v_module);
1031: -- Set the out parameters
1032: x_errbuf := xla_messages_pkg.get_message
1033: ( p_appli_s_name => 'XLA'
1034: , p_msg_name => 'XLA_MERGE_FATAL_ERR'
1035: , p_token_1 => 'FUNCTION'
1036: , p_value_1 => v_function

Line 3909: v_aeh_desc := xla_messages_pkg.get_message

3905: , p_level => C_LEVEL_PROCEDURE
3906: , p_module => v_module);
3907: END IF; -- IF (C_LEVEL_PROCEDURE >= g_log_level)
3908:
3909: v_aeh_desc := xla_messages_pkg.get_message
3910: ( p_appli_s_name => 'XLA'
3911: , p_msg_name => 'XLA_MERGE_AEH_DESC'
3912: , p_token_1 => 'MERGE_DATE'
3913: , p_value_1 => p_merge_date);

Line 5380: v_message := xla_messages_pkg.get_message

5376: WHERE s.APPLICATION_ID = f.APPLICATION_ID
5377: AND s.APPLICATION_ID = p_application_id;
5378: EXCEPTION
5379: WHEN NO_DATA_FOUND THEN
5380: v_message := xla_messages_pkg.get_message
5381: ( p_appli_s_name => 'XLA'
5382: , p_msg_name => 'XLA_MERGE_INVALID_PARAM'
5383: , p_token_1 => 'PARAMETER_VALUE'
5384: , p_value_1 => p_application_id

Line 5410: v_message := xla_messages_pkg.get_message

5406: WHERE EVENT_ID = p_merge_event_set_id
5407: AND EVENT_TYPE_CODE IN ('PARTIAL_MERGE', 'FULL_MERGE');
5408: EXCEPTION
5409: WHEN NO_DATA_FOUND THEN
5410: v_message := xla_messages_pkg.get_message
5411: ( p_appli_s_name => 'XLA'
5412: , p_msg_name => 'XLA_MERGE_INVALID_PARAM'
5413: , p_token_1 => 'PARAMETER_VALUE'
5414: , p_value_1 => p_merge_event_set_id

Line 5430: v_message := xla_messages_pkg.get_message

5426: WHERE EVENT_ID = p_event_id
5427: AND EVENT_TYPE_CODE IN ('PARTIAL_MERGE', 'FULL_MERGE');
5428: EXCEPTION
5429: WHEN NO_DATA_FOUND THEN
5430: v_message := xla_messages_pkg.get_message
5431: ( p_appli_s_name => 'XLA'
5432: , p_msg_name => 'XLA_MERGE_INVALID_PARAM'
5433: , p_token_1 => 'PARAMETER_VALUE'
5434: , p_value_1 => p_event_id

Line 5685: v_ael_desc1 := xla_messages_pkg.get_message

5681:
5682: -- Get messages for AE header and lines descriptions
5683: -- this is the description for reverse and rebooking header
5684: -- and the line desc for 'change' option
5685: v_ael_desc1 := xla_messages_pkg.get_message
5686: ( p_appli_s_name => 'XLA'
5687: , p_msg_name => 'XLA_MERGE_AE_DESC1'
5688: , p_token_1 => 'ORIGINAL'
5689: , p_value_1 => v_original_party_number

Line 5694: v_ael_desc2 := xla_messages_pkg.get_message

5690: , p_token_2 => 'NEW'
5691: , p_value_2 => v_new_party_number);
5692:
5693: -- this is the description for transfer balance, both line and header
5694: v_ael_desc2 := xla_messages_pkg.get_message
5695: ( p_appli_s_name => 'XLA'
5696: , p_msg_name => 'XLA_MERGE_AE_DESC2'
5697: , p_token_1 => 'ORIGINAL'
5698: , p_value_1 => v_original_party_number

Line 5703: v_ael_desc3 := xla_messages_pkg.get_message

5699: , p_token_2 => 'NEW'
5700: , p_value_2 => v_new_party_number);
5701:
5702: -- this is the description for reverse lines
5703: v_ael_desc3 := xla_messages_pkg.get_message
5704: ( p_appli_s_name => 'XLA'
5705: , p_msg_name => 'XLA_MERGE_AE_DESC3'
5706: , p_token_1 => 'ORIGINAL'
5707: , p_value_1 => v_original_party_number

Line 5712: v_ael_desc4 := xla_messages_pkg.get_message

5708: , p_token_2 => 'NEW'
5709: , p_value_2 => v_new_party_number);
5710:
5711: -- this is the description for rebooking lines
5712: v_ael_desc4 := xla_messages_pkg.get_message
5713: ( p_appli_s_name => 'XLA'
5714: , p_msg_name => 'XLA_MERGE_AE_DESC4'
5715: , p_token_1 => 'ORIGINAL'
5716: , p_value_1 => v_original_party_number

Line 5729: v_ael_desc1 := xla_messages_pkg.get_message

5725: -- and the line desc for 'change' option
5726: --
5727: -- Use message XLA_MERGE_AE_DESC_SITE as site code is populated
5728: --
5729: v_ael_desc1 := xla_messages_pkg.get_message
5730: ( p_appli_s_name => 'XLA'
5731: , p_msg_name => 'XLA_MERGE_AE_DESC_SITE1'
5732: , p_token_1 => 'ORIGINAL_PARTY_NUMBER'
5733: , p_value_1 => v_original_party_number

Line 5742: v_ael_desc2 := xla_messages_pkg.get_message

5738: , p_token_4 => 'NEW_PARTY_SITE_CODE'
5739: , p_value_4 => v_new_site_code);
5740:
5741: -- this is the description for transfer balance, both line and header
5742: v_ael_desc2 := xla_messages_pkg.get_message
5743: ( p_appli_s_name => 'XLA'
5744: , p_msg_name => 'XLA_MERGE_AE_DESC_SITE2'
5745: , p_token_1 => 'ORIGINAL_PARTY_NUMBER'
5746: , p_value_1 => v_original_party_number

Line 5755: v_ael_desc3 := xla_messages_pkg.get_message

5751: , p_token_4 => 'NEW_PARTY_SITE_CODE'
5752: , p_value_4 => v_new_site_code);
5753:
5754: -- this is the description for reverse lines
5755: v_ael_desc3 := xla_messages_pkg.get_message
5756: ( p_appli_s_name => 'XLA'
5757: , p_msg_name => 'XLA_MERGE_AE_DESC_SITE3'
5758: , p_token_1 => 'ORIGINAL_PARTY_NUMBER'
5759: , p_value_1 => v_original_party_number

Line 5768: v_ael_desc4 := xla_messages_pkg.get_message

5764: , p_token_4 => 'NEW_PARTY_SITE_CODE'
5765: , p_value_4 => v_new_site_code);
5766:
5767: -- this is the description for rebooking lines
5768: v_ael_desc4 := xla_messages_pkg.get_message
5769: ( p_appli_s_name => 'XLA'
5770: , p_msg_name => 'XLA_MERGE_AE_DESC_SITE4'
5771: , p_token_1 => 'ORIGINAL_PARTY_NUMBER'
5772: , p_value_1 => v_original_party_number

Line 5981: x_errbuf := xla_messages_pkg.get_message

5977:
5978: IF (v_processed_event_count = 0)
5979: THEN
5980: -- No events are processed
5981: x_errbuf := xla_messages_pkg.get_message
5982: ( p_appli_s_name => 'XLA'
5983: , p_msg_name => 'XLA_MERGE_ACCT_NO_EVENT'
5984: , p_token_1 => 'SUBLEDGER_APPLICATION_NAME'
5985: , p_value_1 => v_application_name);

Line 6052: x_errbuf := xla_messages_pkg.get_message

6048: trace( p_msg => v_message
6049: , p_level => C_LEVEL_ERROR
6050: , p_module => v_module);
6051: -- Set the out parameters
6052: x_errbuf := xla_messages_pkg.get_message
6053: ( p_appli_s_name => 'XLA'
6054: , p_msg_name => 'XLA_MERGE_FATAL_ERR'
6055: , p_token_1 => 'FUNCTION'
6056: , p_value_1 => v_function

Line 6079: x_errbuf := xla_messages_pkg.get_message

6075: trace( p_msg => v_message
6076: , p_level => C_LEVEL_UNEXPECTED
6077: , p_module => v_module);
6078: -- Set the out parameters
6079: x_errbuf := xla_messages_pkg.get_message
6080: ( p_appli_s_name => 'XLA'
6081: , p_msg_name => 'XLA_MERGE_FATAL_ERR'
6082: , p_token_1 => 'FUNCTION'
6083: , p_value_1 => v_function