DBA Data[Home] [Help]

APPS.WIP_WS_DL_UTIL dependencies on FND_MESSAGE

Line 329: fnd_message.SET_NAME('WIP', 'WIP_WS_DL_MULTIPLE');

325: open c_num_customers(p_org_id, p_wip_entity_id);
326: fetch c_num_customers into l_count;
327: close c_num_customers;
328: if (l_count > 1 ) then
329: fnd_message.SET_NAME('WIP', 'WIP_WS_DL_MULTIPLE');
330: return fnd_message.GET;
331: elsif ( l_count = 1 ) then
332: open c_ustomers(p_org_id, p_wip_entity_id);
333: fetch c_ustomers into l_name;

Line 330: return fnd_message.GET;

326: fetch c_num_customers into l_count;
327: close c_num_customers;
328: if (l_count > 1 ) then
329: fnd_message.SET_NAME('WIP', 'WIP_WS_DL_MULTIPLE');
330: return fnd_message.GET;
331: elsif ( l_count = 1 ) then
332: open c_ustomers(p_org_id, p_wip_entity_id);
333: fetch c_ustomers into l_name;
334: close c_ustomers;

Line 382: fnd_message.SET_NAME('WIP', 'WIP_WS_DL_MULTIPLE');

378: open c_num_sales_orders(p_org_id, p_wip_entity_id);
379: fetch c_num_sales_orders into l_count;
380: close c_num_sales_orders;
381: if (l_count > 1 ) then
382: fnd_message.SET_NAME('WIP', 'WIP_WS_DL_MULTIPLE');
383: return fnd_message.GET;
384: elsif ( l_count = 1 ) then
385: open c_sales_orders(p_org_id, p_wip_entity_id);
386: fetch c_sales_orders into l_name;

Line 383: return fnd_message.GET;

379: fetch c_num_sales_orders into l_count;
380: close c_num_sales_orders;
381: if (l_count > 1 ) then
382: fnd_message.SET_NAME('WIP', 'WIP_WS_DL_MULTIPLE');
383: return fnd_message.GET;
384: elsif ( l_count = 1 ) then
385: open c_sales_orders(p_org_id, p_wip_entity_id);
386: fetch c_sales_orders into l_name;
387: close c_sales_orders;

Line 491: fnd_message.SET_NAME('WIP', 'WIP_WS_DL_MULTIPLE');

487: open c_num_exceptions(p_wip_entity_id, p_op_seq);
488: fetch c_num_exceptions into l_count;
489: close c_num_exceptions;
490: if (l_count > 1 ) then
491: fnd_message.SET_NAME('WIP', 'WIP_WS_DL_MULTIPLE');
492: return fnd_message.GET;
493: elsif ( l_count = 1 ) then
494: open c_exceptions(p_wip_entity_id, p_op_seq);
495: fetch c_exceptions into l_name;

Line 492: return fnd_message.GET;

488: fetch c_num_exceptions into l_count;
489: close c_num_exceptions;
490: if (l_count > 1 ) then
491: fnd_message.SET_NAME('WIP', 'WIP_WS_DL_MULTIPLE');
492: return fnd_message.GET;
493: elsif ( l_count = 1 ) then
494: open c_exceptions(p_wip_entity_id, p_op_seq);
495: fetch c_exceptions into l_name;
496: close c_exceptions;

Line 570: fnd_message.SET_NAME('WIP', 'WIP_WS_DL_MULTIPLE');

566: open c_num_setups(p_wip_entity_id, p_op_seq);
567: fetch c_num_setups into l_count;
568: close c_num_setups;
569: if (l_count > 1 ) then
570: fnd_message.SET_NAME('WIP', 'WIP_WS_DL_MULTIPLE');
571: return fnd_message.GET;
572: elsif ( l_count = 1 ) then
573: open c_setups(p_wip_entity_id, p_op_seq);
574: fetch c_setups into l_name;

Line 571: return fnd_message.GET;

567: fetch c_num_setups into l_count;
568: close c_num_setups;
569: if (l_count > 1 ) then
570: fnd_message.SET_NAME('WIP', 'WIP_WS_DL_MULTIPLE');
571: return fnd_message.GET;
572: elsif ( l_count = 1 ) then
573: open c_setups(p_wip_entity_id, p_op_seq);
574: fetch c_setups into l_name;
575: close c_setups;

Line 1471: fnd_message.SET_NAME('WIP', 'WS_JOBOP_ALR_EXPEDITED');

1467: where wdj.wip_entity_id = p_wip_entity_id;
1468: commit;
1469: else
1470: x_status := 'A';
1471: fnd_message.SET_NAME('WIP', 'WS_JOBOP_ALR_EXPEDITED');
1472: fnd_msg_pub.Add;
1473: end if;
1474:
1475: End;

Line 1506: fnd_message.SET_NAME('WIP', 'WS_JOBOP_ALR_UNEXPEDITED');

1502: where wdj.wip_entity_id = p_wip_entity_id;
1503: commit;
1504: else
1505: x_status := 'A';
1506: fnd_message.SET_NAME('WIP', 'WS_JOBOP_ALR_UNEXPEDITED');
1507: fnd_msg_pub.Add;
1508: end if;
1509:
1510: End;