236:
237: EXCEPTION
238: WHEN OTHERS THEN
239: x_return_code := -191266;
240: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
241: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPDRCPB');
242: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
243: x_error_description := FND_MESSAGE.GET;
244:
237: EXCEPTION
238: WHEN OTHERS THEN
239: x_return_code := -191266;
240: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
241: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPDRCPB');
242: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
243: x_error_description := FND_MESSAGE.GET;
244:
245: END Process_DRC_Order;
238: WHEN OTHERS THEN
239: x_return_code := -191266;
240: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
241: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPDRCPB');
242: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
243: x_error_description := FND_MESSAGE.GET;
244:
245: END Process_DRC_Order;
246:
239: x_return_code := -191266;
240: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
241: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPDRCPB');
242: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
243: x_error_description := FND_MESSAGE.GET;
244:
245: END Process_DRC_Order;
246:
247: /*
268: where
269: wim.workitem_id = p_workitem_id;
270: if lv_type not in ('STATIC','DYNAMIC') then
271: return_code := -191272;
272: FND_MESSAGE.SET_NAME('XDP', 'XDP_WI_CONFIG_ERROR');
273: FND_MESSAGE.SET_TOKEN('WORK_ITEM_NAME', x_workitem_name);
274: error_description := FND_MESSAGE.GET;
275: return;
276: end if;
269: wim.workitem_id = p_workitem_id;
270: if lv_type not in ('STATIC','DYNAMIC') then
271: return_code := -191272;
272: FND_MESSAGE.SET_NAME('XDP', 'XDP_WI_CONFIG_ERROR');
273: FND_MESSAGE.SET_TOKEN('WORK_ITEM_NAME', x_workitem_name);
274: error_description := FND_MESSAGE.GET;
275: return;
276: end if;
277: exception
270: if lv_type not in ('STATIC','DYNAMIC') then
271: return_code := -191272;
272: FND_MESSAGE.SET_NAME('XDP', 'XDP_WI_CONFIG_ERROR');
273: FND_MESSAGE.SET_TOKEN('WORK_ITEM_NAME', x_workitem_name);
274: error_description := FND_MESSAGE.GET;
275: return;
276: end if;
277: exception
278: when no_data_found then
276: end if;
277: exception
278: when no_data_found then
279: return_code := -191273;
280: FND_MESSAGE.SET_NAME('XDP', 'XDP_INVALID_WORKITEM_ID');
281: error_description := FND_MESSAGE.GET;
282: return;
283: end;
284:
277: exception
278: when no_data_found then
279: return_code := -191273;
280: FND_MESSAGE.SET_NAME('XDP', 'XDP_INVALID_WORKITEM_ID');
281: error_description := FND_MESSAGE.GET;
282: return;
283: end;
284:
285: return;
286:
287: EXCEPTION
288: WHEN OTHERS THEN
289: return_code := -191266;
290: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
291: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPDRCPB');
292: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
293: error_description := FND_MESSAGE.GET;
294: END Validate_Task;
287: EXCEPTION
288: WHEN OTHERS THEN
289: return_code := -191266;
290: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
291: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPDRCPB');
292: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
293: error_description := FND_MESSAGE.GET;
294: END Validate_Task;
295:
288: WHEN OTHERS THEN
289: return_code := -191266;
290: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
291: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPDRCPB');
292: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
293: error_description := FND_MESSAGE.GET;
294: END Validate_Task;
295:
296: /*
289: return_code := -191266;
290: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
291: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPDRCPB');
292: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
293: error_description := FND_MESSAGE.GET;
294: END Validate_Task;
295:
296: /*
297: execute workitem in a synchronous mode
399: return;
400: end if;
401: else
402: return_code := -191272;
403: FND_MESSAGE.SET_NAME('XDP', 'XDP_WI_CONFIG_ERROR');
404: FND_MESSAGE.SET_TOKEN('WORK_ITEM_NAME', lv_wi);
405: error_description := FND_MESSAGE.GET;
406: -- lv_MessageList(1).MESSAGE_TOKEN_NAME := 'ERROR_STRING';
407: -- lv_MessageList(1).MESSAGE_TOKEN_VALUE := error_description;
400: end if;
401: else
402: return_code := -191272;
403: FND_MESSAGE.SET_NAME('XDP', 'XDP_WI_CONFIG_ERROR');
404: FND_MESSAGE.SET_TOKEN('WORK_ITEM_NAME', lv_wi);
405: error_description := FND_MESSAGE.GET;
406: -- lv_MessageList(1).MESSAGE_TOKEN_NAME := 'ERROR_STRING';
407: -- lv_MessageList(1).MESSAGE_TOKEN_VALUE := error_description;
408:
401: else
402: return_code := -191272;
403: FND_MESSAGE.SET_NAME('XDP', 'XDP_WI_CONFIG_ERROR');
404: FND_MESSAGE.SET_TOKEN('WORK_ITEM_NAME', lv_wi);
405: error_description := FND_MESSAGE.GET;
406: -- lv_MessageList(1).MESSAGE_TOKEN_NAME := 'ERROR_STRING';
407: -- lv_MessageList(1).MESSAGE_TOKEN_VALUE := error_description;
408:
409: -- Changed - sacsharm - 11.5.6 ErrorHandling
464:
465: EXCEPTION
466: WHEN OTHERS THEN
467: return_code := -191266;
468: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
469: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPDRCPB');
470: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
471: error_description := FND_MESSAGE.GET;
472: -- lv_MessageList(1).MESSAGE_TOKEN_NAME := 'ERROR_STRING';
465: EXCEPTION
466: WHEN OTHERS THEN
467: return_code := -191266;
468: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
469: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPDRCPB');
470: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
471: error_description := FND_MESSAGE.GET;
472: -- lv_MessageList(1).MESSAGE_TOKEN_NAME := 'ERROR_STRING';
473: -- lv_MessageList(1).MESSAGE_TOKEN_VALUE := error_description;
466: WHEN OTHERS THEN
467: return_code := -191266;
468: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
469: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPDRCPB');
470: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
471: error_description := FND_MESSAGE.GET;
472: -- lv_MessageList(1).MESSAGE_TOKEN_NAME := 'ERROR_STRING';
473: -- lv_MessageList(1).MESSAGE_TOKEN_VALUE := error_description;
474:
467: return_code := -191266;
468: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
469: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPDRCPB');
470: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
471: error_description := FND_MESSAGE.GET;
472: -- lv_MessageList(1).MESSAGE_TOKEN_NAME := 'ERROR_STRING';
473: -- lv_MessageList(1).MESSAGE_TOKEN_VALUE := error_description;
474:
475: -- Changed - sacsharm - 11.5.6 ErrorHandling
766:
767: EXCEPTION
768: WHEN OTHERS THEN
769: return_code := -191266;
770: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
771: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPDRCPB');
772: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
773: error_description := FND_MESSAGE.GET;
774: -- lv_MessageList(1).MESSAGE_TOKEN_NAME := 'ERROR_STRING';
767: EXCEPTION
768: WHEN OTHERS THEN
769: return_code := -191266;
770: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
771: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPDRCPB');
772: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
773: error_description := FND_MESSAGE.GET;
774: -- lv_MessageList(1).MESSAGE_TOKEN_NAME := 'ERROR_STRING';
775: -- lv_MessageList(1).MESSAGE_TOKEN_VALUE := SQLERRM;
768: WHEN OTHERS THEN
769: return_code := -191266;
770: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
771: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPDRCPB');
772: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
773: error_description := FND_MESSAGE.GET;
774: -- lv_MessageList(1).MESSAGE_TOKEN_NAME := 'ERROR_STRING';
775: -- lv_MessageList(1).MESSAGE_TOKEN_VALUE := SQLERRM;
776:
769: return_code := -191266;
770: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
771: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPDRCPB');
772: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
773: error_description := FND_MESSAGE.GET;
774: -- lv_MessageList(1).MESSAGE_TOKEN_NAME := 'ERROR_STRING';
775: -- lv_MessageList(1).MESSAGE_TOKEN_VALUE := SQLERRM;
776:
777: -- Changed - sacsharm - 11.5.6 ErrorHandling