9987: l_device_id NUMBER;
9988: BEGIN
9989: IF g_cannot_update_putaway IS NULL
9990: THEN
9991: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_PUTAWAY_TASK');
9992: g_cannot_update_putaway := fnd_message.get;
9993: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_STAGING_MOVE');
9994: g_cannot_update_staging_move := fnd_message.get;
9995: fnd_message.set_name ('WMS', 'WMS_TASK_UPDATED');
9988: BEGIN
9989: IF g_cannot_update_putaway IS NULL
9990: THEN
9991: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_PUTAWAY_TASK');
9992: g_cannot_update_putaway := fnd_message.get;
9993: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_STAGING_MOVE');
9994: g_cannot_update_staging_move := fnd_message.get;
9995: fnd_message.set_name ('WMS', 'WMS_TASK_UPDATED');
9996: g_task_updated := fnd_message.get;
9989: IF g_cannot_update_putaway IS NULL
9990: THEN
9991: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_PUTAWAY_TASK');
9992: g_cannot_update_putaway := fnd_message.get;
9993: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_STAGING_MOVE');
9994: g_cannot_update_staging_move := fnd_message.get;
9995: fnd_message.set_name ('WMS', 'WMS_TASK_UPDATED');
9996: g_task_updated := fnd_message.get;
9997: fnd_message.set_name ('WMS', 'WMS_CANNOT_UNRELEASE_CC');
9990: THEN
9991: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_PUTAWAY_TASK');
9992: g_cannot_update_putaway := fnd_message.get;
9993: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_STAGING_MOVE');
9994: g_cannot_update_staging_move := fnd_message.get;
9995: fnd_message.set_name ('WMS', 'WMS_TASK_UPDATED');
9996: g_task_updated := fnd_message.get;
9997: fnd_message.set_name ('WMS', 'WMS_CANNOT_UNRELEASE_CC');
9998: g_cannot_unrelease_cc := fnd_message.get;
9991: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_PUTAWAY_TASK');
9992: g_cannot_update_putaway := fnd_message.get;
9993: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_STAGING_MOVE');
9994: g_cannot_update_staging_move := fnd_message.get;
9995: fnd_message.set_name ('WMS', 'WMS_TASK_UPDATED');
9996: g_task_updated := fnd_message.get;
9997: fnd_message.set_name ('WMS', 'WMS_CANNOT_UNRELEASE_CC');
9998: g_cannot_unrelease_cc := fnd_message.get;
9999: END IF;
9992: g_cannot_update_putaway := fnd_message.get;
9993: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_STAGING_MOVE');
9994: g_cannot_update_staging_move := fnd_message.get;
9995: fnd_message.set_name ('WMS', 'WMS_TASK_UPDATED');
9996: g_task_updated := fnd_message.get;
9997: fnd_message.set_name ('WMS', 'WMS_CANNOT_UNRELEASE_CC');
9998: g_cannot_unrelease_cc := fnd_message.get;
9999: END IF;
10000:
9993: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_STAGING_MOVE');
9994: g_cannot_update_staging_move := fnd_message.get;
9995: fnd_message.set_name ('WMS', 'WMS_TASK_UPDATED');
9996: g_task_updated := fnd_message.get;
9997: fnd_message.set_name ('WMS', 'WMS_CANNOT_UNRELEASE_CC');
9998: g_cannot_unrelease_cc := fnd_message.get;
9999: END IF;
10000:
10001: FORALL i IN p_transaction_temp_id.FIRST .. p_transaction_temp_id.LAST
9994: g_cannot_update_staging_move := fnd_message.get;
9995: fnd_message.set_name ('WMS', 'WMS_TASK_UPDATED');
9996: g_task_updated := fnd_message.get;
9997: fnd_message.set_name ('WMS', 'WMS_CANNOT_UNRELEASE_CC');
9998: g_cannot_unrelease_cc := fnd_message.get;
9999: END IF;
10000:
10001: FORALL i IN p_transaction_temp_id.FIRST .. p_transaction_temp_id.LAST
10002: UPDATE wms_waveplan_tasks_temp
10057: THEN
10058: FOR i IN
10059: l_transaction_temp_ids.FIRST .. l_transaction_temp_ids.LAST
10060: LOOP
10061: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_STATUS');
10062: fnd_message.set_token ('FROM_STATUS', l_statuses (i));
10063: fnd_message.set_token ('TO_STATUS', p_to_status);
10064: l_messages (i) := fnd_message.get;
10065: END LOOP;
10058: FOR i IN
10059: l_transaction_temp_ids.FIRST .. l_transaction_temp_ids.LAST
10060: LOOP
10061: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_STATUS');
10062: fnd_message.set_token ('FROM_STATUS', l_statuses (i));
10063: fnd_message.set_token ('TO_STATUS', p_to_status);
10064: l_messages (i) := fnd_message.get;
10065: END LOOP;
10066:
10059: l_transaction_temp_ids.FIRST .. l_transaction_temp_ids.LAST
10060: LOOP
10061: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_STATUS');
10062: fnd_message.set_token ('FROM_STATUS', l_statuses (i));
10063: fnd_message.set_token ('TO_STATUS', p_to_status);
10064: l_messages (i) := fnd_message.get;
10065: END LOOP;
10066:
10067: FORALL i IN l_transaction_temp_ids.FIRST .. l_transaction_temp_ids.LAST
10060: LOOP
10061: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_STATUS');
10062: fnd_message.set_token ('FROM_STATUS', l_statuses (i));
10063: fnd_message.set_token ('TO_STATUS', p_to_status);
10064: l_messages (i) := fnd_message.get;
10065: END LOOP;
10066:
10067: FORALL i IN l_transaction_temp_ids.FIRST .. l_transaction_temp_ids.LAST
10068: UPDATE wms_waveplan_tasks_temp
10105: --BUG: 4707588 (Picking message from msg dictionary)
10106: FOR i IN
10107: l_transaction_temp_ids.FIRST .. l_transaction_temp_ids.LAST
10108: LOOP
10109: fnd_message.set_name ('WMS', 'WMS_GROUP_TASKS_CANNOT_UPDATE');
10110: l_messages (i) := fnd_message.get;
10111: END LOOP;
10112:
10113:
10106: FOR i IN
10107: l_transaction_temp_ids.FIRST .. l_transaction_temp_ids.LAST
10108: LOOP
10109: fnd_message.set_name ('WMS', 'WMS_GROUP_TASKS_CANNOT_UPDATE');
10110: l_messages (i) := fnd_message.get;
10111: END LOOP;
10112:
10113:
10114: FORALL i IN l_transaction_temp_ids.FIRST .. l_transaction_temp_ids.LAST
10149:
10150: -- Employee eligibility validation
10151: IF p_employee_id IS NOT NULL AND NOT p_force_employee_change
10152: THEN
10153: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_EMPLOYEE');
10154: fnd_message.set_token ('EMPLOYEE', p_employee);
10155: l_message := fnd_message.get;
10156:
10157: UPDATE wms_waveplan_tasks_temp wwtt
10150: -- Employee eligibility validation
10151: IF p_employee_id IS NOT NULL AND NOT p_force_employee_change
10152: THEN
10153: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_EMPLOYEE');
10154: fnd_message.set_token ('EMPLOYEE', p_employee);
10155: l_message := fnd_message.get;
10156:
10157: UPDATE wms_waveplan_tasks_temp wwtt
10158: SET RESULT = 'E',
10151: IF p_employee_id IS NOT NULL AND NOT p_force_employee_change
10152: THEN
10153: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_EMPLOYEE');
10154: fnd_message.set_token ('EMPLOYEE', p_employee);
10155: l_message := fnd_message.get;
10156:
10157: UPDATE wms_waveplan_tasks_temp wwtt
10158: SET RESULT = 'E',
10159: error = l_message
10181: l_device_id
10182: ) = 'Y'
10183: )
10184: THEN
10185: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_EMPLOYEE');
10186: fnd_message.set_token ('EMPLOYEE', p_employee);
10187: l_message := fnd_message.get;
10188: if l_debug = 1 then
10189: DEBUG ('l_device_id : ' || l_device_id, ' Update_TAsk :');
10182: ) = 'Y'
10183: )
10184: THEN
10185: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_EMPLOYEE');
10186: fnd_message.set_token ('EMPLOYEE', p_employee);
10187: l_message := fnd_message.get;
10188: if l_debug = 1 then
10189: DEBUG ('l_device_id : ' || l_device_id, ' Update_TAsk :');
10190: DEBUG (' p_employee_id : ' || p_employee_id,
10183: )
10184: THEN
10185: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_EMPLOYEE');
10186: fnd_message.set_token ('EMPLOYEE', p_employee);
10187: l_message := fnd_message.get;
10188: if l_debug = 1 then
10189: DEBUG ('l_device_id : ' || l_device_id, ' Update_TAsk :');
10190: DEBUG (' p_employee_id : ' || p_employee_id,
10191: ' Update_TAsk :'
10243: THEN
10244: FOR i IN
10245: l_transaction_temp_ids.FIRST .. l_transaction_temp_ids.LAST
10246: LOOP
10247: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_USER_TASK_TYPE');
10248: fnd_message.set_token ('STATUS', l_statuses (i));
10249: l_messages (i) := fnd_message.get;
10250: END LOOP;
10251:
10244: FOR i IN
10245: l_transaction_temp_ids.FIRST .. l_transaction_temp_ids.LAST
10246: LOOP
10247: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_USER_TASK_TYPE');
10248: fnd_message.set_token ('STATUS', l_statuses (i));
10249: l_messages (i) := fnd_message.get;
10250: END LOOP;
10251:
10252: FORALL i IN l_transaction_temp_ids.FIRST .. l_transaction_temp_ids.LAST
10245: l_transaction_temp_ids.FIRST .. l_transaction_temp_ids.LAST
10246: LOOP
10247: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_USER_TASK_TYPE');
10248: fnd_message.set_token ('STATUS', l_statuses (i));
10249: l_messages (i) := fnd_message.get;
10250: END LOOP;
10251:
10252: FORALL i IN l_transaction_temp_ids.FIRST .. l_transaction_temp_ids.LAST
10253: UPDATE wms_waveplan_tasks_temp
10285: THEN
10286: FOR i IN
10287: l_transaction_temp_ids.FIRST .. l_transaction_temp_ids.LAST
10288: LOOP
10289: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_PRIORITY');
10290: fnd_message.set_token ('STATUS', l_statuses (i));
10291: l_messages (i) := fnd_message.get;
10292: END LOOP;
10293:
10286: FOR i IN
10287: l_transaction_temp_ids.FIRST .. l_transaction_temp_ids.LAST
10288: LOOP
10289: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_PRIORITY');
10290: fnd_message.set_token ('STATUS', l_statuses (i));
10291: l_messages (i) := fnd_message.get;
10292: END LOOP;
10293:
10294: FORALL i IN l_transaction_temp_ids.FIRST .. l_transaction_temp_ids.LAST
10287: l_transaction_temp_ids.FIRST .. l_transaction_temp_ids.LAST
10288: LOOP
10289: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_PRIORITY');
10290: fnd_message.set_token ('STATUS', l_statuses (i));
10291: l_messages (i) := fnd_message.get;
10292: END LOOP;
10293:
10294: FORALL i IN l_transaction_temp_ids.FIRST .. l_transaction_temp_ids.LAST
10295: UPDATE wms_waveplan_tasks_temp
10436: BEGIN
10437:
10438: /*IF g_cannot_update_putaway IS NULL
10439: THEN
10440: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_PUTAWAY_TASK');
10441: g_cannot_update_putaway := fnd_message.get;
10442: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_STAGING_MOVE');
10443: g_cannot_update_staging_move := fnd_message.get;
10444: fnd_message.set_name ('WMS', 'WMS_TASK_UPDATED');
10437:
10438: /*IF g_cannot_update_putaway IS NULL
10439: THEN
10440: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_PUTAWAY_TASK');
10441: g_cannot_update_putaway := fnd_message.get;
10442: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_STAGING_MOVE');
10443: g_cannot_update_staging_move := fnd_message.get;
10444: fnd_message.set_name ('WMS', 'WMS_TASK_UPDATED');
10445: g_task_updated := fnd_message.get;
10438: /*IF g_cannot_update_putaway IS NULL
10439: THEN
10440: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_PUTAWAY_TASK');
10441: g_cannot_update_putaway := fnd_message.get;
10442: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_STAGING_MOVE');
10443: g_cannot_update_staging_move := fnd_message.get;
10444: fnd_message.set_name ('WMS', 'WMS_TASK_UPDATED');
10445: g_task_updated := fnd_message.get;
10446: fnd_message.set_name ('WMS', 'WMS_CANNOT_UNRELEASE_CC');
10439: THEN
10440: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_PUTAWAY_TASK');
10441: g_cannot_update_putaway := fnd_message.get;
10442: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_STAGING_MOVE');
10443: g_cannot_update_staging_move := fnd_message.get;
10444: fnd_message.set_name ('WMS', 'WMS_TASK_UPDATED');
10445: g_task_updated := fnd_message.get;
10446: fnd_message.set_name ('WMS', 'WMS_CANNOT_UNRELEASE_CC');
10447: g_cannot_unrelease_cc := fnd_message.get;
10440: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_PUTAWAY_TASK');
10441: g_cannot_update_putaway := fnd_message.get;
10442: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_STAGING_MOVE');
10443: g_cannot_update_staging_move := fnd_message.get;
10444: fnd_message.set_name ('WMS', 'WMS_TASK_UPDATED');
10445: g_task_updated := fnd_message.get;
10446: fnd_message.set_name ('WMS', 'WMS_CANNOT_UNRELEASE_CC');
10447: g_cannot_unrelease_cc := fnd_message.get;
10448: END IF;*/
10441: g_cannot_update_putaway := fnd_message.get;
10442: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_STAGING_MOVE');
10443: g_cannot_update_staging_move := fnd_message.get;
10444: fnd_message.set_name ('WMS', 'WMS_TASK_UPDATED');
10445: g_task_updated := fnd_message.get;
10446: fnd_message.set_name ('WMS', 'WMS_CANNOT_UNRELEASE_CC');
10447: g_cannot_unrelease_cc := fnd_message.get;
10448: END IF;*/
10449:
10442: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_STAGING_MOVE');
10443: g_cannot_update_staging_move := fnd_message.get;
10444: fnd_message.set_name ('WMS', 'WMS_TASK_UPDATED');
10445: g_task_updated := fnd_message.get;
10446: fnd_message.set_name ('WMS', 'WMS_CANNOT_UNRELEASE_CC');
10447: g_cannot_unrelease_cc := fnd_message.get;
10448: END IF;*/
10449:
10450:
10443: g_cannot_update_staging_move := fnd_message.get;
10444: fnd_message.set_name ('WMS', 'WMS_TASK_UPDATED');
10445: g_task_updated := fnd_message.get;
10446: fnd_message.set_name ('WMS', 'WMS_CANNOT_UNRELEASE_CC');
10447: g_cannot_unrelease_cc := fnd_message.get;
10448: END IF;*/
10449:
10450:
10451: FORALL i IN p_transaction_temp_id.FIRST .. p_transaction_temp_id.LAST
10643: DEBUG ('no of records saved are' || x_save_count);
10644: end if;
10645:
10646: IF g_plan_cancelled IS NULL THEN
10647: fnd_message.set_name ('WMS', 'WMS_PLAN_CANCELLED');
10648: g_plan_cancelled := fnd_message.get;
10649: END IF;
10650:
10651:
10644: end if;
10645:
10646: IF g_plan_cancelled IS NULL THEN
10647: fnd_message.set_name ('WMS', 'WMS_PLAN_CANCELLED');
10648: g_plan_cancelled := fnd_message.get;
10649: END IF;
10650:
10651:
10652: UPDATE wms_waveplan_tasks_temp
10898: /* End Bug 5507934 */
10899:
10900: IF g_task_saved IS NULL
10901: THEN
10902: fnd_message.set_name ('WMS', 'WMS_TASK_SAVED');
10903: g_task_saved := fnd_message.get;
10904: END IF;
10905:
10906: -- forall i IN l_transaction_temp_id_table.first..l_transaction_temp_id_table.last
10899:
10900: IF g_task_saved IS NULL
10901: THEN
10902: fnd_message.set_name ('WMS', 'WMS_TASK_SAVED');
10903: g_task_saved := fnd_message.get;
10904: END IF;
10905:
10906: -- forall i IN l_transaction_temp_id_table.first..l_transaction_temp_id_table.last
10907: FORALL i IN 1 .. l_transaction_temp_id_table.COUNT
10960: END IF;
10961: END LOOP;
10962: END IF;
10963:
10964: fnd_message.set_name ('FND', 'FORM_RECORD_CHANGED');
10965: l_error_message := fnd_message.get;
10966:
10967: UPDATE wms_waveplan_tasks_temp
10968: SET RESULT = 'E',
10961: END LOOP;
10962: END IF;
10963:
10964: fnd_message.set_name ('FND', 'FORM_RECORD_CHANGED');
10965: l_error_message := fnd_message.get;
10966:
10967: UPDATE wms_waveplan_tasks_temp
10968: SET RESULT = 'E',
10969: error = l_error_message
11213: l_result (i) := 'E';
11214:
11215: IF g_time_uom_error IS NULL
11216: THEN
11217: fnd_message.set_name ('WMS', 'WMS_TIME_UOM_ERROR');
11218: g_time_uom_error := fnd_message.get;
11219: END IF;
11220:
11221: IF g_cannot_summarize_time IS NULL
11214:
11215: IF g_time_uom_error IS NULL
11216: THEN
11217: fnd_message.set_name ('WMS', 'WMS_TIME_UOM_ERROR');
11218: g_time_uom_error := fnd_message.get;
11219: END IF;
11220:
11221: IF g_cannot_summarize_time IS NULL
11222: THEN
11219: END IF;
11220:
11221: IF g_cannot_summarize_time IS NULL
11222: THEN
11223: fnd_message.set_name ('WMS',
11224: 'WMS_CANNOT_SUMMARIZE_TIME'
11225: );
11226: g_cannot_summarize_time := fnd_message.get;
11227: END IF;
11222: THEN
11223: fnd_message.set_name ('WMS',
11224: 'WMS_CANNOT_SUMMARIZE_TIME'
11225: );
11226: g_cannot_summarize_time := fnd_message.get;
11227: END IF;
11228:
11229: l_error (i) :=
11230: SUBSTR ( l_error (i)
11235: );
11236: ELSE
11237: IF g_summarized_time IS NULL
11238: THEN
11239: fnd_message.set_name ('WMS',
11240: 'WMS_SUMMARIZED_TIME');
11241: g_summarized_time := fnd_message.get;
11242: END IF;
11243:
11237: IF g_summarized_time IS NULL
11238: THEN
11239: fnd_message.set_name ('WMS',
11240: 'WMS_SUMMARIZED_TIME');
11241: g_summarized_time := fnd_message.get;
11242: END IF;
11243:
11244: l_error (i) :=
11245: SUBSTR (l_error (i) || g_summarized_time, 1,
11247: END IF; -- UOM converted?
11248: ELSE
11249: IF g_summarized_time IS NULL
11250: THEN
11251: fnd_message.set_name ('WMS', 'WMS_SUMMARIZED_TIME');
11252: g_summarized_time := fnd_message.get;
11253: END IF;
11254:
11255: l_error (i) :=
11248: ELSE
11249: IF g_summarized_time IS NULL
11250: THEN
11251: fnd_message.set_name ('WMS', 'WMS_SUMMARIZED_TIME');
11252: g_summarized_time := fnd_message.get;
11253: END IF;
11254:
11255: l_error (i) :=
11256: SUBSTR (l_error (i) || g_summarized_time, 1,
11261: x_total_time := x_total_time + NVL (l_time (i), 0);
11262: ELSE
11263: IF g_cannot_summarize_time IS NULL
11264: THEN
11265: fnd_message.set_name ('WMS',
11266: 'WMS_CANNOT_SUMMARIZE_TIME');
11267: g_cannot_summarize_time := fnd_message.get;
11268: END IF;
11269:
11263: IF g_cannot_summarize_time IS NULL
11264: THEN
11265: fnd_message.set_name ('WMS',
11266: 'WMS_CANNOT_SUMMARIZE_TIME');
11267: g_cannot_summarize_time := fnd_message.get;
11268: END IF;
11269:
11270: l_error (i) :=
11271: SUBSTR (l_error (i) || g_cannot_summarize_time, 1,
11275: ELSIF p_calculate_time AND l_user_task_type_id (i) IS NULL
11276: THEN
11277: IF g_cannot_summarize_time IS NULL
11278: THEN
11279: fnd_message.set_name ('WMS', 'WMS_CANNOT_SUMMARIZE_TIME');
11280: g_cannot_summarize_time := fnd_message.get;
11281: END IF;
11282:
11283: l_error (i) :=
11276: THEN
11277: IF g_cannot_summarize_time IS NULL
11278: THEN
11279: fnd_message.set_name ('WMS', 'WMS_CANNOT_SUMMARIZE_TIME');
11280: g_cannot_summarize_time := fnd_message.get;
11281: END IF;
11282:
11283: l_error (i) :=
11284: SUBSTR (l_error (i) || g_cannot_summarize_time, 1,
11291: IF l_volume (i) IS NULL
11292: THEN
11293: IF g_no_item_vol IS NULL
11294: THEN
11295: fnd_message.set_name ('WMS', 'WMS_NO_ITEM_VOL');
11296: g_no_item_vol := fnd_message.get;
11297: END IF;
11298:
11299: IF g_cannot_summarize_vol IS NULL
11292: THEN
11293: IF g_no_item_vol IS NULL
11294: THEN
11295: fnd_message.set_name ('WMS', 'WMS_NO_ITEM_VOL');
11296: g_no_item_vol := fnd_message.get;
11297: END IF;
11298:
11299: IF g_cannot_summarize_vol IS NULL
11300: THEN
11297: END IF;
11298:
11299: IF g_cannot_summarize_vol IS NULL
11300: THEN
11301: fnd_message.set_name ('WMS', 'WMS_CANNOT_SUMMARIZE_VOL');
11302: g_cannot_summarize_vol := fnd_message.get;
11303: END IF;
11304:
11305: l_result (i) := 'E';
11298:
11299: IF g_cannot_summarize_vol IS NULL
11300: THEN
11301: fnd_message.set_name ('WMS', 'WMS_CANNOT_SUMMARIZE_VOL');
11302: g_cannot_summarize_vol := fnd_message.get;
11303: END IF;
11304:
11305: l_result (i) := 'E';
11306: l_error (i) :=
11335: l_result (i) := 'E';
11336:
11337: IF g_vol_uom_error IS NULL
11338: THEN
11339: fnd_message.set_name ('WMS', 'WMS_VOL_UOM_ERROR');
11340: g_vol_uom_error := fnd_message.get;
11341: END IF;
11342:
11343: IF g_cannot_summarize_vol IS NULL
11336:
11337: IF g_vol_uom_error IS NULL
11338: THEN
11339: fnd_message.set_name ('WMS', 'WMS_VOL_UOM_ERROR');
11340: g_vol_uom_error := fnd_message.get;
11341: END IF;
11342:
11343: IF g_cannot_summarize_vol IS NULL
11344: THEN
11341: END IF;
11342:
11343: IF g_cannot_summarize_vol IS NULL
11344: THEN
11345: fnd_message.set_name ('WMS',
11346: 'WMS_CANNOT_SUMMARIZE_VOL'
11347: );
11348: g_cannot_summarize_vol := fnd_message.get;
11349: END IF;
11344: THEN
11345: fnd_message.set_name ('WMS',
11346: 'WMS_CANNOT_SUMMARIZE_VOL'
11347: );
11348: g_cannot_summarize_vol := fnd_message.get;
11349: END IF;
11350:
11351: l_error (i) :=
11352: SUBSTR ( l_error (i)
11357: );
11358: ELSE
11359: IF g_summarized_volume IS NULL
11360: THEN
11361: fnd_message.set_name ('WMS',
11362: 'WMS_SUMMARIZED_VOLUME'
11363: );
11364: g_summarized_volume := fnd_message.get;
11365: END IF;
11360: THEN
11361: fnd_message.set_name ('WMS',
11362: 'WMS_SUMMARIZED_VOLUME'
11363: );
11364: g_summarized_volume := fnd_message.get;
11365: END IF;
11366:
11367: l_error (i) :=
11368: SUBSTR (l_error (i) || g_summarized_volume, 1,
11370: END IF;
11371: ELSE
11372: IF g_summarized_volume IS NULL
11373: THEN
11374: fnd_message.set_name ('WMS', 'WMS_SUMMARIZED_VOLUME');
11375: g_summarized_volume := fnd_message.get;
11376: END IF;
11377:
11378: l_error (i) :=
11371: ELSE
11372: IF g_summarized_volume IS NULL
11373: THEN
11374: fnd_message.set_name ('WMS', 'WMS_SUMMARIZED_VOLUME');
11375: g_summarized_volume := fnd_message.get;
11376: END IF;
11377:
11378: l_error (i) :=
11379: SUBSTR (l_error (i) || g_summarized_volume, 1,
11392: IF l_weight (i) IS NULL
11393: THEN
11394: IF g_no_item_wt IS NULL
11395: THEN
11396: fnd_message.set_name ('WMS', 'WMS_NO_ITEM_WT');
11397: g_no_item_wt := fnd_message.get;
11398: END IF;
11399:
11400: IF g_cannot_summarize_wt IS NULL
11393: THEN
11394: IF g_no_item_wt IS NULL
11395: THEN
11396: fnd_message.set_name ('WMS', 'WMS_NO_ITEM_WT');
11397: g_no_item_wt := fnd_message.get;
11398: END IF;
11399:
11400: IF g_cannot_summarize_wt IS NULL
11401: THEN
11398: END IF;
11399:
11400: IF g_cannot_summarize_wt IS NULL
11401: THEN
11402: fnd_message.set_name ('WMS', 'WMS_CANNOT_SUMMARIZE_WT');
11403: g_cannot_summarize_wt := fnd_message.get;
11404: END IF;
11405:
11406: l_result (i) := 'E';
11399:
11400: IF g_cannot_summarize_wt IS NULL
11401: THEN
11402: fnd_message.set_name ('WMS', 'WMS_CANNOT_SUMMARIZE_WT');
11403: g_cannot_summarize_wt := fnd_message.get;
11404: END IF;
11405:
11406: l_result (i) := 'E';
11407: l_error (i) :=
11438: l_result (i) := 'E';
11439:
11440: IF g_wt_uom_error IS NULL
11441: THEN
11442: fnd_message.set_name ('WMS', 'WMS_WT_UOM_ERROR');
11443: g_wt_uom_error := fnd_message.get;
11444: END IF;
11445:
11446: IF g_cannot_summarize_wt IS NULL
11439:
11440: IF g_wt_uom_error IS NULL
11441: THEN
11442: fnd_message.set_name ('WMS', 'WMS_WT_UOM_ERROR');
11443: g_wt_uom_error := fnd_message.get;
11444: END IF;
11445:
11446: IF g_cannot_summarize_wt IS NULL
11447: THEN
11444: END IF;
11445:
11446: IF g_cannot_summarize_wt IS NULL
11447: THEN
11448: fnd_message.set_name ('WMS',
11449: 'WMS_CANNOT_SUMMARIZE_WT'
11450: );
11451: g_cannot_summarize_wt := fnd_message.get;
11452: END IF;
11447: THEN
11448: fnd_message.set_name ('WMS',
11449: 'WMS_CANNOT_SUMMARIZE_WT'
11450: );
11451: g_cannot_summarize_wt := fnd_message.get;
11452: END IF;
11453:
11454: l_error (i) :=
11455: SUBSTR ( l_error (i)
11460: );
11461: ELSE
11462: IF g_summarized_weight IS NULL
11463: THEN
11464: fnd_message.set_name ('WMS',
11465: 'WMS_SUMMARIZED_WEIGHT'
11466: );
11467: g_summarized_weight := fnd_message.get;
11468: END IF;
11463: THEN
11464: fnd_message.set_name ('WMS',
11465: 'WMS_SUMMARIZED_WEIGHT'
11466: );
11467: g_summarized_weight := fnd_message.get;
11468: END IF;
11469:
11470: l_error (i) :=
11471: SUBSTR (l_error (i) || g_summarized_weight, 1,
11473: END IF;
11474: ELSE
11475: IF g_summarized_weight IS NULL
11476: THEN
11477: fnd_message.set_name ('WMS', 'WMS_SUMMARIZED_WEIGHT');
11478: g_summarized_weight := fnd_message.get;
11479: END IF;
11480:
11481: l_error (i) :=
11474: ELSE
11475: IF g_summarized_weight IS NULL
11476: THEN
11477: fnd_message.set_name ('WMS', 'WMS_SUMMARIZED_WEIGHT');
11478: g_summarized_weight := fnd_message.get;
11479: END IF;
11480:
11481: l_error (i) :=
11482: SUBSTR (l_error (i) || g_summarized_weight, 1,
11602: DEBUG ('failure for ' || i || ' ' || l_msg_data);
11603: end if;
11604: END IF;
11605: ELSE
11606: fnd_message.set_name('WMS','WMS_CANCEL_FAILED');
11607: x_ret_code(i) := fnd_message.get;
11608: END IF;
11609:
11610: END LOOP;
11603: end if;
11604: END IF;
11605: ELSE
11606: fnd_message.set_name('WMS','WMS_CANCEL_FAILED');
11607: x_ret_code(i) := fnd_message.get;
11608: END IF;
11609:
11610: END LOOP;
11611: