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.10.12020000.3 2012/11/08 08:41:07 gjyoti ship $ */
3: l_is_unreleased BOOLEAN;
4: l_is_pending BOOLEAN;
5: l_is_queued BOOLEAN;

Line 126: p_module VARCHAR2 DEFAULT 'WMS_TASK_ACTION_PVT'

122: l_wave_header_id NUMBER;
123: PROCEDURE DEBUG
124: (
125: p_message VARCHAR2,
126: p_module VARCHAR2 DEFAULT 'WMS_TASK_ACTION_PVT'
127: )
128: IS
129: l_counter NUMBER := 1;
130: i NUMBER ;

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

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

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

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

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

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

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

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

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

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

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

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

Line 463: p_field_name_table IN wms_task_action_pvt.field_name_table_type,

459: END CANCEL_TASK;
460:
461: PROCEDURE SET_QUERY_TASKS_PARAMETERS
462: (
463: p_field_name_table IN wms_task_action_pvt.field_name_table_type,
464: p_field_value_table IN wms_task_action_pvt.field_value_table_type,
465: p_organization_id_table IN wms_task_action_pvt.organization_id_table_type,
466: p_query_type_table IN wms_task_action_pvt.query_type_table_type,
467: x_return_status OUT NOCOPY VARCHAR2,

Line 464: p_field_value_table IN wms_task_action_pvt.field_value_table_type,

460:
461: PROCEDURE SET_QUERY_TASKS_PARAMETERS
462: (
463: p_field_name_table IN wms_task_action_pvt.field_name_table_type,
464: p_field_value_table IN wms_task_action_pvt.field_value_table_type,
465: p_organization_id_table IN wms_task_action_pvt.organization_id_table_type,
466: p_query_type_table IN wms_task_action_pvt.query_type_table_type,
467: x_return_status OUT NOCOPY VARCHAR2,
468: x_return_message OUT NOCOPY VARCHAR2

Line 465: p_organization_id_table IN wms_task_action_pvt.organization_id_table_type,

461: PROCEDURE SET_QUERY_TASKS_PARAMETERS
462: (
463: p_field_name_table IN wms_task_action_pvt.field_name_table_type,
464: p_field_value_table IN wms_task_action_pvt.field_value_table_type,
465: p_organization_id_table IN wms_task_action_pvt.organization_id_table_type,
466: p_query_type_table IN wms_task_action_pvt.query_type_table_type,
467: x_return_status OUT NOCOPY VARCHAR2,
468: x_return_message OUT NOCOPY VARCHAR2
469: )

Line 466: p_query_type_table IN wms_task_action_pvt.query_type_table_type,

462: (
463: p_field_name_table IN wms_task_action_pvt.field_name_table_type,
464: p_field_value_table IN wms_task_action_pvt.field_value_table_type,
465: p_organization_id_table IN wms_task_action_pvt.organization_id_table_type,
466: p_query_type_table IN wms_task_action_pvt.query_type_table_type,
467: x_return_status OUT NOCOPY VARCHAR2,
468: x_return_message OUT NOCOPY VARCHAR2
469: )
470: IS

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

877: EXCEPTION
878: WHEN OTHERS
879: THEN
880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
881: x_return_message:= 'Unexpected error has occured in WMS_TASK_ACTION_PVT.SET_QUERY_TASKS_PARAMETERS. '
882: || 'Oracle error message is ' || SQLERRM;
883: DEBUG( 'Unexpected error has occured. Oracle error message is '
884: || SQLERRM, 'WMS_TASK_ACTION_PVT.SET_QUERY_TASKS_PARAMETERS - other error');
885:

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

880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
881: x_return_message:= 'Unexpected error has occured in WMS_TASK_ACTION_PVT.SET_QUERY_TASKS_PARAMETERS. '
882: || 'Oracle error message is ' || SQLERRM;
883: DEBUG( 'Unexpected error has occured. Oracle error message is '
884: || SQLERRM, 'WMS_TASK_ACTION_PVT.SET_QUERY_TASKS_PARAMETERS - other error');
885:
886: END SET_QUERY_TASKS_PARAMETERS;
887:
888: PROCEDURE SET_ACTION_TASKS_PARAMETERS

Line 890: p_field_name_table IN wms_task_action_pvt.field_name_table_type,

886: END SET_QUERY_TASKS_PARAMETERS;
887:
888: PROCEDURE SET_ACTION_TASKS_PARAMETERS
889: (
890: p_field_name_table IN wms_task_action_pvt.field_name_table_type,
891: p_field_value_table IN wms_task_action_pvt.field_value_table_type,
892: p_query_type_table IN wms_task_action_pvt.query_type_table_type,
893: x_return_status OUT NOCOPY VARCHAR2,
894: x_return_message OUT NOCOPY VARCHAR2

Line 891: p_field_value_table IN wms_task_action_pvt.field_value_table_type,

887:
888: PROCEDURE SET_ACTION_TASKS_PARAMETERS
889: (
890: p_field_name_table IN wms_task_action_pvt.field_name_table_type,
891: p_field_value_table IN wms_task_action_pvt.field_value_table_type,
892: p_query_type_table IN wms_task_action_pvt.query_type_table_type,
893: x_return_status OUT NOCOPY VARCHAR2,
894: x_return_message OUT NOCOPY VARCHAR2
895: )

Line 892: p_query_type_table IN wms_task_action_pvt.query_type_table_type,

888: PROCEDURE SET_ACTION_TASKS_PARAMETERS
889: (
890: p_field_name_table IN wms_task_action_pvt.field_name_table_type,
891: p_field_value_table IN wms_task_action_pvt.field_value_table_type,
892: p_query_type_table IN wms_task_action_pvt.query_type_table_type,
893: x_return_status OUT NOCOPY VARCHAR2,
894: x_return_message OUT NOCOPY VARCHAR2
895: )
896: IS

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

980: EXCEPTION
981: WHEN OTHERS
982: THEN
983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
984: x_return_message:= 'Unexpected error has occured in WMS_TASK_ACTION_PVT.SET_ACTION_TASKS_PARAMETERS. '
985: || 'Oracle error message is ' || SQLERRM;
986: DEBUG( 'Unexpected error has occured. Oracle error message is '
987: ||SQLERRM, 'WMS_TASK_ACTION_PVT.SET_ACTION_TASKS_PARAMETERS - other error');
988: END SET_ACTION_TASKS_PARAMETERS;

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

983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
984: x_return_message:= 'Unexpected error has occured in WMS_TASK_ACTION_PVT.SET_ACTION_TASKS_PARAMETERS. '
985: || 'Oracle error message is ' || SQLERRM;
986: DEBUG( 'Unexpected error has occured. Oracle error message is '
987: ||SQLERRM, 'WMS_TASK_ACTION_PVT.SET_ACTION_TASKS_PARAMETERS - other error');
988: END SET_ACTION_TASKS_PARAMETERS;
989:
990: PROCEDURE DELETE_TEMP_QUERY
991: ( p_query_name IN VARCHAR2,

Line 1012: || 'WMS_TASK_ACTION_PVT.DELETE_TEMP_QUERY. '

1008: THEN
1009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1010: x_return_message
1011: := 'Unexpected error has occured in '
1012: || 'WMS_TASK_ACTION_PVT.DELETE_TEMP_QUERY. '
1013: || 'Oracle error message is ' || SQLERRM;
1014: DEBUG
1015: ( 'Unexpected error has occured in '
1016: || 'WMS_TASK_ACTION_PVT.DELETE_TEMP_QUERY. '

Line 1016: || 'WMS_TASK_ACTION_PVT.DELETE_TEMP_QUERY. '

1012: || 'WMS_TASK_ACTION_PVT.DELETE_TEMP_QUERY. '
1013: || 'Oracle error message is ' || SQLERRM;
1014: DEBUG
1015: ( 'Unexpected error has occured in '
1016: || 'WMS_TASK_ACTION_PVT.DELETE_TEMP_QUERY. '
1017: || 'Oracle error message is ' || SQLERRM
1018: , 'WMS_TASK_ACTION_PVT.DELETE_TEMP_QUERY - other error'
1019: );
1020: END;

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

1014: DEBUG
1015: ( 'Unexpected error has occured in '
1016: || 'WMS_TASK_ACTION_PVT.DELETE_TEMP_QUERY. '
1017: || 'Oracle error message is ' || SQLERRM
1018: , 'WMS_TASK_ACTION_PVT.DELETE_TEMP_QUERY - other error'
1019: );
1020: END;
1021:
1022: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1025: EXCEPTION
1026: WHEN OTHERS
1027: THEN
1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1029: x_return_message:= 'Unexpected error has occured in WMS_TASK_ACTION_PVT.DELETE_TEMP_QUERY '
1030: || 'Oracle error message is ' || SQLERRM;
1031: DEBUG( 'Unexpected error has occured. Oracle error message is '
1032: ||SQLERRM, 'WMS_TASK_ACTION_PVT.DELETE_TEMP_QUERY - other error');
1033: END DELETE_TEMP_QUERY;

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

1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1029: x_return_message:= 'Unexpected error has occured in WMS_TASK_ACTION_PVT.DELETE_TEMP_QUERY '
1030: || 'Oracle error message is ' || SQLERRM;
1031: DEBUG( 'Unexpected error has occured. Oracle error message is '
1032: ||SQLERRM, 'WMS_TASK_ACTION_PVT.DELETE_TEMP_QUERY - other error');
1033: END DELETE_TEMP_QUERY;
1034:
1035: PROCEDURE DELETE_TEMP_ACTION
1036: ( p_action_name IN VARCHAR2,

Line 1058: || 'WMS_TASK_ACTION_PVT.DELETE_TEMP_ACTION. '

1054: THEN
1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1056: x_return_message
1057: := 'Unexpected error has occured in '
1058: || 'WMS_TASK_ACTION_PVT.DELETE_TEMP_ACTION. '
1059: || 'Oracle error message is ' || SQLERRM;
1060: DEBUG
1061: ( 'Unexpected error has occured in '
1062: || 'WMS_TASK_ACTION_PVT.DELETE_TEMP_ACTION. '

Line 1062: || 'WMS_TASK_ACTION_PVT.DELETE_TEMP_ACTION. '

1058: || 'WMS_TASK_ACTION_PVT.DELETE_TEMP_ACTION. '
1059: || 'Oracle error message is ' || SQLERRM;
1060: DEBUG
1061: ( 'Unexpected error has occured in '
1062: || 'WMS_TASK_ACTION_PVT.DELETE_TEMP_ACTION. '
1063: , 'WMS_TASK_ACTION_PVT.DELETE_TEMP_ACTION - other error'
1064: );
1065: END;
1066:

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

1059: || 'Oracle error message is ' || SQLERRM;
1060: DEBUG
1061: ( 'Unexpected error has occured in '
1062: || 'WMS_TASK_ACTION_PVT.DELETE_TEMP_ACTION. '
1063: , 'WMS_TASK_ACTION_PVT.DELETE_TEMP_ACTION - other error'
1064: );
1065: END;
1066:
1067: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1070: EXCEPTION
1071: WHEN OTHERS
1072: THEN
1073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1074: x_return_message:= 'Unexpected error has occured in WMS_TASK_ACTION_PVT.DELETE_TEMP_ACTION '
1075: || 'Oracle error message is ' || SQLERRM;
1076: DEBUG( 'Unexpected error has occured. Oracle error message is '
1077: ||SQLERRM, 'WMS_TASK_ACTION_PVT.DELETE_TEMP_ACTION - other error');
1078: END DELETE_TEMP_ACTION;

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

1073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1074: x_return_message:= 'Unexpected error has occured in WMS_TASK_ACTION_PVT.DELETE_TEMP_ACTION '
1075: || 'Oracle error message is ' || SQLERRM;
1076: DEBUG( 'Unexpected error has occured. Oracle error message is '
1077: ||SQLERRM, 'WMS_TASK_ACTION_PVT.DELETE_TEMP_ACTION - other error');
1078: END DELETE_TEMP_ACTION;
1079:
1080: PROCEDURE TASK_ACTION_CONC_PROG
1081: (

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

1316: EXCEPTION
1317: WHEN OTHERS
1318: THEN
1319: retcode := '2';
1320: errbuf := 'Unexpected error has occured in WMS_TASK_ACTION_PVT.TASK_ACTION_CONC_PROG. '
1321: || 'Oracle error message is ' || SQLERRM;
1322: ret := fnd_concurrent.set_completion_status('ERROR', errbuf);
1323: DEBUG( 'Unexpected error has occured. Oracle error message is '
1324: ||SQLERRM, 'WMS_TASK_ACTION_PVT.TASK_ACTION_CONC_PROG - other error');

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

1320: errbuf := 'Unexpected error has occured in WMS_TASK_ACTION_PVT.TASK_ACTION_CONC_PROG. '
1321: || 'Oracle error message is ' || SQLERRM;
1322: ret := fnd_concurrent.set_completion_status('ERROR', errbuf);
1323: DEBUG( 'Unexpected error has occured. Oracle error message is '
1324: ||SQLERRM, 'WMS_TASK_ACTION_PVT.TASK_ACTION_CONC_PROG - other error');
1325: END TASK_ACTION_CONC_PROG;
1326:
1327: PROCEDURE TASK_ACTION
1328: (

Line 1366: l_field_name_table wms_task_action_pvt.field_name_table_type;

1362:
1363: rec_saved_queries c_saved_queries%rowtype;
1364: rec_saved_actions c_saved_actions%rowtype;
1365:
1366: l_field_name_table wms_task_action_pvt.field_name_table_type;
1367: l_field_value_table wms_task_action_pvt.field_value_table_type;
1368: l_organization_id_table wms_task_action_pvt.organization_id_table_type;
1369: l_query_type_table wms_task_action_pvt.query_type_table_type;
1370:

Line 1367: l_field_value_table wms_task_action_pvt.field_value_table_type;

1363: rec_saved_queries c_saved_queries%rowtype;
1364: rec_saved_actions c_saved_actions%rowtype;
1365:
1366: l_field_name_table wms_task_action_pvt.field_name_table_type;
1367: l_field_value_table wms_task_action_pvt.field_value_table_type;
1368: l_organization_id_table wms_task_action_pvt.organization_id_table_type;
1369: l_query_type_table wms_task_action_pvt.query_type_table_type;
1370:
1371: l_return_status VARCHAR2( 1 );

Line 1368: l_organization_id_table wms_task_action_pvt.organization_id_table_type;

1364: rec_saved_actions c_saved_actions%rowtype;
1365:
1366: l_field_name_table wms_task_action_pvt.field_name_table_type;
1367: l_field_value_table wms_task_action_pvt.field_value_table_type;
1368: l_organization_id_table wms_task_action_pvt.organization_id_table_type;
1369: l_query_type_table wms_task_action_pvt.query_type_table_type;
1370:
1371: l_return_status VARCHAR2( 1 );
1372: l_msg_data VARCHAR2( 120 );

Line 1369: l_query_type_table wms_task_action_pvt.query_type_table_type;

1365:
1366: l_field_name_table wms_task_action_pvt.field_name_table_type;
1367: l_field_value_table wms_task_action_pvt.field_value_table_type;
1368: l_organization_id_table wms_task_action_pvt.organization_id_table_type;
1369: l_query_type_table wms_task_action_pvt.query_type_table_type;
1370:
1371: l_return_status VARCHAR2( 1 );
1372: l_msg_data VARCHAR2( 120 );
1373: l_msg_count NUMBER;

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

2046: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2047: x_return_message:= 'Unexpected error has occured in TASK_ACTION. '
2048: || 'Oracle error message is ' || SQLERRM;
2049: DEBUG( 'Unexpected error has occured. Oracle error message is '
2050: || SQLERRM , 'WMS_TASK_ACTION_PVT.TASK_ACTION' );
2051: END TASK_ACTION;
2052:
2053: PROCEDURE SUBMIT_REQUEST
2054: (

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

2084:
2085: -- If request submission failed, exit with error.
2086: IF l_request_id <= 0
2087: THEN
2088: DEBUG('Request submission failed', 'WMS_TASK_ACTION_PVT.SUBMIT_REQUEST');
2089: l_return := FND_API.G_RET_STS_ERROR;
2090: RETURN;
2091: ELSE
2092: DEBUG( 'Request '||l_request_id||' submitted successfully');

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

2102: EXCEPTION
2103: WHEN OTHERS
2104: THEN
2105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2106: x_return_message:= 'Unexpected error has occured in WMS_TASK_ACTION_PVT.SUBMIT_REQUEST. '
2107: || 'Oracle error message is ' || SQLERRM;
2108:
2109: DEBUG( 'Unexpected error has occured. Oracle error message is '
2110: || SQLERRM , 'WMS_TASK_ACTION_PVT.SUBMIT_REQUEST' );

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

2106: x_return_message:= 'Unexpected error has occured in WMS_TASK_ACTION_PVT.SUBMIT_REQUEST. '
2107: || 'Oracle error message is ' || SQLERRM;
2108:
2109: DEBUG( 'Unexpected error has occured. Oracle error message is '
2110: || SQLERRM , 'WMS_TASK_ACTION_PVT.SUBMIT_REQUEST' );
2111: DEBUG( 'Unexpected error has occured. Oracle error message is '
2112: || SQLERRM , 'WMS_TASK_ACTION_PVT.SUBMIT_REQUEST' );
2113: END SUBMIT_REQUEST;
2114:

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

2108:
2109: DEBUG( 'Unexpected error has occured. Oracle error message is '
2110: || SQLERRM , 'WMS_TASK_ACTION_PVT.SUBMIT_REQUEST' );
2111: DEBUG( 'Unexpected error has occured. Oracle error message is '
2112: || SQLERRM , 'WMS_TASK_ACTION_PVT.SUBMIT_REQUEST' );
2113: END SUBMIT_REQUEST;
2114:
2115: END WMS_TASK_ACTION_PVT;

Line 2115: END WMS_TASK_ACTION_PVT;

2111: DEBUG( 'Unexpected error has occured. Oracle error message is '
2112: || SQLERRM , 'WMS_TASK_ACTION_PVT.SUBMIT_REQUEST' );
2113: END SUBMIT_REQUEST;
2114:
2115: END WMS_TASK_ACTION_PVT;