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_THIRD_PARTY_MERGE_PUB

Line 18: | The public wrapper called xla_third_party_merge_pub, is built based on |

14: | DESCRIPTION |
15: | This is a XLA private package, which contains all the APIs required for |
16: | creating Third Party Merge events. |
17: | |
18: | The public wrapper called xla_third_party_merge_pub, is built based on |
19: | this package. |
20: | |
21: | Note: |
22: | - the APIs may perform ROLLBACK for what changes they have made |

Line 137: , x_event_ids OUT NOCOPY xla_third_party_merge_pub.t_event_ids

133: -- ----------------------------------------------------------------------------
134: PROCEDURE third_party_merge
135: ( x_errbuf OUT NOCOPY VARCHAR2
136: , x_retcode OUT NOCOPY VARCHAR2
137: , x_event_ids OUT NOCOPY xla_third_party_merge_pub.t_event_ids
138: , x_request_id OUT NOCOPY INTEGER
139: , p_source_application_id IN INTEGER DEFAULT NULL
140: , p_application_id IN INTEGER
141: , p_ledger_id IN INTEGER DEFAULT NULL

Line 908: IF (x_retcode = xla_third_party_merge_pub.G_RET_STS_ERROR OR

904: , p_merge_event_set_id => v_merge_event_set_id
905: , p_srs_flag => 'N');
906:
907: -- If the return code is 'E' or 'U', raise AccountingError exception
908: IF (x_retcode = xla_third_party_merge_pub.G_RET_STS_ERROR OR
909: x_retcode = xla_third_party_merge_pub.G_RET_STS_UNEXP_ERROR)
910: THEN
911: RAISE AccountingError;
912: END IF; -- IF (x_retcode = xla_third_party_merge_pub.G_RET_STS_ERROR ...

Line 909: x_retcode = xla_third_party_merge_pub.G_RET_STS_UNEXP_ERROR)

905: , p_srs_flag => 'N');
906:
907: -- If the return code is 'E' or 'U', raise AccountingError exception
908: IF (x_retcode = xla_third_party_merge_pub.G_RET_STS_ERROR OR
909: x_retcode = xla_third_party_merge_pub.G_RET_STS_UNEXP_ERROR)
910: THEN
911: RAISE AccountingError;
912: END IF; -- IF (x_retcode = xla_third_party_merge_pub.G_RET_STS_ERROR ...
913:

Line 912: END IF; -- IF (x_retcode = xla_third_party_merge_pub.G_RET_STS_ERROR ...

908: IF (x_retcode = xla_third_party_merge_pub.G_RET_STS_ERROR OR
909: x_retcode = xla_third_party_merge_pub.G_RET_STS_UNEXP_ERROR)
910: THEN
911: RAISE AccountingError;
912: END IF; -- IF (x_retcode = xla_third_party_merge_pub.G_RET_STS_ERROR ...
913:
914: ELSIF (p_execution_mode = 'ASYNC_REQ')
915: THEN
916: -- If the execution mode is 'ASYNC_REQ', call API to submit the concurrent

Line 938: x_retcode := xla_third_party_merge_pub.G_RET_STS_SUCCESS;

934:
935: END IF; -- IF (v_access_count > 0)
936:
937: -- Set the return code to 'S'
938: x_retcode := xla_third_party_merge_pub.G_RET_STS_SUCCESS;
939:
940: -- Log the out parameters, their returned values and the function exit
941: IF (C_LEVEL_PROCEDURE >= g_log_level)
942: THEN

Line 972: x_retcode := xla_third_party_merge_pub.G_RET_STS_ERROR;

968: , p_token_1 => 'FUNCTION'
969: , p_value_1 => v_function
970: , p_token_2 => 'ERROR'
971: , p_value_2 => v_message);
972: x_retcode := xla_third_party_merge_pub.G_RET_STS_ERROR;
973: -- Log the out parameters, their returned values and the function exit
974: IF (C_LEVEL_PROCEDURE >= g_log_level)
975: THEN
976: trace( p_msg => 'x_retcode = ' || x_retcode

Line 1029: x_retcode := xla_third_party_merge_pub.G_RET_STS_UNEXP_ERROR;

1025: , p_token_1 => 'FUNCTION'
1026: , p_value_1 => v_function
1027: , p_token_2 => 'ERROR'
1028: , p_value_2 => v_message);
1029: x_retcode := xla_third_party_merge_pub.G_RET_STS_UNEXP_ERROR;
1030: -- Log the out parameters, their returned values and the function exit
1031: IF (C_LEVEL_PROCEDURE >= g_log_level)
1032: THEN
1033: trace( p_msg => 'x_retcode = ' || x_retcode

Line 5765: x_retcode := xla_third_party_merge_pub.G_RET_STS_ERROR;

5761: trace( p_msg => v_message
5762: , p_level => C_LEVEL_ERROR
5763: , p_module => v_module);
5764: -- Set return code to 'E'
5765: x_retcode := xla_third_party_merge_pub.G_RET_STS_ERROR;
5766: ELSE
5767: x_retcode := xla_third_party_merge_pub.G_RET_STS_SUCCESS;
5768: trace( p_msg => 'RETURN SUCCESS'
5769: , p_level => C_LEVEL_ERROR

Line 5767: x_retcode := xla_third_party_merge_pub.G_RET_STS_SUCCESS;

5763: , p_module => v_module);
5764: -- Set return code to 'E'
5765: x_retcode := xla_third_party_merge_pub.G_RET_STS_ERROR;
5766: ELSE
5767: x_retcode := xla_third_party_merge_pub.G_RET_STS_SUCCESS;
5768: trace( p_msg => 'RETURN SUCCESS'
5769: , p_level => C_LEVEL_ERROR
5770: , p_module => v_module);
5771:

Line 5781: IF (x_retcode = xla_third_party_merge_pub.G_RET_STS_SUCCESS)

5777: trace( p_msg => 'x_retcode = ' || x_retcode
5778: || ', x_errbuf = ' || x_errbuf
5779: , p_level => C_LEVEL_PROCEDURE
5780: , p_module => v_module);
5781: IF (x_retcode = xla_third_party_merge_pub.G_RET_STS_SUCCESS)
5782: THEN
5783: trace( p_msg => 'END - ' || v_function
5784: , p_level => C_LEVEL_PROCEDURE
5785: , p_module => v_module);

Line 5790: END IF; -- IF (x_retcode = xla_third_party_merge_pub.G_RET_STS_SUCCESS)

5786: ELSE
5787: trace( p_msg => 'EXIT with ERROR - ' || v_function
5788: , p_level => C_LEVEL_PROCEDURE
5789: , p_module => v_module);
5790: END IF; -- IF (x_retcode = xla_third_party_merge_pub.G_RET_STS_SUCCESS)
5791:
5792: END IF; -- IF (C_LEVEL_PROCEDURE >= g_log_level)
5793:
5794: EXCEPTION

Line 5807: x_retcode := xla_third_party_merge_pub.G_RET_STS_ERROR;

5803: , p_level => C_LEVEL_PROCEDURE
5804: , p_module => v_module);
5805: END IF; -- IF (C_LEVEL_PROCEDURE >= g_log_level)
5806: x_errbuf := 'No accounting date can be found';
5807: x_retcode := xla_third_party_merge_pub.G_RET_STS_ERROR;
5808: WHEN ValidationError THEN
5809: -- Log the error message
5810: trace( p_msg => v_message
5811: , p_level => C_LEVEL_ERROR

Line 5821: x_retcode := xla_third_party_merge_pub.G_RET_STS_ERROR;

5817: , p_token_1 => 'FUNCTION'
5818: , p_value_1 => v_function
5819: , p_token_2 => 'ERROR'
5820: , p_value_2 => v_message);
5821: x_retcode := xla_third_party_merge_pub.G_RET_STS_ERROR;
5822: -- Log the out parameters, their returned values and function exit
5823: IF (C_LEVEL_PROCEDURE >= g_log_level)
5824: THEN
5825: trace( p_msg => 'x_retcode = ' || x_retcode

Line 5852: x_retcode := xla_third_party_merge_pub.G_RET_STS_WARN;

5848: -- Set the return code to 'W' if any event is processed and it doesn't have
5849: -- merge event set; else, set it to 'U'
5850: IF (p_merge_event_set_id IS NULL AND v_processed_event_count > 0)
5851: THEN
5852: x_retcode := xla_third_party_merge_pub.G_RET_STS_WARN;
5853: ELSE
5854: x_retcode := xla_third_party_merge_pub.G_RET_STS_UNEXP_ERROR;
5855: END IF; -- IF (p_merge_event_set_id IS NULL AND v_processed_event_count > 0)
5856: -- Log the out parameters, their returned values and function exit

Line 5854: x_retcode := xla_third_party_merge_pub.G_RET_STS_UNEXP_ERROR;

5850: IF (p_merge_event_set_id IS NULL AND v_processed_event_count > 0)
5851: THEN
5852: x_retcode := xla_third_party_merge_pub.G_RET_STS_WARN;
5853: ELSE
5854: x_retcode := xla_third_party_merge_pub.G_RET_STS_UNEXP_ERROR;
5855: END IF; -- IF (p_merge_event_set_id IS NULL AND v_processed_event_count > 0)
5856: -- Log the out parameters, their returned values and function exit
5857: IF (C_LEVEL_PROCEDURE >= g_log_level)
5858: THEN

Line 5863: IF (x_retcode = xla_third_party_merge_pub.G_RET_STS_UNEXP_ERROR)

5859: trace( p_msg => 'x_retcode = ' || x_retcode
5860: || ', x_errbuf = ' || x_errbuf
5861: , p_level => C_LEVEL_PROCEDURE
5862: , p_module => v_module);
5863: IF (x_retcode = xla_third_party_merge_pub.G_RET_STS_UNEXP_ERROR)
5864: THEN
5865: trace( p_msg => 'EXIT with ERROR - ' || v_function
5866: , p_level => C_LEVEL_PROCEDURE
5867: , p_module => v_module);