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 170: x_return_status := FND_API.G_RET_STS_SUCCESS;

166: END LOOP;
167:
168: DEBUG( 'Transaction id table populated');
169:
170: x_return_status := FND_API.G_RET_STS_SUCCESS;
171:
172: DEBUG( 'Exiting GET_TRANSACTION_TASK_IDS');
173:
174: EXCEPTION

Line 177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 231: IF l_return_status = fnd_api.g_ret_sts_error OR

227:
228: DEBUG( 'GET_TRANSACTION_TASK_IDS return status = ' || l_return_status );
229: DEBUG( 'GET_TRANSACTION_TASK_IDS return message = ' || l_return_message );
230:
231: IF l_return_status = fnd_api.g_ret_sts_error OR
232: l_return_status = fnd_api.g_ret_sts_unexp_error
233: THEN
234: DEBUG (' Error in GET_TRANSACTION_TASK_IDS ' );
235: x_return_status := FND_API.G_RET_STS_ERROR;

Line 232: l_return_status = fnd_api.g_ret_sts_unexp_error

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

Line 235: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 315: IF l_return_status = FND_API.G_RET_STS_ERROR OR

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

Line 316: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

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

Line 319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 327: x_return_status := FND_API.G_RET_STS_SUCCESS;

323: END IF;
324: END IF;
325: END LOOP;
326:
327: x_return_status := FND_API.G_RET_STS_SUCCESS;
328:
329: DEBUG( 'Exiting UPDATE_TASK');
330:
331: EXCEPTION

Line 334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 389: IF l_return_status = fnd_api.g_ret_sts_error OR

385:
386: DEBUG( 'GET_TRANSACTION_TASK_IDS return status = ' || l_return_status );
387: DEBUG( 'GET_TRANSACTION_TASK_IDS return message = ' || l_return_message );
388:
389: IF l_return_status = fnd_api.g_ret_sts_error OR
390: l_return_status = fnd_api.g_ret_sts_unexp_error
391: THEN
392: DEBUG (' Error in GET_TRANSACTION_TASK_IDS ' );
393: x_return_status := FND_API.G_RET_STS_ERROR;

Line 390: l_return_status = fnd_api.g_ret_sts_unexp_error

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

Line 393: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 431: IF l_return_status = FND_API.G_RET_STS_ERROR OR

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

Line 432: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

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

Line 435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 443: x_return_status := FND_API.G_RET_STS_SUCCESS;

439: END IF;
440: END IF;
441: END LOOP;
442:
443: x_return_status := FND_API.G_RET_STS_SUCCESS;
444:
445: DEBUG( 'Exiting CANCEL_TASK');
446:
447: EXCEPTION

Line 450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 856: x_return_status := FND_API.G_RET_STS_SUCCESS;

852: ELSE
853: l_temp_query := FALSE;
854: END IF;
855:
856: x_return_status := FND_API.G_RET_STS_SUCCESS;
857:
858: DEBUG( 'Exiting SET_QUERY_TASKS_PARAMETERS');
859:
860: EXCEPTION

Line 863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 951: x_return_status := FND_API.G_RET_STS_SUCCESS;

947: ELSE
948: l_temp_action := FALSE;
949: END IF;
950:
951: x_return_status := FND_API.G_RET_STS_SUCCESS;
952:
953: DEBUG( 'Exiting SET_ACTION_TASKS_PARAMETERS');
954:
955: EXCEPTION

Line 958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 997: x_return_status := FND_API.G_RET_STS_SUCCESS;

993: , 'WMS_TASK_ACTION_PVT.DELETE_TEMP_QUERY - other error'
994: );
995: END;
996:
997: x_return_status := FND_API.G_RET_STS_SUCCESS;
998:
999: DEBUG( 'Exiting DELETE_TEMP_QUERY');
1000: EXCEPTION
1001: WHEN OTHERS

Line 1003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1026:
1027: EXCEPTION
1028: WHEN OTHERS
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;

Line 1042: x_return_status := FND_API.G_RET_STS_SUCCESS;

1038: , 'WMS_TASK_ACTION_PVT.DELETE_TEMP_ACTION - other error'
1039: );
1040: END;
1041:
1042: x_return_status := FND_API.G_RET_STS_SUCCESS;
1043:
1044: DEBUG( 'Exiting DELETE_TEMP_ACTION');
1045: EXCEPTION
1046: WHEN OTHERS

Line 1048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1109: IF l_return_status = fnd_api.g_ret_sts_error OR

1105: ELSE
1106: DEBUG( 'l_temP_action = FALSE');
1107: END IF;
1108:
1109: IF l_return_status = fnd_api.g_ret_sts_error OR
1110: l_return_status = fnd_api.g_ret_sts_unexp_error
1111: THEN
1112: retcode := '2';
1113: errbuf := 'Error: ' || l_return_message;

Line 1110: l_return_status = fnd_api.g_ret_sts_unexp_error

1106: DEBUG( 'l_temP_action = FALSE');
1107: END IF;
1108:
1109: IF l_return_status = fnd_api.g_ret_sts_error OR
1110: l_return_status = fnd_api.g_ret_sts_unexp_error
1111: THEN
1112: retcode := '2';
1113: errbuf := 'Error: ' || l_return_message;
1114:

Line 1129: IF l_return_status = fnd_api.g_ret_sts_error

1125:
1126: DEBUG( 'DELETE_TEMP_QUERY return status = ' || l_return_status );
1127: DEBUG( 'DELETE_TEMP_QUERY return message = ' || l_return_message );
1128:
1129: IF l_return_status = fnd_api.g_ret_sts_error
1130: OR l_return_status = fnd_api.g_ret_sts_unexp_error
1131: THEN
1132: errbuf := errbuf || l_return_message;
1133: ELSE

Line 1130: OR l_return_status = fnd_api.g_ret_sts_unexp_error

1126: DEBUG( 'DELETE_TEMP_QUERY return status = ' || l_return_status );
1127: DEBUG( 'DELETE_TEMP_QUERY return message = ' || l_return_message );
1128:
1129: IF l_return_status = fnd_api.g_ret_sts_error
1130: OR l_return_status = fnd_api.g_ret_sts_unexp_error
1131: THEN
1132: errbuf := errbuf || l_return_message;
1133: ELSE
1134: COMMIT WORK;

Line 1152: IF l_return_status = fnd_api.g_ret_sts_error

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

Line 1153: OR l_return_status = fnd_api.g_ret_sts_unexp_error

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

Line 1190: IF l_return_status = fnd_api.g_ret_sts_error

1186: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.SAVE_TASKS l_msg_data = ' || l_msg_data );
1187: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.SAVE_TASKS l_msg_count = ' || l_msg_count );
1188:
1189:
1190: IF l_return_status = fnd_api.g_ret_sts_error
1191: OR l_return_status = fnd_api.g_ret_sts_unexp_error
1192: THEN
1193: retcode := '2';
1194: errbuf := 'Error: ' || l_return_message;

Line 1191: OR l_return_status = fnd_api.g_ret_sts_unexp_error

1187: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.SAVE_TASKS l_msg_count = ' || l_msg_count );
1188:
1189:
1190: IF l_return_status = fnd_api.g_ret_sts_error
1191: OR l_return_status = fnd_api.g_ret_sts_unexp_error
1192: THEN
1193: retcode := '2';
1194: errbuf := 'Error: ' || l_return_message;
1195:

Line 1209: IF l_return_status = fnd_api.g_ret_sts_error

1205: );
1206: DEBUG( 'DELETE_TEMP_QUERY return status = ' || l_return_status );
1207: DEBUG( 'DELETE_TEMP_QUERY return message = ' || l_return_message );
1208:
1209: IF l_return_status = fnd_api.g_ret_sts_error
1210: OR l_return_status = fnd_api.g_ret_sts_unexp_error
1211: THEN
1212: errbuf := errbuf || l_return_message;
1213: ELSE

Line 1210: OR l_return_status = fnd_api.g_ret_sts_unexp_error

1206: DEBUG( 'DELETE_TEMP_QUERY return status = ' || l_return_status );
1207: DEBUG( 'DELETE_TEMP_QUERY return message = ' || l_return_message );
1208:
1209: IF l_return_status = fnd_api.g_ret_sts_error
1210: OR l_return_status = fnd_api.g_ret_sts_unexp_error
1211: THEN
1212: errbuf := errbuf || l_return_message;
1213: ELSE
1214: COMMIT WORK;

Line 1232: IF l_return_status = fnd_api.g_ret_sts_error

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

Line 1233: OR l_return_status = fnd_api.g_ret_sts_unexp_error

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

Line 1256: IF l_return_status = fnd_api.g_ret_sts_error

1252: x_return_message => l_return_message
1253: );
1254: DEBUG( 'DELETE_TEMP_QUERY return status = ' || l_return_status );
1255: DEBUG( 'DELETE_TEMP_QUERY return message = ' || l_return_message );
1256: IF l_return_status = fnd_api.g_ret_sts_error
1257: OR l_return_status = fnd_api.g_ret_sts_unexp_error
1258: THEN
1259: retcode := '2';
1260: errbuf := errbuf || l_return_message;

Line 1257: OR l_return_status = fnd_api.g_ret_sts_unexp_error

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

Line 1277: IF l_return_status = fnd_api.g_ret_sts_error

1273: x_return_message => l_return_message
1274: );
1275: DEBUG( 'DELETE_TEMP_ACTION return status = ' || l_return_status );
1276: DEBUG( 'DELETE_TEMP_ACTION return message = ' || l_return_message );
1277: IF l_return_status = fnd_api.g_ret_sts_error
1278: OR l_return_status = fnd_api.g_ret_sts_unexp_error
1279: THEN
1280: retcode := '2';
1281: errbuf := errbuf || l_return_message;

Line 1278: OR l_return_status = fnd_api.g_ret_sts_unexp_error

1274: );
1275: DEBUG( 'DELETE_TEMP_ACTION return status = ' || l_return_status );
1276: DEBUG( 'DELETE_TEMP_ACTION return message = ' || l_return_message );
1277: IF l_return_status = fnd_api.g_ret_sts_error
1278: OR l_return_status = fnd_api.g_ret_sts_unexp_error
1279: THEN
1280: retcode := '2';
1281: errbuf := errbuf || l_return_message;
1282: ELSE

Line 1414: x_return_status := fnd_api.g_ret_sts_success;

1410: THEN
1411: CLOSE c_saved_queries;
1412: DEBUG ('No data found for query name = ' || p_query_name);
1413: x_rowcount := 0;
1414: x_return_status := fnd_api.g_ret_sts_success;
1415: x_return_message:= 'No data found for query name = ' || p_query_name ;
1416:
1417: FOR rec_query_type IN c_query_type( p_action_name )
1418: LOOP

Line 1448: IF l_return_status = fnd_api.g_ret_sts_error OR

1444:
1445: DEBUG( 'SET_QUERY_TASKS_PARAMETERS return status = ' || l_return_status );
1446: DEBUG( 'SET_QUERY_TASKS_PARAMETERS return message = ' || l_return_message );
1447:
1448: IF l_return_status = fnd_api.g_ret_sts_error OR
1449: l_return_status = fnd_api.g_ret_sts_unexp_error
1450: THEN
1451: DEBUG (' Error in SET_QUERY_TASKS_PARAMETERS ' );
1452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1449: l_return_status = fnd_api.g_ret_sts_unexp_error

1445: DEBUG( 'SET_QUERY_TASKS_PARAMETERS return status = ' || l_return_status );
1446: DEBUG( 'SET_QUERY_TASKS_PARAMETERS return message = ' || l_return_message );
1447:
1448: IF l_return_status = fnd_api.g_ret_sts_error OR
1449: l_return_status = fnd_api.g_ret_sts_unexp_error
1450: THEN
1451: DEBUG (' Error in SET_QUERY_TASKS_PARAMETERS ' );
1452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1453: x_return_message:= 'SET_QUERY_TASKS_PARAMETERS returned with Error status'

Line 1452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1448: IF l_return_status = fnd_api.g_ret_sts_error OR
1449: l_return_status = fnd_api.g_ret_sts_unexp_error
1450: THEN
1451: DEBUG (' Error in SET_QUERY_TASKS_PARAMETERS ' );
1452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1453: x_return_message:= 'SET_QUERY_TASKS_PARAMETERS returned with Error status'
1454: || 'Error message = ' || l_return_message ;
1455: return;
1456: END IF;

Line 1831: IF l_return_status = fnd_api.g_ret_sts_error

1827: DEBUG ( 'WMS_WAVEPLAN_TASKS_PVT.QUERY_TASKS x_msg_data => ' || l_msg_data);
1828: DEBUG ( 'WMS_WAVEPLAN_TASKS_PVT.QUERY_TASKS x_msg_count => ' || l_msg_count);
1829: DEBUG ( 'WMS_WAVEPLAN_TASKS_PVT.QUERY_TASKS x_record_count => ' || l_record_count);
1830:
1831: IF l_return_status = fnd_api.g_ret_sts_error
1832: THEN
1833: DEBUG (' Error in WMS_WAVEPLAN_TASKS_PVT.QUERY_TASKS ' );
1834: x_return_status := FND_API.G_RET_STS_ERROR;
1835: x_return_message:= 'WMS_WAVEPLAN_TASKS_PVT.QUERY_TASKS returned with Error status'

Line 1834: x_return_status := FND_API.G_RET_STS_ERROR;

1830:
1831: IF l_return_status = fnd_api.g_ret_sts_error
1832: THEN
1833: DEBUG (' Error in WMS_WAVEPLAN_TASKS_PVT.QUERY_TASKS ' );
1834: x_return_status := FND_API.G_RET_STS_ERROR;
1835: x_return_message:= 'WMS_WAVEPLAN_TASKS_PVT.QUERY_TASKS returned with Error status'
1836: || 'Error message is ' || l_return_message;
1837: return;
1838: END IF;

Line 1866: x_return_status := fnd_api.g_ret_sts_success;

1862: CLOSE c_saved_actions;
1863:
1864: DEBUG ('No data found for action name. ' || p_action_name);
1865: x_rowcount := 0;
1866: x_return_status := fnd_api.g_ret_sts_success;
1867: x_return_message:= 'No data found for action name. ' || p_action_name;
1868:
1869: FOR rec_query_type IN c_query_type( p_query_name )
1870: LOOP

Line 1901: IF l_return_status = fnd_api.g_ret_sts_error OR

1897: DEBUG ( 'SET_ACTION_TASKS_PARAMETERS return status = ' || l_return_status );
1898: DEBUG ( 'SET_ACTION_TASKS_PARAMETERS return message = ' || l_return_message );
1899:
1900: -- If set_action_tasks_parameters returns error then log message and return.
1901: IF l_return_status = fnd_api.g_ret_sts_error OR
1902: l_return_status = fnd_api.g_ret_sts_unexp_error
1903: THEN
1904: DEBUG (' Error in SET_ACTION_TASKS_PARAMETERS ' );
1905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1902: l_return_status = fnd_api.g_ret_sts_unexp_error

1898: DEBUG ( 'SET_ACTION_TASKS_PARAMETERS return message = ' || l_return_message );
1899:
1900: -- If set_action_tasks_parameters returns error then log message and return.
1901: IF l_return_status = fnd_api.g_ret_sts_error OR
1902: l_return_status = fnd_api.g_ret_sts_unexp_error
1903: THEN
1904: DEBUG (' Error in SET_ACTION_TASKS_PARAMETERS ' );
1905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1906: return;

Line 1905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1901: IF l_return_status = fnd_api.g_ret_sts_error OR
1902: l_return_status = fnd_api.g_ret_sts_unexp_error
1903: THEN
1904: DEBUG (' Error in SET_ACTION_TASKS_PARAMETERS ' );
1905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1906: return;
1907: END IF;
1908:
1909: DEBUG ( 'No of eligible tasks to be updated are ' || l_field_name_table.count );

Line 1922: IF l_return_status = fnd_api.g_ret_sts_error OR

1918: ( x_return_status => l_return_status,
1919: x_return_message=> l_return_message
1920: );
1921:
1922: IF l_return_status = fnd_api.g_ret_sts_error OR
1923: l_return_status = fnd_api.g_ret_sts_unexp_error
1924: THEN
1925: DEBUG (' Error in UPDATE_TASK ' );
1926: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1923: l_return_status = fnd_api.g_ret_sts_unexp_error

1919: x_return_message=> l_return_message
1920: );
1921:
1922: IF l_return_status = fnd_api.g_ret_sts_error OR
1923: l_return_status = fnd_api.g_ret_sts_unexp_error
1924: THEN
1925: DEBUG (' Error in UPDATE_TASK ' );
1926: x_return_status := FND_API.G_RET_STS_ERROR;
1927: x_return_message:= 'UPDATE_TASK returned with Error status'

Line 1926: x_return_status := FND_API.G_RET_STS_ERROR;

1922: IF l_return_status = fnd_api.g_ret_sts_error OR
1923: l_return_status = fnd_api.g_ret_sts_unexp_error
1924: THEN
1925: DEBUG (' Error in UPDATE_TASK ' );
1926: x_return_status := FND_API.G_RET_STS_ERROR;
1927: x_return_message:= 'UPDATE_TASK returned with Error status'
1928: || 'Error message is ' || l_return_message;
1929: return;
1930: END IF;

Line 1939: IF l_return_status = fnd_api.g_ret_sts_error OR

1935: ( x_return_status => l_return_status,
1936: x_return_message=> l_return_message
1937: );
1938:
1939: IF l_return_status = fnd_api.g_ret_sts_error OR
1940: l_return_status = fnd_api.g_ret_sts_unexp_error
1941: THEN
1942: DEBUG (' Error in CANCEL_TASK ' );
1943: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1940: l_return_status = fnd_api.g_ret_sts_unexp_error

1936: x_return_message=> l_return_message
1937: );
1938:
1939: IF l_return_status = fnd_api.g_ret_sts_error OR
1940: l_return_status = fnd_api.g_ret_sts_unexp_error
1941: THEN
1942: DEBUG (' Error in CANCEL_TASK ' );
1943: x_return_status := FND_API.G_RET_STS_ERROR;
1944: x_return_message:= 'CANCEL_TASK returned with Error status'

Line 1943: x_return_status := FND_API.G_RET_STS_ERROR;

1939: IF l_return_status = fnd_api.g_ret_sts_error OR
1940: l_return_status = fnd_api.g_ret_sts_unexp_error
1941: THEN
1942: DEBUG (' Error in CANCEL_TASK ' );
1943: x_return_status := FND_API.G_RET_STS_ERROR;
1944: x_return_message:= 'CANCEL_TASK returned with Error status'
1945: || 'Error message is ' || l_return_message;
1946: return;
1947: END IF;

Line 1954: x_return_status := FND_API.G_RET_STS_ERROR;

1950: ELSE
1951: DEBUG( 'Could not perform specified Action.' );
1952: DEBUG( 'Action type of input parameter Action Name, "' || l_action_type ||
1953: '", does not match with Action parameter, "'|| p_action || '".');
1954: x_return_status := FND_API.G_RET_STS_ERROR;
1955: x_return_message:= 'Could not perform specified Action.'
1956: || 'Action type of input parameter Action Name,"'
1957: || l_action_type ||
1958: '", does not match with Action parameter,"'

Line 1978: IF l_return_status = fnd_api.g_ret_sts_error

1974:
1975: DEBUG( 'DELETE_TEMP_QUERY return status = ' || l_return_status );
1976: DEBUG( 'DELETE_TEMP_QUERY return message = ' || l_return_message );
1977:
1978: IF l_return_status = fnd_api.g_ret_sts_error
1979: OR l_return_status = fnd_api.g_ret_sts_unexp_error
1980: THEN
1981: x_return_status := fnd_api.g_ret_sts_error;
1982: x_return_message := l_return_message;

Line 1979: OR l_return_status = fnd_api.g_ret_sts_unexp_error

1975: DEBUG( 'DELETE_TEMP_QUERY return status = ' || l_return_status );
1976: DEBUG( 'DELETE_TEMP_QUERY return message = ' || l_return_message );
1977:
1978: IF l_return_status = fnd_api.g_ret_sts_error
1979: OR l_return_status = fnd_api.g_ret_sts_unexp_error
1980: THEN
1981: x_return_status := fnd_api.g_ret_sts_error;
1982: x_return_message := l_return_message;
1983: END IF;

Line 1981: x_return_status := fnd_api.g_ret_sts_error;

1977:
1978: IF l_return_status = fnd_api.g_ret_sts_error
1979: OR l_return_status = fnd_api.g_ret_sts_unexp_error
1980: THEN
1981: x_return_status := fnd_api.g_ret_sts_error;
1982: x_return_message := l_return_message;
1983: END IF;
1984: END IF;
1985:

Line 1999: IF l_return_status = fnd_api.g_ret_sts_error

1995:
1996: DEBUG( 'DELETE_TEMP_ACTION return status = ' || l_return_status );
1997: DEBUG( 'DELETE_TEMP_ACTION return message = ' || l_return_message );
1998:
1999: IF l_return_status = fnd_api.g_ret_sts_error
2000: OR l_return_status = fnd_api.g_ret_sts_unexp_error
2001: THEN
2002: x_return_status := fnd_api.g_ret_sts_error;
2003: x_return_message := l_return_message;

Line 2000: OR l_return_status = fnd_api.g_ret_sts_unexp_error

1996: DEBUG( 'DELETE_TEMP_ACTION return status = ' || l_return_status );
1997: DEBUG( 'DELETE_TEMP_ACTION return message = ' || l_return_message );
1998:
1999: IF l_return_status = fnd_api.g_ret_sts_error
2000: OR l_return_status = fnd_api.g_ret_sts_unexp_error
2001: THEN
2002: x_return_status := fnd_api.g_ret_sts_error;
2003: x_return_message := l_return_message;
2004: END IF;

Line 2002: x_return_status := fnd_api.g_ret_sts_error;

1998:
1999: IF l_return_status = fnd_api.g_ret_sts_error
2000: OR l_return_status = fnd_api.g_ret_sts_unexp_error
2001: THEN
2002: x_return_status := fnd_api.g_ret_sts_error;
2003: x_return_message := l_return_message;
2004: END IF;
2005: END IF;
2006: END IF;

Line 2008: x_return_status := FND_API.G_RET_STS_SUCCESS;

2004: END IF;
2005: END IF;
2006: END IF;
2007:
2008: x_return_status := FND_API.G_RET_STS_SUCCESS;
2009:
2010: DEBUG( 'Exiting TASK_ACTION');
2011:
2012: EXCEPTION

Line 2015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2011:
2012: EXCEPTION
2013: WHEN OTHERS
2014: THEN
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' );

Line 2058: l_return := FND_API.G_RET_STS_ERROR;

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

Line 2067: x_return_status := FND_API.G_RET_STS_SUCCESS;

2063: END IF;
2064:
2065: x_request_id := l_request_id;
2066:
2067: x_return_status := FND_API.G_RET_STS_SUCCESS;
2068:
2069: DEBUG( 'Exiting SUBMIT_REQUEST' );
2070:
2071: EXCEPTION

Line 2074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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