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 138: p_transaction_temp_id_tbl OUT NOCOPY wms_waveplan_tasks_pvt.transaction_temp_table_type,

134: END DEBUG;
135:
136: PROCEDURE GET_TRANSACTION_TASK_IDS
137: ( p_task_type_id IN NUMBER,
138: p_transaction_temp_id_tbl OUT NOCOPY wms_waveplan_tasks_pvt.transaction_temp_table_type,
139: p_task_type_id_table OUT NOCOPY wms_waveplan_tasks_pvt.task_type_id_table_type,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_return_message OUT NOCOPY VARCHAR2
142: )

Line 139: p_task_type_id_table OUT NOCOPY wms_waveplan_tasks_pvt.task_type_id_table_type,

135:
136: PROCEDURE GET_TRANSACTION_TASK_IDS
137: ( p_task_type_id IN NUMBER,
138: p_transaction_temp_id_tbl OUT NOCOPY wms_waveplan_tasks_pvt.transaction_temp_table_type,
139: p_task_type_id_table OUT NOCOPY wms_waveplan_tasks_pvt.task_type_id_table_type,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_return_message OUT NOCOPY VARCHAR2
142: )
143: IS

Line 189: l_transaction_temp_id_tbl wms_waveplan_tasks_pvt.transaction_temp_table_type;

185: ( x_return_status OUT NOCOPY VARCHAR2,
186: x_return_message OUT NOCOPY VARCHAR2
187: )
188: IS
189: l_transaction_temp_id_tbl wms_waveplan_tasks_pvt.transaction_temp_table_type;
190: l_task_type_id_table wms_waveplan_tasks_pvt.task_type_id_table_type;
191: l_result wms_waveplan_tasks_pvt.result_table_type;
192: l_message wms_waveplan_tasks_pvt.message_table_type;
193: l_task_id wms_waveplan_tasks_pvt.task_id_table_type;

Line 190: l_task_type_id_table wms_waveplan_tasks_pvt.task_type_id_table_type;

186: x_return_message OUT NOCOPY VARCHAR2
187: )
188: IS
189: l_transaction_temp_id_tbl wms_waveplan_tasks_pvt.transaction_temp_table_type;
190: l_task_type_id_table wms_waveplan_tasks_pvt.task_type_id_table_type;
191: l_result wms_waveplan_tasks_pvt.result_table_type;
192: l_message wms_waveplan_tasks_pvt.message_table_type;
193: l_task_id wms_waveplan_tasks_pvt.task_id_table_type;
194: l_return_msg VARCHAR2( 120);

Line 191: l_result wms_waveplan_tasks_pvt.result_table_type;

187: )
188: IS
189: l_transaction_temp_id_tbl wms_waveplan_tasks_pvt.transaction_temp_table_type;
190: l_task_type_id_table wms_waveplan_tasks_pvt.task_type_id_table_type;
191: l_result wms_waveplan_tasks_pvt.result_table_type;
192: l_message wms_waveplan_tasks_pvt.message_table_type;
193: l_task_id wms_waveplan_tasks_pvt.task_id_table_type;
194: l_return_msg VARCHAR2( 120);
195: l_msg_count NUMBER;

Line 192: l_message wms_waveplan_tasks_pvt.message_table_type;

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

Line 193: l_task_id wms_waveplan_tasks_pvt.task_id_table_type;

189: l_transaction_temp_id_tbl wms_waveplan_tasks_pvt.transaction_temp_table_type;
190: l_task_type_id_table wms_waveplan_tasks_pvt.task_type_id_table_type;
191: l_result wms_waveplan_tasks_pvt.result_table_type;
192: l_message wms_waveplan_tasks_pvt.message_table_type;
193: l_task_id wms_waveplan_tasks_pvt.task_id_table_type;
194: l_return_msg VARCHAR2( 120);
195: l_msg_count NUMBER;
196: l_task_type_id NUMBER;
197: l_return_message VARCHAR2( 4000 );

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

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

Line 284: wms_waveplan_tasks_pvt.update_task

280: ELSE
281: DEBUG( 'p_force_employee_change => FALSE');
282: END IF;
283:
284: wms_waveplan_tasks_pvt.update_task
285: (
286: p_transaction_temp_id => l_transaction_temp_id_tbl,
287: p_task_type_id => l_task_type_id_table,
288: p_employee => l_employee,

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

306: x_return_msg => l_return_msg,
307: x_msg_count => l_msg_count
308: );
309:
310: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.UPDATE_TASK return status = '|| l_return_status );
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:

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

307: x_msg_count => l_msg_count
308: );
309:
310: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.UPDATE_TASK return status = '|| l_return_status );
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

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

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

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

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

Line 347: l_transaction_temp_id_tbl wms_waveplan_tasks_pvt.transaction_temp_table_type;

343: ( x_return_status OUT NOCOPY VARCHAR2,
344: x_return_message OUT NOCOPY VARCHAR2
345: )
346: IS
347: l_transaction_temp_id_tbl wms_waveplan_tasks_pvt.transaction_temp_table_type;
348: l_task_type_id_table wms_waveplan_tasks_pvt.task_type_id_table_type;
349: l_result wms_waveplan_tasks_pvt.result_table_type;
350: l_message wms_waveplan_tasks_pvt.message_table_type;
351: l_task_id wms_waveplan_tasks_pvt.task_id_table_type;

Line 348: l_task_type_id_table wms_waveplan_tasks_pvt.task_type_id_table_type;

344: x_return_message OUT NOCOPY VARCHAR2
345: )
346: IS
347: l_transaction_temp_id_tbl wms_waveplan_tasks_pvt.transaction_temp_table_type;
348: l_task_type_id_table wms_waveplan_tasks_pvt.task_type_id_table_type;
349: l_result wms_waveplan_tasks_pvt.result_table_type;
350: l_message wms_waveplan_tasks_pvt.message_table_type;
351: l_task_id wms_waveplan_tasks_pvt.task_id_table_type;
352: l_return_msg VARCHAR2( 120);

Line 349: l_result wms_waveplan_tasks_pvt.result_table_type;

345: )
346: IS
347: l_transaction_temp_id_tbl wms_waveplan_tasks_pvt.transaction_temp_table_type;
348: l_task_type_id_table wms_waveplan_tasks_pvt.task_type_id_table_type;
349: l_result wms_waveplan_tasks_pvt.result_table_type;
350: l_message wms_waveplan_tasks_pvt.message_table_type;
351: l_task_id wms_waveplan_tasks_pvt.task_id_table_type;
352: l_return_msg VARCHAR2( 120);
353: l_msg_count NUMBER;

Line 350: l_message wms_waveplan_tasks_pvt.message_table_type;

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

Line 351: l_task_id wms_waveplan_tasks_pvt.task_id_table_type;

347: l_transaction_temp_id_tbl wms_waveplan_tasks_pvt.transaction_temp_table_type;
348: l_task_type_id_table wms_waveplan_tasks_pvt.task_type_id_table_type;
349: l_result wms_waveplan_tasks_pvt.result_table_type;
350: l_message wms_waveplan_tasks_pvt.message_table_type;
351: l_task_id wms_waveplan_tasks_pvt.task_id_table_type;
352: l_return_msg VARCHAR2( 120);
353: l_msg_count NUMBER;
354: l_task_type_id NUMBER;
355: l_return_message VARCHAR2( 4000 );

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

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

Line 413: wms_waveplan_tasks_pvt.cancel_task

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

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

422: x_return_msg => l_return_msg,
423: x_msg_count => l_msg_count
424: );
425:
426: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.CANCEL_TASK return status = '|| l_return_status );
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:

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

423: x_msg_count => l_msg_count
424: );
425:
426: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.CANCEL_TASK return status = '|| l_return_status );
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

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

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

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

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

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

1162: END IF;
1163:
1164: IF l_rowcount <> 0
1165: THEN
1166: DEBUG( 'Calling wms_waveplan_tasks_pvt.save_tasks ');
1167: DEBUG( 'Input Parameters passed');
1168: DEBUG( 'p_commit => TRUE');
1169: DEBUG( 'p_user_id => ' || fnd_global.user_id);
1170: DEBUG( 'p_login_id => ' || fnd_global.login_id);

Line 1172: wms_waveplan_tasks_pvt.save_tasks

1168: DEBUG( 'p_commit => TRUE');
1169: DEBUG( 'p_user_id => ' || fnd_global.user_id);
1170: DEBUG( 'p_login_id => ' || fnd_global.login_id);
1171:
1172: wms_waveplan_tasks_pvt.save_tasks
1173: (
1174: p_task_action => p_action,
1175: p_commit => TRUE,
1176: p_user_id => fnd_global.user_id,

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

1180: x_msg_data => l_msg_data,
1181: x_msg_count => l_msg_count
1182: );
1183:
1184: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.SAVE_TASKS return Status = ' || l_return_status );
1185: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.SAVE_TASKS l_save_count = ' || l_save_count );
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:

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

1181: x_msg_count => l_msg_count
1182: );
1183:
1184: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.SAVE_TASKS return Status = ' || l_return_status );
1185: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.SAVE_TASKS l_save_count = ' || l_save_count );
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:

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

1182: );
1183:
1184: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.SAVE_TASKS return Status = ' || l_return_status );
1185: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.SAVE_TASKS l_save_count = ' || l_save_count );
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

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

1183:
1184: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.SAVE_TASKS return Status = ' || l_return_status );
1185: DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.SAVE_TASKS l_save_count = ' || l_save_count );
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

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

1454: || 'Error message = ' || l_return_message ;
1455: return;
1456: END IF;
1457:
1458: DEBUG ( 'Calling WMS_WAVEPLAN_TASKS_PVT.QUERY_TASKS' );
1459: DEBUG ( 'Input parameters passed');
1460: DEBUG( 'p_add => NULL' );
1461: DEBUG( 'p_organization_id => ' || l_organization_id );
1462: DEBUG( 'p_subinventory_code => ' || l_subinventory );

Line 1723: wms_waveplan_tasks_pvt.query_tasks

1719: DEBUG( 'p_activity_id => ' || l_op_plan_activity_id );
1720: DEBUG( 'p_plan_type_id => ' || l_op_plan_type_id );
1721: DEBUG( 'p_op_plan_id => ' || l_op_plan_id );
1722:
1723: wms_waveplan_tasks_pvt.query_tasks
1724: ( p_add => NULL ,
1725: p_organization_id => l_organization_id,
1726: p_subinventory_code => l_subinventory,
1727: p_locator_id => l_locator_id,

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

1822: p_plan_type_id => l_op_plan_type_id,
1823: p_op_plan_id => l_op_plan_id
1824: );
1825:
1826: DEBUG ( 'WMS_WAVEPLAN_TASKS_PVT.QUERY_TASKS x_return_status => ' || l_return_status );
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:

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

1823: p_op_plan_id => l_op_plan_id
1824: );
1825:
1826: DEBUG ( 'WMS_WAVEPLAN_TASKS_PVT.QUERY_TASKS x_return_status => ' || l_return_status );
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

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

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

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

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

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

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

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

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