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_WAVEPLAN_TASKS_PVT

Line 142: p_transaction_temp_id_tbl OUT NOCOPY wms_waveplan_tasks_pvt.transaction_temp_table_type,

138: END DEBUG;
139:
140: PROCEDURE GET_TRANSACTION_TASK_IDS
141: ( p_task_type_id IN NUMBER,
142: p_transaction_temp_id_tbl OUT NOCOPY wms_waveplan_tasks_pvt.transaction_temp_table_type,
143: p_task_type_id_table OUT NOCOPY wms_waveplan_tasks_pvt.task_type_id_table_type,
144: x_return_status OUT NOCOPY VARCHAR2,
145: x_return_message OUT NOCOPY VARCHAR2
146: )

Line 143: p_task_type_id_table OUT NOCOPY wms_waveplan_tasks_pvt.task_type_id_table_type,

139:
140: PROCEDURE GET_TRANSACTION_TASK_IDS
141: ( p_task_type_id IN NUMBER,
142: p_transaction_temp_id_tbl OUT NOCOPY wms_waveplan_tasks_pvt.transaction_temp_table_type,
143: p_task_type_id_table OUT NOCOPY wms_waveplan_tasks_pvt.task_type_id_table_type,
144: x_return_status OUT NOCOPY VARCHAR2,
145: x_return_message OUT NOCOPY VARCHAR2
146: )
147: IS

Line 193: l_transaction_temp_id_tbl wms_waveplan_tasks_pvt.transaction_temp_table_type;

189: ( x_return_status OUT NOCOPY VARCHAR2,
190: x_return_message OUT NOCOPY VARCHAR2
191: )
192: IS
193: l_transaction_temp_id_tbl wms_waveplan_tasks_pvt.transaction_temp_table_type;
194: l_task_type_id_table wms_waveplan_tasks_pvt.task_type_id_table_type;
195: l_result wms_waveplan_tasks_pvt.result_table_type;
196: l_message wms_waveplan_tasks_pvt.message_table_type;
197: l_task_id wms_waveplan_tasks_pvt.task_id_table_type;

Line 194: l_task_type_id_table wms_waveplan_tasks_pvt.task_type_id_table_type;

190: x_return_message OUT NOCOPY VARCHAR2
191: )
192: IS
193: l_transaction_temp_id_tbl wms_waveplan_tasks_pvt.transaction_temp_table_type;
194: l_task_type_id_table wms_waveplan_tasks_pvt.task_type_id_table_type;
195: l_result wms_waveplan_tasks_pvt.result_table_type;
196: l_message wms_waveplan_tasks_pvt.message_table_type;
197: l_task_id wms_waveplan_tasks_pvt.task_id_table_type;
198: l_return_msg VARCHAR2( 120);

Line 195: l_result wms_waveplan_tasks_pvt.result_table_type;

191: )
192: IS
193: l_transaction_temp_id_tbl wms_waveplan_tasks_pvt.transaction_temp_table_type;
194: l_task_type_id_table wms_waveplan_tasks_pvt.task_type_id_table_type;
195: l_result wms_waveplan_tasks_pvt.result_table_type;
196: l_message wms_waveplan_tasks_pvt.message_table_type;
197: l_task_id wms_waveplan_tasks_pvt.task_id_table_type;
198: l_return_msg VARCHAR2( 120);
199: l_msg_count NUMBER;

Line 196: l_message wms_waveplan_tasks_pvt.message_table_type;

192: IS
193: l_transaction_temp_id_tbl wms_waveplan_tasks_pvt.transaction_temp_table_type;
194: l_task_type_id_table wms_waveplan_tasks_pvt.task_type_id_table_type;
195: l_result wms_waveplan_tasks_pvt.result_table_type;
196: l_message wms_waveplan_tasks_pvt.message_table_type;
197: l_task_id wms_waveplan_tasks_pvt.task_id_table_type;
198: l_return_msg VARCHAR2( 120);
199: l_msg_count NUMBER;
200: l_task_type_id NUMBER;

Line 197: l_task_id wms_waveplan_tasks_pvt.task_id_table_type;

193: l_transaction_temp_id_tbl wms_waveplan_tasks_pvt.transaction_temp_table_type;
194: l_task_type_id_table wms_waveplan_tasks_pvt.task_type_id_table_type;
195: l_result wms_waveplan_tasks_pvt.result_table_type;
196: l_message wms_waveplan_tasks_pvt.message_table_type;
197: l_task_id wms_waveplan_tasks_pvt.task_id_table_type;
198: l_return_msg VARCHAR2( 120);
199: l_msg_count NUMBER;
200: l_task_type_id NUMBER;
201: l_return_message VARCHAR2( 4000 );

Line 265: DEBUG( 'Calling WMS_WAVEPLAN_TASKS_PVT.UPDATE_TASK');

261: l_person_resource_code := NULL;
262: END IF;
263: /* End of Bug 5485730 */
264: --call update task
265: DEBUG( 'Calling WMS_WAVEPLAN_TASKS_PVT.UPDATE_TASK');
266: DEBUG( 'Following are the input parameters');
267: DEBUG( 'p_employee => ' || l_employee);
268: DEBUG( 'p_employee_id => ' || l_employee_id);
269: DEBUG( 'p_user_task_type => ' || l_user_task_type);

Line 288: wms_waveplan_tasks_pvt.update_task

284: ELSE
285: DEBUG( 'p_force_employee_change => FALSE');
286: END IF;
287:
288: wms_waveplan_tasks_pvt.update_task
289: (
290: p_transaction_temp_id => l_transaction_temp_id_tbl,
291: p_task_type_id => l_task_type_id_table,
292: p_employee => l_employee,

Line 314: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.UPDATE_TASK return status = '|| l_return_status );

310: x_return_msg => l_return_msg,
311: x_msg_count => l_msg_count
312: );
313:
314: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.UPDATE_TASK return status = '|| l_return_status );
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:

Line 315: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.UPDATE_TASK return message = '|| l_return_msg );

311: x_msg_count => l_msg_count
312: );
313:
314: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.UPDATE_TASK return status = '|| l_return_status );
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

Line 322: DEBUG (' Error in WMS_WAVEPLAN_TASKS_PVT.UPDATE_TASK ' || l_return_msg );

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. '
325: || 'Error message is ' || l_return_msg;
326: return;

Line 324: x_return_message:= 'Error in wms_waveplan_tasks_pvt.update_task. '

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;
328: END IF;

Line 351: l_transaction_temp_id_tbl wms_waveplan_tasks_pvt.transaction_temp_table_type;

347: ( x_return_status OUT NOCOPY VARCHAR2,
348: x_return_message OUT NOCOPY VARCHAR2
349: )
350: IS
351: l_transaction_temp_id_tbl wms_waveplan_tasks_pvt.transaction_temp_table_type;
352: l_task_type_id_table wms_waveplan_tasks_pvt.task_type_id_table_type;
353: l_result wms_waveplan_tasks_pvt.result_table_type;
354: l_message wms_waveplan_tasks_pvt.message_table_type;
355: l_task_id wms_waveplan_tasks_pvt.task_id_table_type;

Line 352: l_task_type_id_table wms_waveplan_tasks_pvt.task_type_id_table_type;

348: x_return_message OUT NOCOPY VARCHAR2
349: )
350: IS
351: l_transaction_temp_id_tbl wms_waveplan_tasks_pvt.transaction_temp_table_type;
352: l_task_type_id_table wms_waveplan_tasks_pvt.task_type_id_table_type;
353: l_result wms_waveplan_tasks_pvt.result_table_type;
354: l_message wms_waveplan_tasks_pvt.message_table_type;
355: l_task_id wms_waveplan_tasks_pvt.task_id_table_type;
356: l_return_msg VARCHAR2( 120);

Line 353: l_result wms_waveplan_tasks_pvt.result_table_type;

349: )
350: IS
351: l_transaction_temp_id_tbl wms_waveplan_tasks_pvt.transaction_temp_table_type;
352: l_task_type_id_table wms_waveplan_tasks_pvt.task_type_id_table_type;
353: l_result wms_waveplan_tasks_pvt.result_table_type;
354: l_message wms_waveplan_tasks_pvt.message_table_type;
355: l_task_id wms_waveplan_tasks_pvt.task_id_table_type;
356: l_return_msg VARCHAR2( 120);
357: l_msg_count NUMBER;

Line 354: l_message wms_waveplan_tasks_pvt.message_table_type;

350: IS
351: l_transaction_temp_id_tbl wms_waveplan_tasks_pvt.transaction_temp_table_type;
352: l_task_type_id_table wms_waveplan_tasks_pvt.task_type_id_table_type;
353: l_result wms_waveplan_tasks_pvt.result_table_type;
354: l_message wms_waveplan_tasks_pvt.message_table_type;
355: l_task_id wms_waveplan_tasks_pvt.task_id_table_type;
356: l_return_msg VARCHAR2( 120);
357: l_msg_count NUMBER;
358: l_task_type_id NUMBER;

Line 355: l_task_id wms_waveplan_tasks_pvt.task_id_table_type;

351: l_transaction_temp_id_tbl wms_waveplan_tasks_pvt.transaction_temp_table_type;
352: l_task_type_id_table wms_waveplan_tasks_pvt.task_type_id_table_type;
353: l_result wms_waveplan_tasks_pvt.result_table_type;
354: l_message wms_waveplan_tasks_pvt.message_table_type;
355: l_task_id wms_waveplan_tasks_pvt.task_id_table_type;
356: l_return_msg VARCHAR2( 120);
357: l_msg_count NUMBER;
358: l_task_type_id NUMBER;
359: l_return_message VARCHAR2( 4000 );

Line 410: DEBUG( 'Calling WMS_WAVEPLAN_TASKS_PVT.CANCEL_TASK');

406:
407: IF ( ( l_transaction_temp_id_tbl.count > 0 ) and ( l_task_type_id_table.count > 0 ) )
408: THEN
409: --call update task
410: DEBUG( 'Calling WMS_WAVEPLAN_TASKS_PVT.CANCEL_TASK');
411: IF (wms_plan_tasks_pvt.g_include_crossdock ) THEN
412: DEBUG( 'global variable wms_plan_tasks_pvt.g_include_crossdock = TRUE ');
413: ELSE
414: DEBUG( 'global variable wms_plan_tasks_pvt.g_include_crossdock = FALSE ');

Line 417: wms_waveplan_tasks_pvt.cancel_task

413: ELSE
414: DEBUG( 'global variable wms_plan_tasks_pvt.g_include_crossdock = FALSE ');
415: END IF;
416:
417: wms_waveplan_tasks_pvt.cancel_task
418: (
419: p_transaction_temp_id => l_transaction_temp_id_tbl,
420: p_task_type_id => l_task_type_id_table,
421: p_is_crossdock => wms_plan_tasks_pvt.g_include_crossdock, --Bug#6075802.

Line 430: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.CANCEL_TASK return status = '|| l_return_status );

426: x_return_msg => l_return_msg,
427: x_msg_count => l_msg_count
428: );
429:
430: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.CANCEL_TASK return status = '|| l_return_status );
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:

Line 431: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.CANCEL_TASK return message = '|| l_return_msg );

427: x_msg_count => l_msg_count
428: );
429:
430: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.CANCEL_TASK return status = '|| l_return_status );
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

Line 438: DEBUG (' Error in WMS_WAVEPLAN_TASKS_PVT.CANCEL_TASK ' || l_return_msg );

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. '
441: || 'Error message is ' || l_return_msg;
442: return;

Line 440: x_return_message:= 'Error in wms_waveplan_tasks_pvt.cancel_task. '

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;
444: END IF;

Line 1191: DEBUG( 'Calling wms_waveplan_tasks_pvt.save_tasks ');

1187: END IF;
1188:
1189: IF l_rowcount <> 0
1190: THEN
1191: DEBUG( 'Calling wms_waveplan_tasks_pvt.save_tasks ');
1192: DEBUG( 'Input Parameters passed');
1193: DEBUG( 'p_commit => TRUE');
1194: DEBUG( 'p_user_id => ' || fnd_global.user_id);
1195: DEBUG( 'p_login_id => ' || fnd_global.login_id);

Line 1197: wms_waveplan_tasks_pvt.save_tasks

1193: DEBUG( 'p_commit => TRUE');
1194: DEBUG( 'p_user_id => ' || fnd_global.user_id);
1195: DEBUG( 'p_login_id => ' || fnd_global.login_id);
1196:
1197: wms_waveplan_tasks_pvt.save_tasks
1198: (
1199: p_task_action => p_action,
1200: p_commit => TRUE,
1201: p_user_id => fnd_global.user_id,

Line 1209: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.SAVE_TASKS return Status = ' || l_return_status );

1205: x_msg_data => l_msg_data,
1206: x_msg_count => l_msg_count
1207: );
1208:
1209: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.SAVE_TASKS return Status = ' || l_return_status );
1210: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.SAVE_TASKS l_save_count = ' || l_save_count );
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:

Line 1210: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.SAVE_TASKS l_save_count = ' || l_save_count );

1206: x_msg_count => l_msg_count
1207: );
1208:
1209: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.SAVE_TASKS return Status = ' || l_return_status );
1210: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.SAVE_TASKS l_save_count = ' || l_save_count );
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:

Line 1211: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.SAVE_TASKS l_msg_data = ' || l_msg_data );

1207: );
1208:
1209: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.SAVE_TASKS return Status = ' || l_return_status );
1210: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.SAVE_TASKS l_save_count = ' || l_save_count );
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

Line 1212: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.SAVE_TASKS l_msg_count = ' || l_msg_count );

1208:
1209: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.SAVE_TASKS return Status = ' || l_return_status );
1210: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.SAVE_TASKS l_save_count = ' || l_save_count );
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

Line 1483: DEBUG ( 'Calling WMS_WAVEPLAN_TASKS_PVT.QUERY_TASKS' );

1479: || 'Error message = ' || l_return_message ;
1480: return;
1481: END IF;
1482:
1483: DEBUG ( 'Calling WMS_WAVEPLAN_TASKS_PVT.QUERY_TASKS' );
1484: DEBUG ( 'Input parameters passed');
1485: DEBUG( 'p_add => NULL' );
1486: DEBUG( 'p_organization_id => ' || l_organization_id );
1487: DEBUG( 'p_subinventory_code => ' || l_subinventory );

Line 1750: wms_waveplan_tasks_pvt.query_tasks

1746: DEBUG( 'p_op_plan_id => ' || l_op_plan_id );
1747: DEBUG( 'p_time_till_shipment => ' || l_time_till_shipment );
1748: DEBUG( 'p_time_till_shipment_uom_code => ' || l_time_till_shipment_uom_code );
1749:
1750: wms_waveplan_tasks_pvt.query_tasks
1751: ( p_add => NULL ,
1752: p_organization_id => l_organization_id,
1753: p_subinventory_code => l_subinventory,
1754: p_locator_id => l_locator_id,

Line 1857: DEBUG ( 'WMS_WAVEPLAN_TASKS_PVT.QUERY_TASKS x_return_status => ' || l_return_status );

1853: p_time_till_shipment => l_time_till_shipment,
1854: p_time_till_shipment_uom_code => l_time_till_shipment_uom_code
1855: );
1856:
1857: DEBUG ( 'WMS_WAVEPLAN_TASKS_PVT.QUERY_TASKS x_return_status => ' || l_return_status );
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:

Line 1858: DEBUG ( 'WMS_WAVEPLAN_TASKS_PVT.QUERY_TASKS x_msg_data => ' || l_msg_data);

1854: p_time_till_shipment_uom_code => l_time_till_shipment_uom_code
1855: );
1856:
1857: DEBUG ( 'WMS_WAVEPLAN_TASKS_PVT.QUERY_TASKS x_return_status => ' || l_return_status );
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

Line 1859: DEBUG ( 'WMS_WAVEPLAN_TASKS_PVT.QUERY_TASKS x_msg_count => ' || l_msg_count);

1855: );
1856:
1857: DEBUG ( 'WMS_WAVEPLAN_TASKS_PVT.QUERY_TASKS x_return_status => ' || l_return_status );
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

Line 1860: DEBUG ( 'WMS_WAVEPLAN_TASKS_PVT.QUERY_TASKS x_record_count => ' || l_record_count);

1856:
1857: DEBUG ( 'WMS_WAVEPLAN_TASKS_PVT.QUERY_TASKS x_return_status => ' || l_return_status );
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 ' );

Line 1864: DEBUG (' Error in WMS_WAVEPLAN_TASKS_PVT.QUERY_TASKS ' );

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'
1867: || 'Error message is ' || l_return_message;
1868: return;

Line 1866: x_return_message:= 'WMS_WAVEPLAN_TASKS_PVT.QUERY_TASKS returned with Error status'

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;
1870: