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 FND_API

Line 174: x_return_status := FND_API.G_RET_STS_SUCCESS;

170: END LOOP;
171:
172: DEBUG( 'Transaction id table populated');
173:
174: x_return_status := FND_API.G_RET_STS_SUCCESS;
175:
176: DEBUG( 'Exiting GET_TRANSACTION_TASK_IDS');
177:
178: EXCEPTION

Line 181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

177:
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' );

Line 235: IF l_return_status = fnd_api.g_ret_sts_error OR

231:
232: DEBUG( 'GET_TRANSACTION_TASK_IDS return status = ' || l_return_status );
233: DEBUG( 'GET_TRANSACTION_TASK_IDS return message = ' || l_return_message );
234:
235: IF l_return_status = fnd_api.g_ret_sts_error OR
236: l_return_status = fnd_api.g_ret_sts_unexp_error
237: THEN
238: DEBUG (' Error in GET_TRANSACTION_TASK_IDS ' );
239: x_return_status := FND_API.G_RET_STS_ERROR;

Line 236: l_return_status = fnd_api.g_ret_sts_unexp_error

232: DEBUG( 'GET_TRANSACTION_TASK_IDS return status = ' || l_return_status );
233: DEBUG( 'GET_TRANSACTION_TASK_IDS return message = ' || l_return_message );
234:
235: IF l_return_status = fnd_api.g_ret_sts_error OR
236: l_return_status = fnd_api.g_ret_sts_unexp_error
237: THEN
238: DEBUG (' Error in GET_TRANSACTION_TASK_IDS ' );
239: x_return_status := FND_API.G_RET_STS_ERROR;
240: x_return_message:= ( 'GET_TRANSACTION_TASK_IDS returned with Error status.'

Line 239: x_return_status := FND_API.G_RET_STS_ERROR;

235: IF l_return_status = fnd_api.g_ret_sts_error OR
236: l_return_status = fnd_api.g_ret_sts_unexp_error
237: THEN
238: DEBUG (' Error in GET_TRANSACTION_TASK_IDS ' );
239: x_return_status := FND_API.G_RET_STS_ERROR;
240: x_return_message:= ( 'GET_TRANSACTION_TASK_IDS returned with Error status.'
241: ||' Error message is ' || l_return_message);
242: return;
243: END IF;

Line 319: IF l_return_status = FND_API.G_RET_STS_ERROR OR

315: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.UPDATE_TASK return message = '|| l_return_msg );
316:
317: DEBUG( 'No of tasks updated = ' || l_task_id.count );
318:
319: IF l_return_status = FND_API.G_RET_STS_ERROR OR
320: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
321: THEN
322: DEBUG (' Error in WMS_WAVEPLAN_TASKS_PVT.UPDATE_TASK ' || l_return_msg );
323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 320: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

316:
317: DEBUG( 'No of tasks updated = ' || l_task_id.count );
318:
319: IF l_return_status = FND_API.G_RET_STS_ERROR OR
320: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
321: THEN
322: DEBUG (' Error in WMS_WAVEPLAN_TASKS_PVT.UPDATE_TASK ' || l_return_msg );
323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
324: x_return_message:= 'Error in wms_waveplan_tasks_pvt.update_task. '

Line 323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

319: IF l_return_status = FND_API.G_RET_STS_ERROR OR
320: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
321: THEN
322: DEBUG (' Error in WMS_WAVEPLAN_TASKS_PVT.UPDATE_TASK ' || l_return_msg );
323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
324: x_return_message:= 'Error in wms_waveplan_tasks_pvt.update_task. '
325: || 'Error message is ' || l_return_msg;
326: return;
327: END IF;

Line 331: x_return_status := FND_API.G_RET_STS_SUCCESS;

327: END IF;
328: END IF;
329: END LOOP;
330:
331: x_return_status := FND_API.G_RET_STS_SUCCESS;
332:
333: DEBUG( 'Exiting UPDATE_TASK');
334:
335: EXCEPTION

Line 338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

334:
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' );

Line 393: IF l_return_status = fnd_api.g_ret_sts_error OR

389:
390: DEBUG( 'GET_TRANSACTION_TASK_IDS return status = ' || l_return_status );
391: DEBUG( 'GET_TRANSACTION_TASK_IDS return message = ' || l_return_message );
392:
393: IF l_return_status = fnd_api.g_ret_sts_error OR
394: l_return_status = fnd_api.g_ret_sts_unexp_error
395: THEN
396: DEBUG (' Error in GET_TRANSACTION_TASK_IDS ' );
397: x_return_status := FND_API.G_RET_STS_ERROR;

Line 394: l_return_status = fnd_api.g_ret_sts_unexp_error

390: DEBUG( 'GET_TRANSACTION_TASK_IDS return status = ' || l_return_status );
391: DEBUG( 'GET_TRANSACTION_TASK_IDS return message = ' || l_return_message );
392:
393: IF l_return_status = fnd_api.g_ret_sts_error OR
394: l_return_status = fnd_api.g_ret_sts_unexp_error
395: THEN
396: DEBUG (' Error in GET_TRANSACTION_TASK_IDS ' );
397: x_return_status := FND_API.G_RET_STS_ERROR;
398: x_return_message:= ( 'GET_TRANSACTION_TASK_IDS returned with Error status.'

Line 397: x_return_status := FND_API.G_RET_STS_ERROR;

393: IF l_return_status = fnd_api.g_ret_sts_error OR
394: l_return_status = fnd_api.g_ret_sts_unexp_error
395: THEN
396: DEBUG (' Error in GET_TRANSACTION_TASK_IDS ' );
397: x_return_status := FND_API.G_RET_STS_ERROR;
398: x_return_message:= ( 'GET_TRANSACTION_TASK_IDS returned with Error status.'
399: ||' Error message is ' || l_return_message);
400: return;
401: END IF;

Line 435: IF l_return_status = FND_API.G_RET_STS_ERROR OR

431: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.CANCEL_TASK return message = '|| l_return_msg );
432:
433: DEBUG( 'No of tasks cancelled = ' || l_task_id.count );
434:
435: IF l_return_status = FND_API.G_RET_STS_ERROR OR
436: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
437: THEN
438: DEBUG (' Error in WMS_WAVEPLAN_TASKS_PVT.CANCEL_TASK ' || l_return_msg );
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 436: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

432:
433: DEBUG( 'No of tasks cancelled = ' || l_task_id.count );
434:
435: IF l_return_status = FND_API.G_RET_STS_ERROR OR
436: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
437: THEN
438: DEBUG (' Error in WMS_WAVEPLAN_TASKS_PVT.CANCEL_TASK ' || l_return_msg );
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
440: x_return_message:= 'Error in wms_waveplan_tasks_pvt.cancel_task. '

Line 439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

435: IF l_return_status = FND_API.G_RET_STS_ERROR OR
436: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
437: THEN
438: DEBUG (' Error in WMS_WAVEPLAN_TASKS_PVT.CANCEL_TASK ' || l_return_msg );
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
440: x_return_message:= 'Error in wms_waveplan_tasks_pvt.cancel_task. '
441: || 'Error message is ' || l_return_msg;
442: return;
443: END IF;

Line 447: x_return_status := FND_API.G_RET_STS_SUCCESS;

443: END IF;
444: END IF;
445: END LOOP;
446:
447: x_return_status := FND_API.G_RET_STS_SUCCESS;
448:
449: DEBUG( 'Exiting CANCEL_TASK');
450:
451: EXCEPTION

Line 454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

450:
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' );

Line 873: x_return_status := FND_API.G_RET_STS_SUCCESS;

869: ELSE
870: l_temp_query := FALSE;
871: END IF;
872:
873: x_return_status := FND_API.G_RET_STS_SUCCESS;
874:
875: DEBUG( 'Exiting SET_QUERY_TASKS_PARAMETERS');
876:
877: EXCEPTION

Line 880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

876:
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');

Line 976: x_return_status := FND_API.G_RET_STS_SUCCESS;

972: ELSE
973: l_temp_action := FALSE;
974: END IF;
975:
976: x_return_status := FND_API.G_RET_STS_SUCCESS;
977:
978: DEBUG( 'Exiting SET_ACTION_TASKS_PARAMETERS');
979:
980: EXCEPTION

Line 983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

979:
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');

Line 1009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1005: DEBUG( 'Temporary query records cleaned. Records deleted = ' || sql%rowcount );
1006: EXCEPTION
1007: WHEN OTHERS
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;

Line 1022: x_return_status := FND_API.G_RET_STS_SUCCESS;

1018: , 'WMS_TASK_ACTION_PVT.DELETE_TEMP_QUERY - other error'
1019: );
1020: END;
1021:
1022: x_return_status := FND_API.G_RET_STS_SUCCESS;
1023:
1024: DEBUG( 'Exiting DELETE_TEMP_QUERY');
1025: EXCEPTION
1026: WHEN OTHERS

Line 1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1024: DEBUG( 'Exiting 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');

Line 1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1051:
1052: EXCEPTION
1053: WHEN OTHERS
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;

Line 1067: x_return_status := FND_API.G_RET_STS_SUCCESS;

1063: , 'WMS_TASK_ACTION_PVT.DELETE_TEMP_ACTION - other error'
1064: );
1065: END;
1066:
1067: x_return_status := FND_API.G_RET_STS_SUCCESS;
1068:
1069: DEBUG( 'Exiting DELETE_TEMP_ACTION');
1070: EXCEPTION
1071: WHEN OTHERS

Line 1073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1069: DEBUG( 'Exiting 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');

Line 1134: IF l_return_status = fnd_api.g_ret_sts_error OR

1130: ELSE
1131: DEBUG( 'l_temP_action = FALSE');
1132: END IF;
1133:
1134: IF l_return_status = fnd_api.g_ret_sts_error OR
1135: l_return_status = fnd_api.g_ret_sts_unexp_error
1136: THEN
1137: retcode := '2';
1138: errbuf := 'Error: ' || l_return_message;

Line 1135: l_return_status = fnd_api.g_ret_sts_unexp_error

1131: DEBUG( 'l_temP_action = FALSE');
1132: END IF;
1133:
1134: IF l_return_status = fnd_api.g_ret_sts_error OR
1135: l_return_status = fnd_api.g_ret_sts_unexp_error
1136: THEN
1137: retcode := '2';
1138: errbuf := 'Error: ' || l_return_message;
1139:

Line 1154: IF l_return_status = fnd_api.g_ret_sts_error

1150:
1151: DEBUG( 'DELETE_TEMP_QUERY return status = ' || l_return_status );
1152: DEBUG( 'DELETE_TEMP_QUERY return message = ' || l_return_message );
1153:
1154: IF l_return_status = fnd_api.g_ret_sts_error
1155: OR l_return_status = fnd_api.g_ret_sts_unexp_error
1156: THEN
1157: errbuf := errbuf || l_return_message;
1158: ELSE

Line 1155: OR l_return_status = fnd_api.g_ret_sts_unexp_error

1151: DEBUG( 'DELETE_TEMP_QUERY return status = ' || l_return_status );
1152: DEBUG( 'DELETE_TEMP_QUERY return message = ' || l_return_message );
1153:
1154: IF l_return_status = fnd_api.g_ret_sts_error
1155: OR l_return_status = fnd_api.g_ret_sts_unexp_error
1156: THEN
1157: errbuf := errbuf || l_return_message;
1158: ELSE
1159: COMMIT WORK;

Line 1177: IF l_return_status = fnd_api.g_ret_sts_error

1173:
1174: DEBUG( 'DELETE_TEMP_ACTION return status = ' || l_return_status );
1175: DEBUG( 'DELETE_TEMP_ACTION return message = ' || l_return_message );
1176:
1177: IF l_return_status = fnd_api.g_ret_sts_error
1178: OR l_return_status = fnd_api.g_ret_sts_unexp_error
1179: THEN
1180: errbuf := errbuf || l_return_message;
1181: ELSE

Line 1178: OR l_return_status = fnd_api.g_ret_sts_unexp_error

1174: DEBUG( 'DELETE_TEMP_ACTION return status = ' || l_return_status );
1175: DEBUG( 'DELETE_TEMP_ACTION return message = ' || l_return_message );
1176:
1177: IF l_return_status = fnd_api.g_ret_sts_error
1178: OR l_return_status = fnd_api.g_ret_sts_unexp_error
1179: THEN
1180: errbuf := errbuf || l_return_message;
1181: ELSE
1182: COMMIT WORK;

Line 1215: IF l_return_status = fnd_api.g_ret_sts_error

1211: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.SAVE_TASKS l_msg_data = ' || l_msg_data );
1212: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.SAVE_TASKS l_msg_count = ' || l_msg_count );
1213:
1214:
1215: IF l_return_status = fnd_api.g_ret_sts_error
1216: OR l_return_status = fnd_api.g_ret_sts_unexp_error
1217: THEN
1218: retcode := '2';
1219: errbuf := 'Error: ' || l_return_message;

Line 1216: OR l_return_status = fnd_api.g_ret_sts_unexp_error

1212: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.SAVE_TASKS l_msg_count = ' || l_msg_count );
1213:
1214:
1215: IF l_return_status = fnd_api.g_ret_sts_error
1216: OR l_return_status = fnd_api.g_ret_sts_unexp_error
1217: THEN
1218: retcode := '2';
1219: errbuf := 'Error: ' || l_return_message;
1220:

Line 1234: IF l_return_status = fnd_api.g_ret_sts_error

1230: );
1231: DEBUG( 'DELETE_TEMP_QUERY return status = ' || l_return_status );
1232: DEBUG( 'DELETE_TEMP_QUERY return message = ' || l_return_message );
1233:
1234: IF l_return_status = fnd_api.g_ret_sts_error
1235: OR l_return_status = fnd_api.g_ret_sts_unexp_error
1236: THEN
1237: errbuf := errbuf || l_return_message;
1238: ELSE

Line 1235: OR l_return_status = fnd_api.g_ret_sts_unexp_error

1231: DEBUG( 'DELETE_TEMP_QUERY return status = ' || l_return_status );
1232: DEBUG( 'DELETE_TEMP_QUERY return message = ' || l_return_message );
1233:
1234: IF l_return_status = fnd_api.g_ret_sts_error
1235: OR l_return_status = fnd_api.g_ret_sts_unexp_error
1236: THEN
1237: errbuf := errbuf || l_return_message;
1238: ELSE
1239: COMMIT WORK;

Line 1257: IF l_return_status = fnd_api.g_ret_sts_error

1253:
1254: DEBUG( 'DELETE_TEMP_ACTION return status = ' || l_return_status );
1255: DEBUG( 'DELETE_TEMP_ACTION return message = ' || l_return_message );
1256:
1257: IF l_return_status = fnd_api.g_ret_sts_error
1258: OR l_return_status = fnd_api.g_ret_sts_unexp_error
1259: THEN
1260: errbuf := errbuf || l_return_message;
1261: ELSE

Line 1258: OR l_return_status = fnd_api.g_ret_sts_unexp_error

1254: DEBUG( 'DELETE_TEMP_ACTION return status = ' || l_return_status );
1255: DEBUG( 'DELETE_TEMP_ACTION return message = ' || l_return_message );
1256:
1257: IF l_return_status = fnd_api.g_ret_sts_error
1258: OR l_return_status = fnd_api.g_ret_sts_unexp_error
1259: THEN
1260: errbuf := errbuf || l_return_message;
1261: ELSE
1262: COMMIT WORK;

Line 1281: IF l_return_status = fnd_api.g_ret_sts_error

1277: x_return_message => l_return_message
1278: );
1279: DEBUG( 'DELETE_TEMP_QUERY return status = ' || l_return_status );
1280: DEBUG( 'DELETE_TEMP_QUERY return message = ' || l_return_message );
1281: IF l_return_status = fnd_api.g_ret_sts_error
1282: OR l_return_status = fnd_api.g_ret_sts_unexp_error
1283: THEN
1284: retcode := '2';
1285: errbuf := errbuf || l_return_message;

Line 1282: OR l_return_status = fnd_api.g_ret_sts_unexp_error

1278: );
1279: DEBUG( 'DELETE_TEMP_QUERY return status = ' || l_return_status );
1280: DEBUG( 'DELETE_TEMP_QUERY return message = ' || l_return_message );
1281: IF l_return_status = fnd_api.g_ret_sts_error
1282: OR l_return_status = fnd_api.g_ret_sts_unexp_error
1283: THEN
1284: retcode := '2';
1285: errbuf := errbuf || l_return_message;
1286: ELSE

Line 1302: IF l_return_status = fnd_api.g_ret_sts_error

1298: x_return_message => l_return_message
1299: );
1300: DEBUG( 'DELETE_TEMP_ACTION return status = ' || l_return_status );
1301: DEBUG( 'DELETE_TEMP_ACTION return message = ' || l_return_message );
1302: IF l_return_status = fnd_api.g_ret_sts_error
1303: OR l_return_status = fnd_api.g_ret_sts_unexp_error
1304: THEN
1305: retcode := '2';
1306: errbuf := errbuf || l_return_message;

Line 1303: OR l_return_status = fnd_api.g_ret_sts_unexp_error

1299: );
1300: DEBUG( 'DELETE_TEMP_ACTION return status = ' || l_return_status );
1301: DEBUG( 'DELETE_TEMP_ACTION return message = ' || l_return_message );
1302: IF l_return_status = fnd_api.g_ret_sts_error
1303: OR l_return_status = fnd_api.g_ret_sts_unexp_error
1304: THEN
1305: retcode := '2';
1306: errbuf := errbuf || l_return_message;
1307: ELSE

Line 1439: x_return_status := fnd_api.g_ret_sts_success;

1435: THEN
1436: CLOSE c_saved_queries;
1437: DEBUG ('No data found for query name = ' || p_query_name);
1438: x_rowcount := 0;
1439: x_return_status := fnd_api.g_ret_sts_success;
1440: x_return_message:= 'No data found for query name = ' || p_query_name ;
1441:
1442: FOR rec_query_type IN c_query_type( p_action_name )
1443: LOOP

Line 1473: IF l_return_status = fnd_api.g_ret_sts_error OR

1469:
1470: DEBUG( 'SET_QUERY_TASKS_PARAMETERS return status = ' || l_return_status );
1471: DEBUG( 'SET_QUERY_TASKS_PARAMETERS return message = ' || l_return_message );
1472:
1473: IF l_return_status = fnd_api.g_ret_sts_error OR
1474: l_return_status = fnd_api.g_ret_sts_unexp_error
1475: THEN
1476: DEBUG (' Error in SET_QUERY_TASKS_PARAMETERS ' );
1477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1474: l_return_status = fnd_api.g_ret_sts_unexp_error

1470: DEBUG( 'SET_QUERY_TASKS_PARAMETERS return status = ' || l_return_status );
1471: DEBUG( 'SET_QUERY_TASKS_PARAMETERS return message = ' || l_return_message );
1472:
1473: IF l_return_status = fnd_api.g_ret_sts_error OR
1474: l_return_status = fnd_api.g_ret_sts_unexp_error
1475: THEN
1476: DEBUG (' Error in SET_QUERY_TASKS_PARAMETERS ' );
1477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1478: x_return_message:= 'SET_QUERY_TASKS_PARAMETERS returned with Error status'

Line 1477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1473: IF l_return_status = fnd_api.g_ret_sts_error OR
1474: l_return_status = fnd_api.g_ret_sts_unexp_error
1475: THEN
1476: DEBUG (' Error in SET_QUERY_TASKS_PARAMETERS ' );
1477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1478: x_return_message:= 'SET_QUERY_TASKS_PARAMETERS returned with Error status'
1479: || 'Error message = ' || l_return_message ;
1480: return;
1481: END IF;

Line 1862: IF l_return_status = fnd_api.g_ret_sts_error

1858: DEBUG ( 'WMS_WAVEPLAN_TASKS_PVT.QUERY_TASKS x_msg_data => ' || l_msg_data);
1859: DEBUG ( 'WMS_WAVEPLAN_TASKS_PVT.QUERY_TASKS x_msg_count => ' || l_msg_count);
1860: DEBUG ( 'WMS_WAVEPLAN_TASKS_PVT.QUERY_TASKS x_record_count => ' || l_record_count);
1861:
1862: IF l_return_status = fnd_api.g_ret_sts_error
1863: THEN
1864: DEBUG (' Error in WMS_WAVEPLAN_TASKS_PVT.QUERY_TASKS ' );
1865: x_return_status := FND_API.G_RET_STS_ERROR;
1866: x_return_message:= 'WMS_WAVEPLAN_TASKS_PVT.QUERY_TASKS returned with Error status'

Line 1865: x_return_status := FND_API.G_RET_STS_ERROR;

1861:
1862: IF l_return_status = fnd_api.g_ret_sts_error
1863: THEN
1864: DEBUG (' Error in WMS_WAVEPLAN_TASKS_PVT.QUERY_TASKS ' );
1865: x_return_status := FND_API.G_RET_STS_ERROR;
1866: x_return_message:= 'WMS_WAVEPLAN_TASKS_PVT.QUERY_TASKS returned with Error status'
1867: || 'Error message is ' || l_return_message;
1868: return;
1869: END IF;

Line 1897: x_return_status := fnd_api.g_ret_sts_success;

1893: CLOSE c_saved_actions;
1894:
1895: DEBUG ('No data found for action name. ' || p_action_name);
1896: x_rowcount := 0;
1897: x_return_status := fnd_api.g_ret_sts_success;
1898: x_return_message:= 'No data found for action name. ' || p_action_name;
1899:
1900: FOR rec_query_type IN c_query_type( p_query_name )
1901: LOOP

Line 1932: IF l_return_status = fnd_api.g_ret_sts_error OR

1928: DEBUG ( 'SET_ACTION_TASKS_PARAMETERS return status = ' || l_return_status );
1929: DEBUG ( 'SET_ACTION_TASKS_PARAMETERS return message = ' || l_return_message );
1930:
1931: -- If set_action_tasks_parameters returns error then log message and return.
1932: IF l_return_status = fnd_api.g_ret_sts_error OR
1933: l_return_status = fnd_api.g_ret_sts_unexp_error
1934: THEN
1935: DEBUG (' Error in SET_ACTION_TASKS_PARAMETERS ' );
1936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1933: l_return_status = fnd_api.g_ret_sts_unexp_error

1929: DEBUG ( 'SET_ACTION_TASKS_PARAMETERS return message = ' || l_return_message );
1930:
1931: -- If set_action_tasks_parameters returns error then log message and return.
1932: IF l_return_status = fnd_api.g_ret_sts_error OR
1933: l_return_status = fnd_api.g_ret_sts_unexp_error
1934: THEN
1935: DEBUG (' Error in SET_ACTION_TASKS_PARAMETERS ' );
1936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1937: return;

Line 1936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1932: IF l_return_status = fnd_api.g_ret_sts_error OR
1933: l_return_status = fnd_api.g_ret_sts_unexp_error
1934: THEN
1935: DEBUG (' Error in SET_ACTION_TASKS_PARAMETERS ' );
1936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1937: return;
1938: END IF;
1939:
1940: DEBUG ( 'No of eligible tasks to be updated are ' || l_field_name_table.count );

Line 1953: IF l_return_status = fnd_api.g_ret_sts_error OR

1949: ( x_return_status => l_return_status,
1950: x_return_message=> l_return_message
1951: );
1952:
1953: IF l_return_status = fnd_api.g_ret_sts_error OR
1954: l_return_status = fnd_api.g_ret_sts_unexp_error
1955: THEN
1956: DEBUG (' Error in UPDATE_TASK ' );
1957: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1954: l_return_status = fnd_api.g_ret_sts_unexp_error

1950: x_return_message=> l_return_message
1951: );
1952:
1953: IF l_return_status = fnd_api.g_ret_sts_error OR
1954: l_return_status = fnd_api.g_ret_sts_unexp_error
1955: THEN
1956: DEBUG (' Error in UPDATE_TASK ' );
1957: x_return_status := FND_API.G_RET_STS_ERROR;
1958: x_return_message:= 'UPDATE_TASK returned with Error status'

Line 1957: x_return_status := FND_API.G_RET_STS_ERROR;

1953: IF l_return_status = fnd_api.g_ret_sts_error OR
1954: l_return_status = fnd_api.g_ret_sts_unexp_error
1955: THEN
1956: DEBUG (' Error in UPDATE_TASK ' );
1957: x_return_status := FND_API.G_RET_STS_ERROR;
1958: x_return_message:= 'UPDATE_TASK returned with Error status'
1959: || 'Error message is ' || l_return_message;
1960: return;
1961: END IF;

Line 1970: IF l_return_status = fnd_api.g_ret_sts_error OR

1966: ( x_return_status => l_return_status,
1967: x_return_message=> l_return_message
1968: );
1969:
1970: IF l_return_status = fnd_api.g_ret_sts_error OR
1971: l_return_status = fnd_api.g_ret_sts_unexp_error
1972: THEN
1973: DEBUG (' Error in CANCEL_TASK ' );
1974: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1971: l_return_status = fnd_api.g_ret_sts_unexp_error

1967: x_return_message=> l_return_message
1968: );
1969:
1970: IF l_return_status = fnd_api.g_ret_sts_error OR
1971: l_return_status = fnd_api.g_ret_sts_unexp_error
1972: THEN
1973: DEBUG (' Error in CANCEL_TASK ' );
1974: x_return_status := FND_API.G_RET_STS_ERROR;
1975: x_return_message:= 'CANCEL_TASK returned with Error status'

Line 1974: x_return_status := FND_API.G_RET_STS_ERROR;

1970: IF l_return_status = fnd_api.g_ret_sts_error OR
1971: l_return_status = fnd_api.g_ret_sts_unexp_error
1972: THEN
1973: DEBUG (' Error in CANCEL_TASK ' );
1974: x_return_status := FND_API.G_RET_STS_ERROR;
1975: x_return_message:= 'CANCEL_TASK returned with Error status'
1976: || 'Error message is ' || l_return_message;
1977: return;
1978: END IF;

Line 1985: x_return_status := FND_API.G_RET_STS_ERROR;

1981: ELSE
1982: DEBUG( 'Could not perform specified Action.' );
1983: DEBUG( 'Action type of input parameter Action Name, "' || l_action_type ||
1984: '", does not match with Action parameter, "'|| p_action || '".');
1985: x_return_status := FND_API.G_RET_STS_ERROR;
1986: x_return_message:= 'Could not perform specified Action.'
1987: || 'Action type of input parameter Action Name,"'
1988: || l_action_type ||
1989: '", does not match with Action parameter,"'

Line 2009: IF l_return_status = fnd_api.g_ret_sts_error

2005:
2006: DEBUG( 'DELETE_TEMP_QUERY return status = ' || l_return_status );
2007: DEBUG( 'DELETE_TEMP_QUERY return message = ' || l_return_message );
2008:
2009: IF l_return_status = fnd_api.g_ret_sts_error
2010: OR l_return_status = fnd_api.g_ret_sts_unexp_error
2011: THEN
2012: x_return_status := fnd_api.g_ret_sts_error;
2013: x_return_message := l_return_message;

Line 2010: OR l_return_status = fnd_api.g_ret_sts_unexp_error

2006: DEBUG( 'DELETE_TEMP_QUERY return status = ' || l_return_status );
2007: DEBUG( 'DELETE_TEMP_QUERY return message = ' || l_return_message );
2008:
2009: IF l_return_status = fnd_api.g_ret_sts_error
2010: OR l_return_status = fnd_api.g_ret_sts_unexp_error
2011: THEN
2012: x_return_status := fnd_api.g_ret_sts_error;
2013: x_return_message := l_return_message;
2014: END IF;

Line 2012: x_return_status := fnd_api.g_ret_sts_error;

2008:
2009: IF l_return_status = fnd_api.g_ret_sts_error
2010: OR l_return_status = fnd_api.g_ret_sts_unexp_error
2011: THEN
2012: x_return_status := fnd_api.g_ret_sts_error;
2013: x_return_message := l_return_message;
2014: END IF;
2015: END IF;
2016:

Line 2030: IF l_return_status = fnd_api.g_ret_sts_error

2026:
2027: DEBUG( 'DELETE_TEMP_ACTION return status = ' || l_return_status );
2028: DEBUG( 'DELETE_TEMP_ACTION return message = ' || l_return_message );
2029:
2030: IF l_return_status = fnd_api.g_ret_sts_error
2031: OR l_return_status = fnd_api.g_ret_sts_unexp_error
2032: THEN
2033: x_return_status := fnd_api.g_ret_sts_error;
2034: x_return_message := l_return_message;

Line 2031: OR l_return_status = fnd_api.g_ret_sts_unexp_error

2027: DEBUG( 'DELETE_TEMP_ACTION return status = ' || l_return_status );
2028: DEBUG( 'DELETE_TEMP_ACTION return message = ' || l_return_message );
2029:
2030: IF l_return_status = fnd_api.g_ret_sts_error
2031: OR l_return_status = fnd_api.g_ret_sts_unexp_error
2032: THEN
2033: x_return_status := fnd_api.g_ret_sts_error;
2034: x_return_message := l_return_message;
2035: END IF;

Line 2033: x_return_status := fnd_api.g_ret_sts_error;

2029:
2030: IF l_return_status = fnd_api.g_ret_sts_error
2031: OR l_return_status = fnd_api.g_ret_sts_unexp_error
2032: THEN
2033: x_return_status := fnd_api.g_ret_sts_error;
2034: x_return_message := l_return_message;
2035: END IF;
2036: END IF;
2037: END IF;

Line 2039: x_return_status := FND_API.G_RET_STS_SUCCESS;

2035: END IF;
2036: END IF;
2037: END IF;
2038:
2039: x_return_status := FND_API.G_RET_STS_SUCCESS;
2040:
2041: DEBUG( 'Exiting TASK_ACTION');
2042:
2043: EXCEPTION

Line 2046: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2042:
2043: EXCEPTION
2044: WHEN OTHERS
2045: THEN
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' );

Line 2089: l_return := FND_API.G_RET_STS_ERROR;

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');
2093: COMMIT WORK;

Line 2098: x_return_status := FND_API.G_RET_STS_SUCCESS;

2094: END IF;
2095:
2096: x_request_id := l_request_id;
2097:
2098: x_return_status := FND_API.G_RET_STS_SUCCESS;
2099:
2100: DEBUG( 'Exiting SUBMIT_REQUEST' );
2101:
2102: EXCEPTION

Line 2105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2101:
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 '