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.WMS_TASK_ACTION_PVT dependencies on WMS_TASK_ACTION_PVT

Line 1: PACKAGE BODY WMS_TASK_ACTION_PVT AS

1: PACKAGE BODY WMS_TASK_ACTION_PVT AS
2: /* $Header: WMSTACPB.pls 120.5.12000000.2 2007/07/19 01:33:59 mchemban ship $ */
3: l_is_unreleased BOOLEAN;
4: l_is_pending BOOLEAN;
5: l_is_queued BOOLEAN;

Line 122: p_module VARCHAR2 DEFAULT 'WMS_TASK_ACTION_PVT'

118: l_temp_action BOOLEAN;
119: PROCEDURE DEBUG
120: (
121: p_message VARCHAR2,
122: p_module VARCHAR2 DEFAULT 'WMS_TASK_ACTION_PVT'
123: )
124: IS
125: l_counter NUMBER := 1;
126: i NUMBER ;

Line 178: x_return_message:= 'Unexpected error has occured in WMS_TASK_ACTION_PVT.GET_TRANSACTION_TASK_IDS. '

174: EXCEPTION
175: WHEN OTHERS
176: THEN
177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
178: x_return_message:= 'Unexpected error has occured in WMS_TASK_ACTION_PVT.GET_TRANSACTION_TASK_IDS. '
179: || 'Oracle error message is ' || SQLERRM;
180: DEBUG( 'Unexpected error has occured. Oracle error message is '
181: || SQLERRM , 'WMS_TASK_ACTION_PVT.SUBMIT_REQUEST' );
182: END GET_TRANSACTION_TASK_IDS;

Line 181: || SQLERRM , 'WMS_TASK_ACTION_PVT.SUBMIT_REQUEST' );

177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
178: x_return_message:= 'Unexpected error has occured in WMS_TASK_ACTION_PVT.GET_TRANSACTION_TASK_IDS. '
179: || 'Oracle error message is ' || SQLERRM;
180: DEBUG( 'Unexpected error has occured. Oracle error message is '
181: || SQLERRM , 'WMS_TASK_ACTION_PVT.SUBMIT_REQUEST' );
182: END GET_TRANSACTION_TASK_IDS;
183:
184: PROCEDURE UPDATE_TASK
185: ( x_return_status OUT NOCOPY VARCHAR2,

Line 335: x_return_message:= 'Unexpected error has occured in WMS_TASK_ACTION_PVT.UPDATE_TASK. '

331: EXCEPTION
332: WHEN OTHERS
333: THEN
334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
335: x_return_message:= 'Unexpected error has occured in WMS_TASK_ACTION_PVT.UPDATE_TASK. '
336: || 'Oracle error message is ' || SQLERRM ;
337: DEBUG( 'Unexpected error has occured. Oracle error message is '
338: || SQLERRM , 'WMS_TASK_ACTION_PVT.SUBMIT_REQUEST' );
339: END UPDATE_TASK;

Line 338: || SQLERRM , 'WMS_TASK_ACTION_PVT.SUBMIT_REQUEST' );

334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
335: x_return_message:= 'Unexpected error has occured in WMS_TASK_ACTION_PVT.UPDATE_TASK. '
336: || 'Oracle error message is ' || SQLERRM ;
337: DEBUG( 'Unexpected error has occured. Oracle error message is '
338: || SQLERRM , 'WMS_TASK_ACTION_PVT.SUBMIT_REQUEST' );
339: END UPDATE_TASK;
340:
341:
342: PROCEDURE CANCEL_TASK

Line 451: x_return_message:= 'Unexpected error has occured in WMS_TASK_ACTION_PVT.CANCEL_TASK. '

447: EXCEPTION
448: WHEN OTHERS
449: THEN
450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
451: x_return_message:= 'Unexpected error has occured in WMS_TASK_ACTION_PVT.CANCEL_TASK. '
452: || 'Oracle error message is ' || SQLERRM ;
453: DEBUG( 'Unexpected error has occured. Oracle error message is '
454: || SQLERRM , 'WMS_TASK_ACTION_PVT.SUBMIT_REQUEST' );
455: END CANCEL_TASK;

Line 454: || SQLERRM , 'WMS_TASK_ACTION_PVT.SUBMIT_REQUEST' );

450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
451: x_return_message:= 'Unexpected error has occured in WMS_TASK_ACTION_PVT.CANCEL_TASK. '
452: || 'Oracle error message is ' || SQLERRM ;
453: DEBUG( 'Unexpected error has occured. Oracle error message is '
454: || SQLERRM , 'WMS_TASK_ACTION_PVT.SUBMIT_REQUEST' );
455: END CANCEL_TASK;
456:
457: PROCEDURE SET_QUERY_TASKS_PARAMETERS
458: (

Line 459: p_field_name_table IN wms_task_action_pvt.field_name_table_type,

455: END CANCEL_TASK;
456:
457: PROCEDURE SET_QUERY_TASKS_PARAMETERS
458: (
459: p_field_name_table IN wms_task_action_pvt.field_name_table_type,
460: p_field_value_table IN wms_task_action_pvt.field_value_table_type,
461: p_organization_id_table IN wms_task_action_pvt.organization_id_table_type,
462: p_query_type_table IN wms_task_action_pvt.query_type_table_type,
463: x_return_status OUT NOCOPY VARCHAR2,

Line 460: p_field_value_table IN wms_task_action_pvt.field_value_table_type,

456:
457: PROCEDURE SET_QUERY_TASKS_PARAMETERS
458: (
459: p_field_name_table IN wms_task_action_pvt.field_name_table_type,
460: p_field_value_table IN wms_task_action_pvt.field_value_table_type,
461: p_organization_id_table IN wms_task_action_pvt.organization_id_table_type,
462: p_query_type_table IN wms_task_action_pvt.query_type_table_type,
463: x_return_status OUT NOCOPY VARCHAR2,
464: x_return_message OUT NOCOPY VARCHAR2

Line 461: p_organization_id_table IN wms_task_action_pvt.organization_id_table_type,

457: PROCEDURE SET_QUERY_TASKS_PARAMETERS
458: (
459: p_field_name_table IN wms_task_action_pvt.field_name_table_type,
460: p_field_value_table IN wms_task_action_pvt.field_value_table_type,
461: p_organization_id_table IN wms_task_action_pvt.organization_id_table_type,
462: p_query_type_table IN wms_task_action_pvt.query_type_table_type,
463: x_return_status OUT NOCOPY VARCHAR2,
464: x_return_message OUT NOCOPY VARCHAR2
465: )

Line 462: p_query_type_table IN wms_task_action_pvt.query_type_table_type,

458: (
459: p_field_name_table IN wms_task_action_pvt.field_name_table_type,
460: p_field_value_table IN wms_task_action_pvt.field_value_table_type,
461: p_organization_id_table IN wms_task_action_pvt.organization_id_table_type,
462: p_query_type_table IN wms_task_action_pvt.query_type_table_type,
463: x_return_status OUT NOCOPY VARCHAR2,
464: x_return_message OUT NOCOPY VARCHAR2
465: )
466: IS

Line 864: x_return_message:= 'Unexpected error has occured in WMS_TASK_ACTION_PVT.SET_QUERY_TASKS_PARAMETERS. '

860: EXCEPTION
861: WHEN OTHERS
862: THEN
863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
864: x_return_message:= 'Unexpected error has occured in WMS_TASK_ACTION_PVT.SET_QUERY_TASKS_PARAMETERS. '
865: || 'Oracle error message is ' || SQLERRM;
866: DEBUG( 'Unexpected error has occured. Oracle error message is '
867: || SQLERRM, 'WMS_TASK_ACTION_PVT.SET_QUERY_TASKS_PARAMETERS - other error');
868:

Line 867: || SQLERRM, 'WMS_TASK_ACTION_PVT.SET_QUERY_TASKS_PARAMETERS - other error');

863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
864: x_return_message:= 'Unexpected error has occured in WMS_TASK_ACTION_PVT.SET_QUERY_TASKS_PARAMETERS. '
865: || 'Oracle error message is ' || SQLERRM;
866: DEBUG( 'Unexpected error has occured. Oracle error message is '
867: || SQLERRM, 'WMS_TASK_ACTION_PVT.SET_QUERY_TASKS_PARAMETERS - other error');
868:
869: END SET_QUERY_TASKS_PARAMETERS;
870:
871: PROCEDURE SET_ACTION_TASKS_PARAMETERS

Line 873: p_field_name_table IN wms_task_action_pvt.field_name_table_type,

869: END SET_QUERY_TASKS_PARAMETERS;
870:
871: PROCEDURE SET_ACTION_TASKS_PARAMETERS
872: (
873: p_field_name_table IN wms_task_action_pvt.field_name_table_type,
874: p_field_value_table IN wms_task_action_pvt.field_value_table_type,
875: p_query_type_table IN wms_task_action_pvt.query_type_table_type,
876: x_return_status OUT NOCOPY VARCHAR2,
877: x_return_message OUT NOCOPY VARCHAR2

Line 874: p_field_value_table IN wms_task_action_pvt.field_value_table_type,

870:
871: PROCEDURE SET_ACTION_TASKS_PARAMETERS
872: (
873: p_field_name_table IN wms_task_action_pvt.field_name_table_type,
874: p_field_value_table IN wms_task_action_pvt.field_value_table_type,
875: p_query_type_table IN wms_task_action_pvt.query_type_table_type,
876: x_return_status OUT NOCOPY VARCHAR2,
877: x_return_message OUT NOCOPY VARCHAR2
878: )

Line 875: p_query_type_table IN wms_task_action_pvt.query_type_table_type,

871: PROCEDURE SET_ACTION_TASKS_PARAMETERS
872: (
873: p_field_name_table IN wms_task_action_pvt.field_name_table_type,
874: p_field_value_table IN wms_task_action_pvt.field_value_table_type,
875: p_query_type_table IN wms_task_action_pvt.query_type_table_type,
876: x_return_status OUT NOCOPY VARCHAR2,
877: x_return_message OUT NOCOPY VARCHAR2
878: )
879: IS

Line 959: x_return_message:= 'Unexpected error has occured in WMS_TASK_ACTION_PVT.SET_ACTION_TASKS_PARAMETERS. '

955: EXCEPTION
956: WHEN OTHERS
957: THEN
958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
959: x_return_message:= 'Unexpected error has occured in WMS_TASK_ACTION_PVT.SET_ACTION_TASKS_PARAMETERS. '
960: || 'Oracle error message is ' || SQLERRM;
961: DEBUG( 'Unexpected error has occured. Oracle error message is '
962: ||SQLERRM, 'WMS_TASK_ACTION_PVT.SET_ACTION_TASKS_PARAMETERS - other error');
963: END SET_ACTION_TASKS_PARAMETERS;

Line 962: ||SQLERRM, 'WMS_TASK_ACTION_PVT.SET_ACTION_TASKS_PARAMETERS - other error');

958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
959: x_return_message:= 'Unexpected error has occured in WMS_TASK_ACTION_PVT.SET_ACTION_TASKS_PARAMETERS. '
960: || 'Oracle error message is ' || SQLERRM;
961: DEBUG( 'Unexpected error has occured. Oracle error message is '
962: ||SQLERRM, 'WMS_TASK_ACTION_PVT.SET_ACTION_TASKS_PARAMETERS - other error');
963: END SET_ACTION_TASKS_PARAMETERS;
964:
965: PROCEDURE DELETE_TEMP_QUERY
966: ( p_query_name IN VARCHAR2,

Line 987: || 'WMS_TASK_ACTION_PVT.DELETE_TEMP_QUERY. '

983: THEN
984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
985: x_return_message
986: := 'Unexpected error has occured in '
987: || 'WMS_TASK_ACTION_PVT.DELETE_TEMP_QUERY. '
988: || 'Oracle error message is ' || SQLERRM;
989: DEBUG
990: ( 'Unexpected error has occured in '
991: || 'WMS_TASK_ACTION_PVT.DELETE_TEMP_QUERY. '

Line 991: || 'WMS_TASK_ACTION_PVT.DELETE_TEMP_QUERY. '

987: || 'WMS_TASK_ACTION_PVT.DELETE_TEMP_QUERY. '
988: || 'Oracle error message is ' || SQLERRM;
989: DEBUG
990: ( 'Unexpected error has occured in '
991: || 'WMS_TASK_ACTION_PVT.DELETE_TEMP_QUERY. '
992: || 'Oracle error message is ' || SQLERRM
993: , 'WMS_TASK_ACTION_PVT.DELETE_TEMP_QUERY - other error'
994: );
995: END;

Line 993: , 'WMS_TASK_ACTION_PVT.DELETE_TEMP_QUERY - other error'

989: DEBUG
990: ( 'Unexpected error has occured in '
991: || 'WMS_TASK_ACTION_PVT.DELETE_TEMP_QUERY. '
992: || 'Oracle error message is ' || SQLERRM
993: , 'WMS_TASK_ACTION_PVT.DELETE_TEMP_QUERY - other error'
994: );
995: END;
996:
997: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1004: x_return_message:= 'Unexpected error has occured in WMS_TASK_ACTION_PVT.DELETE_TEMP_QUERY '

1000: EXCEPTION
1001: WHEN OTHERS
1002: THEN
1003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1004: x_return_message:= 'Unexpected error has occured in WMS_TASK_ACTION_PVT.DELETE_TEMP_QUERY '
1005: || 'Oracle error message is ' || SQLERRM;
1006: DEBUG( 'Unexpected error has occured. Oracle error message is '
1007: ||SQLERRM, 'WMS_TASK_ACTION_PVT.DELETE_TEMP_QUERY - other error');
1008: END DELETE_TEMP_QUERY;

Line 1007: ||SQLERRM, 'WMS_TASK_ACTION_PVT.DELETE_TEMP_QUERY - other error');

1003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1004: x_return_message:= 'Unexpected error has occured in WMS_TASK_ACTION_PVT.DELETE_TEMP_QUERY '
1005: || 'Oracle error message is ' || SQLERRM;
1006: DEBUG( 'Unexpected error has occured. Oracle error message is '
1007: ||SQLERRM, 'WMS_TASK_ACTION_PVT.DELETE_TEMP_QUERY - other error');
1008: END DELETE_TEMP_QUERY;
1009:
1010: PROCEDURE DELETE_TEMP_ACTION
1011: ( p_action_name IN VARCHAR2,

Line 1033: || 'WMS_TASK_ACTION_PVT.DELETE_TEMP_ACTION. '

1029: THEN
1030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1031: x_return_message
1032: := 'Unexpected error has occured in '
1033: || 'WMS_TASK_ACTION_PVT.DELETE_TEMP_ACTION. '
1034: || 'Oracle error message is ' || SQLERRM;
1035: DEBUG
1036: ( 'Unexpected error has occured in '
1037: || 'WMS_TASK_ACTION_PVT.DELETE_TEMP_ACTION. '

Line 1037: || 'WMS_TASK_ACTION_PVT.DELETE_TEMP_ACTION. '

1033: || 'WMS_TASK_ACTION_PVT.DELETE_TEMP_ACTION. '
1034: || 'Oracle error message is ' || SQLERRM;
1035: DEBUG
1036: ( 'Unexpected error has occured in '
1037: || 'WMS_TASK_ACTION_PVT.DELETE_TEMP_ACTION. '
1038: , 'WMS_TASK_ACTION_PVT.DELETE_TEMP_ACTION - other error'
1039: );
1040: END;
1041:

Line 1038: , 'WMS_TASK_ACTION_PVT.DELETE_TEMP_ACTION - other error'

1034: || 'Oracle error message is ' || SQLERRM;
1035: DEBUG
1036: ( 'Unexpected error has occured in '
1037: || 'WMS_TASK_ACTION_PVT.DELETE_TEMP_ACTION. '
1038: , 'WMS_TASK_ACTION_PVT.DELETE_TEMP_ACTION - other error'
1039: );
1040: END;
1041:
1042: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1049: x_return_message:= 'Unexpected error has occured in WMS_TASK_ACTION_PVT.DELETE_TEMP_ACTION '

1045: EXCEPTION
1046: WHEN OTHERS
1047: THEN
1048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1049: x_return_message:= 'Unexpected error has occured in WMS_TASK_ACTION_PVT.DELETE_TEMP_ACTION '
1050: || 'Oracle error message is ' || SQLERRM;
1051: DEBUG( 'Unexpected error has occured. Oracle error message is '
1052: ||SQLERRM, 'WMS_TASK_ACTION_PVT.DELETE_TEMP_ACTION - other error');
1053: END DELETE_TEMP_ACTION;

Line 1052: ||SQLERRM, 'WMS_TASK_ACTION_PVT.DELETE_TEMP_ACTION - other error');

1048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1049: x_return_message:= 'Unexpected error has occured in WMS_TASK_ACTION_PVT.DELETE_TEMP_ACTION '
1050: || 'Oracle error message is ' || SQLERRM;
1051: DEBUG( 'Unexpected error has occured. Oracle error message is '
1052: ||SQLERRM, 'WMS_TASK_ACTION_PVT.DELETE_TEMP_ACTION - other error');
1053: END DELETE_TEMP_ACTION;
1054:
1055: PROCEDURE TASK_ACTION_CONC_PROG
1056: (

Line 1295: errbuf := 'Unexpected error has occured in WMS_TASK_ACTION_PVT.TASK_ACTION_CONC_PROG. '

1291: EXCEPTION
1292: WHEN OTHERS
1293: THEN
1294: retcode := '2';
1295: errbuf := 'Unexpected error has occured in WMS_TASK_ACTION_PVT.TASK_ACTION_CONC_PROG. '
1296: || 'Oracle error message is ' || SQLERRM;
1297: ret := fnd_concurrent.set_completion_status('ERROR', errbuf);
1298: DEBUG( 'Unexpected error has occured. Oracle error message is '
1299: ||SQLERRM, 'WMS_TASK_ACTION_PVT.TASK_ACTION_CONC_PROG - other error');

Line 1299: ||SQLERRM, 'WMS_TASK_ACTION_PVT.TASK_ACTION_CONC_PROG - other error');

1295: errbuf := 'Unexpected error has occured in WMS_TASK_ACTION_PVT.TASK_ACTION_CONC_PROG. '
1296: || 'Oracle error message is ' || SQLERRM;
1297: ret := fnd_concurrent.set_completion_status('ERROR', errbuf);
1298: DEBUG( 'Unexpected error has occured. Oracle error message is '
1299: ||SQLERRM, 'WMS_TASK_ACTION_PVT.TASK_ACTION_CONC_PROG - other error');
1300: END TASK_ACTION_CONC_PROG;
1301:
1302: PROCEDURE TASK_ACTION
1303: (

Line 1341: l_field_name_table wms_task_action_pvt.field_name_table_type;

1337:
1338: rec_saved_queries c_saved_queries%rowtype;
1339: rec_saved_actions c_saved_actions%rowtype;
1340:
1341: l_field_name_table wms_task_action_pvt.field_name_table_type;
1342: l_field_value_table wms_task_action_pvt.field_value_table_type;
1343: l_organization_id_table wms_task_action_pvt.organization_id_table_type;
1344: l_query_type_table wms_task_action_pvt.query_type_table_type;
1345:

Line 1342: l_field_value_table wms_task_action_pvt.field_value_table_type;

1338: rec_saved_queries c_saved_queries%rowtype;
1339: rec_saved_actions c_saved_actions%rowtype;
1340:
1341: l_field_name_table wms_task_action_pvt.field_name_table_type;
1342: l_field_value_table wms_task_action_pvt.field_value_table_type;
1343: l_organization_id_table wms_task_action_pvt.organization_id_table_type;
1344: l_query_type_table wms_task_action_pvt.query_type_table_type;
1345:
1346: l_return_status VARCHAR2( 1 );

Line 1343: l_organization_id_table wms_task_action_pvt.organization_id_table_type;

1339: rec_saved_actions c_saved_actions%rowtype;
1340:
1341: l_field_name_table wms_task_action_pvt.field_name_table_type;
1342: l_field_value_table wms_task_action_pvt.field_value_table_type;
1343: l_organization_id_table wms_task_action_pvt.organization_id_table_type;
1344: l_query_type_table wms_task_action_pvt.query_type_table_type;
1345:
1346: l_return_status VARCHAR2( 1 );
1347: l_msg_data VARCHAR2( 120 );

Line 1344: l_query_type_table wms_task_action_pvt.query_type_table_type;

1340:
1341: l_field_name_table wms_task_action_pvt.field_name_table_type;
1342: l_field_value_table wms_task_action_pvt.field_value_table_type;
1343: l_organization_id_table wms_task_action_pvt.organization_id_table_type;
1344: l_query_type_table wms_task_action_pvt.query_type_table_type;
1345:
1346: l_return_status VARCHAR2( 1 );
1347: l_msg_data VARCHAR2( 120 );
1348: l_msg_count NUMBER;

Line 2019: || SQLERRM , 'WMS_TASK_ACTION_PVT.TASK_ACTION' );

2015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2016: x_return_message:= 'Unexpected error has occured in TASK_ACTION. '
2017: || 'Oracle error message is ' || SQLERRM;
2018: DEBUG( 'Unexpected error has occured. Oracle error message is '
2019: || SQLERRM , 'WMS_TASK_ACTION_PVT.TASK_ACTION' );
2020: END TASK_ACTION;
2021:
2022: PROCEDURE SUBMIT_REQUEST
2023: (

Line 2057: DEBUG('Request submission failed', 'WMS_TASK_ACTION_PVT.SUBMIT_REQUEST');

2053:
2054: -- If request submission failed, exit with error.
2055: IF l_request_id <= 0
2056: THEN
2057: DEBUG('Request submission failed', 'WMS_TASK_ACTION_PVT.SUBMIT_REQUEST');
2058: l_return := FND_API.G_RET_STS_ERROR;
2059: RETURN;
2060: ELSE
2061: DEBUG( 'Request '||l_request_id||' submitted successfully');

Line 2075: x_return_message:= 'Unexpected error has occured in WMS_TASK_ACTION_PVT.SUBMIT_REQUEST. '

2071: EXCEPTION
2072: WHEN OTHERS
2073: THEN
2074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2075: x_return_message:= 'Unexpected error has occured in WMS_TASK_ACTION_PVT.SUBMIT_REQUEST. '
2076: || 'Oracle error message is ' || SQLERRM;
2077:
2078: DEBUG( 'Unexpected error has occured. Oracle error message is '
2079: || SQLERRM , 'WMS_TASK_ACTION_PVT.SUBMIT_REQUEST' );

Line 2079: || SQLERRM , 'WMS_TASK_ACTION_PVT.SUBMIT_REQUEST' );

2075: x_return_message:= 'Unexpected error has occured in WMS_TASK_ACTION_PVT.SUBMIT_REQUEST. '
2076: || 'Oracle error message is ' || SQLERRM;
2077:
2078: DEBUG( 'Unexpected error has occured. Oracle error message is '
2079: || SQLERRM , 'WMS_TASK_ACTION_PVT.SUBMIT_REQUEST' );
2080: DEBUG( 'Unexpected error has occured. Oracle error message is '
2081: || SQLERRM , 'WMS_TASK_ACTION_PVT.SUBMIT_REQUEST' );
2082: END SUBMIT_REQUEST;
2083:

Line 2081: || SQLERRM , 'WMS_TASK_ACTION_PVT.SUBMIT_REQUEST' );

2077:
2078: DEBUG( 'Unexpected error has occured. Oracle error message is '
2079: || SQLERRM , 'WMS_TASK_ACTION_PVT.SUBMIT_REQUEST' );
2080: DEBUG( 'Unexpected error has occured. Oracle error message is '
2081: || SQLERRM , 'WMS_TASK_ACTION_PVT.SUBMIT_REQUEST' );
2082: END SUBMIT_REQUEST;
2083:
2084: END WMS_TASK_ACTION_PVT;

Line 2084: END WMS_TASK_ACTION_PVT;

2080: DEBUG( 'Unexpected error has occured. Oracle error message is '
2081: || SQLERRM , 'WMS_TASK_ACTION_PVT.SUBMIT_REQUEST' );
2082: END SUBMIT_REQUEST;
2083:
2084: END WMS_TASK_ACTION_PVT;