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 139: , x_event_ids OUT NOCOPY xla_third_party_merge_pub.t_event_ids

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

Line 918: IF (x_retcode = xla_third_party_merge_pub.G_RET_STS_ERROR OR

914: , p_merge_event_set_id => v_merge_event_set_id
915: , p_srs_flag => 'N');
916:
917: -- If the return code is 'E' or 'U', raise AccountingError exception
918: IF (x_retcode = xla_third_party_merge_pub.G_RET_STS_ERROR OR
919: x_retcode = xla_third_party_merge_pub.G_RET_STS_UNEXP_ERROR)
920: THEN
921: RAISE AccountingError;
922: END IF; -- IF (x_retcode = xla_third_party_merge_pub.G_RET_STS_ERROR ...

Line 919: x_retcode = xla_third_party_merge_pub.G_RET_STS_UNEXP_ERROR)

915: , p_srs_flag => 'N');
916:
917: -- If the return code is 'E' or 'U', raise AccountingError exception
918: IF (x_retcode = xla_third_party_merge_pub.G_RET_STS_ERROR OR
919: x_retcode = xla_third_party_merge_pub.G_RET_STS_UNEXP_ERROR)
920: THEN
921: RAISE AccountingError;
922: END IF; -- IF (x_retcode = xla_third_party_merge_pub.G_RET_STS_ERROR ...
923:

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

918: IF (x_retcode = xla_third_party_merge_pub.G_RET_STS_ERROR OR
919: x_retcode = xla_third_party_merge_pub.G_RET_STS_UNEXP_ERROR)
920: THEN
921: RAISE AccountingError;
922: END IF; -- IF (x_retcode = xla_third_party_merge_pub.G_RET_STS_ERROR ...
923:
924: ELSIF (p_execution_mode = 'ASYNC_REQ')
925: THEN
926: -- If the execution mode is 'ASYNC_REQ', call API to submit the concurrent

Line 948: x_retcode := xla_third_party_merge_pub.G_RET_STS_SUCCESS;

944:
945: END IF; -- IF (v_access_count > 0)
946:
947: -- Set the return code to 'S'
948: x_retcode := xla_third_party_merge_pub.G_RET_STS_SUCCESS;
949:
950: -- Log the out parameters, their returned values and the function exit
951: IF (C_LEVEL_PROCEDURE >= g_log_level)
952: THEN

Line 982: x_retcode := xla_third_party_merge_pub.G_RET_STS_ERROR;

978: , p_token_1 => 'FUNCTION'
979: , p_value_1 => v_function
980: , p_token_2 => 'ERROR'
981: , p_value_2 => v_message);
982: x_retcode := xla_third_party_merge_pub.G_RET_STS_ERROR;
983: -- Log the out parameters, their returned values and the function exit
984: IF (C_LEVEL_PROCEDURE >= g_log_level)
985: THEN
986: trace( p_msg => 'x_retcode = ' || x_retcode

Line 1039: x_retcode := xla_third_party_merge_pub.G_RET_STS_UNEXP_ERROR;

1035: , p_token_1 => 'FUNCTION'
1036: , p_value_1 => v_function
1037: , p_token_2 => 'ERROR'
1038: , p_value_2 => v_message);
1039: x_retcode := xla_third_party_merge_pub.G_RET_STS_UNEXP_ERROR;
1040: -- Log the out parameters, their returned values and the function exit
1041: IF (C_LEVEL_PROCEDURE >= g_log_level)
1042: THEN
1043: trace( p_msg => 'x_retcode = ' || x_retcode

Line 6000: /*x_retcode := xla_third_party_merge_pub.G_RET_STS_ERROR;

5996: printed in the log file saying that there are no third party
5997: events to be processed */
5998:
5999:
6000: /*x_retcode := xla_third_party_merge_pub.G_RET_STS_ERROR;
6001: ELSE*/
6002:
6003: x_retcode := xla_third_party_merge_pub.G_RET_STS_SUCCESS;
6004:

Line 6003: x_retcode := xla_third_party_merge_pub.G_RET_STS_SUCCESS;

5999:
6000: /*x_retcode := xla_third_party_merge_pub.G_RET_STS_ERROR;
6001: ELSE*/
6002:
6003: x_retcode := xla_third_party_merge_pub.G_RET_STS_SUCCESS;
6004:
6005: trace( p_msg => 'RETURN SUCCESS'
6006: , p_level => C_LEVEL_ERROR
6007: , p_module => v_module);

Line 6018: IF (x_retcode = xla_third_party_merge_pub.G_RET_STS_SUCCESS)

6014: trace( p_msg => 'x_retcode = ' || x_retcode
6015: || ', x_errbuf = ' || x_errbuf
6016: , p_level => C_LEVEL_PROCEDURE
6017: , p_module => v_module);
6018: IF (x_retcode = xla_third_party_merge_pub.G_RET_STS_SUCCESS)
6019: THEN
6020: trace( p_msg => 'END - ' || v_function
6021: , p_level => C_LEVEL_PROCEDURE
6022: , p_module => v_module);

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

6024: --ELSE
6025: --trace( p_msg => 'EXIT with ERROR - ' || v_function
6026: --, p_level => C_LEVEL_PROCEDURE
6027: --, p_module => v_module);
6028: END IF; -- IF (x_retcode = xla_third_party_merge_pub.G_RET_STS_SUCCESS)
6029:
6030: END IF; -- IF (C_LEVEL_PROCEDURE >= g_log_level)
6031:
6032: EXCEPTION

Line 6045: x_retcode := xla_third_party_merge_pub.G_RET_STS_ERROR;

6041: , p_level => C_LEVEL_PROCEDURE
6042: , p_module => v_module);
6043: END IF; -- IF (C_LEVEL_PROCEDURE >= g_log_level)
6044: x_errbuf := 'No accounting date can be found';
6045: x_retcode := xla_third_party_merge_pub.G_RET_STS_ERROR;
6046: WHEN ValidationError THEN
6047: -- Log the error message
6048: trace( p_msg => v_message
6049: , p_level => C_LEVEL_ERROR

Line 6059: x_retcode := xla_third_party_merge_pub.G_RET_STS_ERROR;

6055: , p_token_1 => 'FUNCTION'
6056: , p_value_1 => v_function
6057: , p_token_2 => 'ERROR'
6058: , p_value_2 => v_message);
6059: x_retcode := xla_third_party_merge_pub.G_RET_STS_ERROR;
6060: -- Log the out parameters, their returned values and function exit
6061: IF (C_LEVEL_PROCEDURE >= g_log_level)
6062: THEN
6063: trace( p_msg => 'x_retcode = ' || x_retcode

Line 6090: x_retcode := xla_third_party_merge_pub.G_RET_STS_WARN;

6086: -- Set the return code to 'W' if any event is processed and it doesn't have
6087: -- merge event set; else, set it to 'U'
6088: IF (p_merge_event_set_id IS NULL AND v_processed_event_count > 0)
6089: THEN
6090: x_retcode := xla_third_party_merge_pub.G_RET_STS_WARN;
6091: ELSE
6092: x_retcode := xla_third_party_merge_pub.G_RET_STS_UNEXP_ERROR;
6093: END IF; -- IF (p_merge_event_set_id IS NULL AND v_processed_event_count > 0)
6094: -- Log the out parameters, their returned values and function exit

Line 6092: x_retcode := xla_third_party_merge_pub.G_RET_STS_UNEXP_ERROR;

6088: IF (p_merge_event_set_id IS NULL AND v_processed_event_count > 0)
6089: THEN
6090: x_retcode := xla_third_party_merge_pub.G_RET_STS_WARN;
6091: ELSE
6092: x_retcode := xla_third_party_merge_pub.G_RET_STS_UNEXP_ERROR;
6093: END IF; -- IF (p_merge_event_set_id IS NULL AND v_processed_event_count > 0)
6094: -- Log the out parameters, their returned values and function exit
6095: IF (C_LEVEL_PROCEDURE >= g_log_level)
6096: THEN

Line 6101: IF (x_retcode = xla_third_party_merge_pub.G_RET_STS_UNEXP_ERROR)

6097: trace( p_msg => 'x_retcode = ' || x_retcode
6098: || ', x_errbuf = ' || x_errbuf
6099: , p_level => C_LEVEL_PROCEDURE
6100: , p_module => v_module);
6101: IF (x_retcode = xla_third_party_merge_pub.G_RET_STS_UNEXP_ERROR)
6102: THEN
6103: trace( p_msg => 'EXIT with ERROR - ' || v_function
6104: , p_level => C_LEVEL_PROCEDURE
6105: , p_module => v_module);