85: -- Check for existence of same workflow instance.
86: l_wf_item_exists := wf_item.item_exist( itemtype => p_wf_item_name,
87: itemkey => p_wf_item_key );
88: if ( l_wf_item_exists ) then
89: FND_MESSAGE.SET_NAME('JTF','JTF_WF_ALREADY_EXISTS');
90: FND_MESSAGE.SET_TOKEN('WF_NAME',p_wf_item_name);
91: FND_MESSAGE.SET_TOKEN('WF_KEY',p_wf_item_key);
92: FND_MSG_PUB.Add;
93: RAISE FND_API.G_EXC_ERROR;
86: l_wf_item_exists := wf_item.item_exist( itemtype => p_wf_item_name,
87: itemkey => p_wf_item_key );
88: if ( l_wf_item_exists ) then
89: FND_MESSAGE.SET_NAME('JTF','JTF_WF_ALREADY_EXISTS');
90: FND_MESSAGE.SET_TOKEN('WF_NAME',p_wf_item_name);
91: FND_MESSAGE.SET_TOKEN('WF_KEY',p_wf_item_key);
92: FND_MSG_PUB.Add;
93: RAISE FND_API.G_EXC_ERROR;
94: else
87: itemkey => p_wf_item_key );
88: if ( l_wf_item_exists ) then
89: FND_MESSAGE.SET_NAME('JTF','JTF_WF_ALREADY_EXISTS');
90: FND_MESSAGE.SET_TOKEN('WF_NAME',p_wf_item_name);
91: FND_MESSAGE.SET_TOKEN('WF_KEY',p_wf_item_key);
92: FND_MSG_PUB.Add;
93: RAISE FND_API.G_EXC_ERROR;
94: else
95: -- Create workflow process.
136: wf_engine.StartProcess( itemType => p_wf_item_name,
137: itemKey => p_wf_item_key
138: );
139:
140: FND_MESSAGE.SET_NAME('JTF','JTF_WF_LAUNCH_SUCCESS');
141: FND_MESSAGE.SET_TOKEN('WF_NAME',p_wf_item_name);
142: FND_MESSAGE.SET_TOKEN('WF_KEY',p_wf_item_key);
143: FND_MSG_PUB.Add;
144:
137: itemKey => p_wf_item_key
138: );
139:
140: FND_MESSAGE.SET_NAME('JTF','JTF_WF_LAUNCH_SUCCESS');
141: FND_MESSAGE.SET_TOKEN('WF_NAME',p_wf_item_name);
142: FND_MESSAGE.SET_TOKEN('WF_KEY',p_wf_item_key);
143: FND_MSG_PUB.Add;
144:
145: /* Purge Bind data table */
138: );
139:
140: FND_MESSAGE.SET_NAME('JTF','JTF_WF_LAUNCH_SUCCESS');
141: FND_MESSAGE.SET_TOKEN('WF_NAME',p_wf_item_name);
142: FND_MESSAGE.SET_TOKEN('WF_KEY',p_wf_item_key);
143: FND_MSG_PUB.Add;
144:
145: /* Purge Bind data table */
146: JTF_USR_HKS.Purge_Bind_Data( p_bind_data_id => l_bind_data_id,
158: x_return_code := FND_API.G_RET_STS_UNEXP_ERROR;
159:
160: When OTHERS then
161: x_return_code := FND_API.G_RET_STS_UNEXP_ERROR;
162: FND_MESSAGE.SET_NAME('JTF','JTF_WF_LAUNCH_ERROR');
163: FND_MESSAGE.SET_TOKEN('WF_NAME',p_wf_item_name);
164: FND_MESSAGE.SET_TOKEN('WF_KEY',p_wf_item_key);
165: FND_MSG_PUB.Add;
166:
159:
160: When OTHERS then
161: x_return_code := FND_API.G_RET_STS_UNEXP_ERROR;
162: FND_MESSAGE.SET_NAME('JTF','JTF_WF_LAUNCH_ERROR');
163: FND_MESSAGE.SET_TOKEN('WF_NAME',p_wf_item_name);
164: FND_MESSAGE.SET_TOKEN('WF_KEY',p_wf_item_key);
165: FND_MSG_PUB.Add;
166:
167: End WrkflowLaunch;
160: When OTHERS then
161: x_return_code := FND_API.G_RET_STS_UNEXP_ERROR;
162: FND_MESSAGE.SET_NAME('JTF','JTF_WF_LAUNCH_ERROR');
163: FND_MESSAGE.SET_TOKEN('WF_NAME',p_wf_item_name);
164: FND_MESSAGE.SET_TOKEN('WF_KEY',p_wf_item_key);
165: FND_MSG_PUB.Add;
166:
167: End WrkflowLaunch;
168:
201: -- Check for existence of same workflow instance.
202: l_wf_item_exists := wf_item.item_exist( itemtype => p_wf_item_name,
203: itemkey => p_wf_item_key );
204: if ( l_wf_item_exists ) then
205: FND_MESSAGE.SET_NAME('JTF','JTF_WF_ALREADY_EXISTS');
206: FND_MESSAGE.SET_TOKEN('WF_NAME',p_wf_item_name);
207: FND_MESSAGE.SET_TOKEN('WF_KEY',p_wf_item_key);
208: FND_MSG_PUB.Add;
209: RAISE FND_API.G_EXC_ERROR;
202: l_wf_item_exists := wf_item.item_exist( itemtype => p_wf_item_name,
203: itemkey => p_wf_item_key );
204: if ( l_wf_item_exists ) then
205: FND_MESSAGE.SET_NAME('JTF','JTF_WF_ALREADY_EXISTS');
206: FND_MESSAGE.SET_TOKEN('WF_NAME',p_wf_item_name);
207: FND_MESSAGE.SET_TOKEN('WF_KEY',p_wf_item_key);
208: FND_MSG_PUB.Add;
209: RAISE FND_API.G_EXC_ERROR;
210: else
203: itemkey => p_wf_item_key );
204: if ( l_wf_item_exists ) then
205: FND_MESSAGE.SET_NAME('JTF','JTF_WF_ALREADY_EXISTS');
206: FND_MESSAGE.SET_TOKEN('WF_NAME',p_wf_item_name);
207: FND_MESSAGE.SET_TOKEN('WF_KEY',p_wf_item_key);
208: FND_MSG_PUB.Add;
209: RAISE FND_API.G_EXC_ERROR;
210: else
211: -- Create workflow process.
280: wf_engine.StartProcess( itemType => p_wf_item_name,
281: itemKey => p_wf_item_key
282: );
283:
284: FND_MESSAGE.SET_NAME('JTF','JTF_WF_LAUNCH_SUCCESS');
285: FND_MESSAGE.SET_TOKEN('WF_NAME',p_wf_item_name);
286: FND_MESSAGE.SET_TOKEN('WF_KEY',p_wf_item_key);
287: FND_MSG_PUB.Add;
288:
281: itemKey => p_wf_item_key
282: );
283:
284: FND_MESSAGE.SET_NAME('JTF','JTF_WF_LAUNCH_SUCCESS');
285: FND_MESSAGE.SET_TOKEN('WF_NAME',p_wf_item_name);
286: FND_MESSAGE.SET_TOKEN('WF_KEY',p_wf_item_key);
287: FND_MSG_PUB.Add;
288:
289: -- Purge Bind data table
282: );
283:
284: FND_MESSAGE.SET_NAME('JTF','JTF_WF_LAUNCH_SUCCESS');
285: FND_MESSAGE.SET_TOKEN('WF_NAME',p_wf_item_name);
286: FND_MESSAGE.SET_TOKEN('WF_KEY',p_wf_item_key);
287: FND_MSG_PUB.Add;
288:
289: -- Purge Bind data table
290: JTF_USR_HKS.Purge_Bind_Data( p_bind_data_id => l_bind_data_id,
302: x_return_code := FND_API.G_RET_STS_UNEXP_ERROR;
303:
304: When OTHERS then
305: x_return_code := FND_API.G_RET_STS_UNEXP_ERROR;
306: FND_MESSAGE.SET_NAME('JTF','JTF_WF_LAUNCH_ERROR');
307: FND_MESSAGE.SET_TOKEN('WF_NAME',p_wf_item_name);
308: FND_MESSAGE.SET_TOKEN('WF_KEY',p_wf_item_key);
309: FND_MSG_PUB.Add;
310:
303:
304: When OTHERS then
305: x_return_code := FND_API.G_RET_STS_UNEXP_ERROR;
306: FND_MESSAGE.SET_NAME('JTF','JTF_WF_LAUNCH_ERROR');
307: FND_MESSAGE.SET_TOKEN('WF_NAME',p_wf_item_name);
308: FND_MESSAGE.SET_TOKEN('WF_KEY',p_wf_item_key);
309: FND_MSG_PUB.Add;
310:
311: End GenMsgWrkflowLaunch;
304: When OTHERS then
305: x_return_code := FND_API.G_RET_STS_UNEXP_ERROR;
306: FND_MESSAGE.SET_NAME('JTF','JTF_WF_LAUNCH_ERROR');
307: FND_MESSAGE.SET_TOKEN('WF_NAME',p_wf_item_name);
308: FND_MESSAGE.SET_TOKEN('WF_KEY',p_wf_item_key);
309: FND_MSG_PUB.Add;
310:
311: End GenMsgWrkflowLaunch;
312:
361: ACTION_CODE = p_action_code and
362: ACTIVE_FLAG = 'Y';
363: Exception
364: When NO_DATA_FOUND then
365: FND_MESSAGE.SET_NAME('JTF','JTF_NO_BUS_OBJECT');
366: FND_MESSAGE.SET_TOKEN('BO_CODE',p_bus_obj_code);
367: FND_MSG_PUB.ADD;
368: RAISE FND_API.G_EXC_ERROR;
369: When OTHERS then
362: ACTIVE_FLAG = 'Y';
363: Exception
364: When NO_DATA_FOUND then
365: FND_MESSAGE.SET_NAME('JTF','JTF_NO_BUS_OBJECT');
366: FND_MESSAGE.SET_TOKEN('BO_CODE',p_bus_obj_code);
367: FND_MSG_PUB.ADD;
368: RAISE FND_API.G_EXC_ERROR;
369: When OTHERS then
370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
394: );
395:
396: Else
397:
398: FND_MESSAGE.SET_NAME('JTF','JTF_INVALID_MSG_MODE');
399: FND_MESSAGE.SET_TOKEN('MSG_MODE', to_char(l_msg_mode) );
400: FND_MSG_PUB.ADD;
401: RAISE FND_API.G_EXC_ERROR;
402: End If;
395:
396: Else
397:
398: FND_MESSAGE.SET_NAME('JTF','JTF_INVALID_MSG_MODE');
399: FND_MESSAGE.SET_TOKEN('MSG_MODE', to_char(l_msg_mode) );
400: FND_MSG_PUB.ADD;
401: RAISE FND_API.G_EXC_ERROR;
402: End If;
403:
407: When FND_API.G_EXC_ERROR then
408: x_return_code := FND_API.G_RET_STS_ERROR;
409: When OTHERS then
410: x_return_code := FND_API.G_RET_STS_UNEXP_ERROR;
411: FND_MESSAGE.SET_NAME('JTF','JTF_MSG_GEN_ERROR');
412: FND_MESSAGE.SET_TOKEN('PROD_CODE',p_prod_code);
413: FND_MESSAGE.SET_TOKEN('BO_CODE',p_bus_obj_code);
414: FND_MSG_PUB.ADD;
415:
408: x_return_code := FND_API.G_RET_STS_ERROR;
409: When OTHERS then
410: x_return_code := FND_API.G_RET_STS_UNEXP_ERROR;
411: FND_MESSAGE.SET_NAME('JTF','JTF_MSG_GEN_ERROR');
412: FND_MESSAGE.SET_TOKEN('PROD_CODE',p_prod_code);
413: FND_MESSAGE.SET_TOKEN('BO_CODE',p_bus_obj_code);
414: FND_MSG_PUB.ADD;
415:
416: End Generate_Message;
409: When OTHERS then
410: x_return_code := FND_API.G_RET_STS_UNEXP_ERROR;
411: FND_MESSAGE.SET_NAME('JTF','JTF_MSG_GEN_ERROR');
412: FND_MESSAGE.SET_TOKEN('PROD_CODE',p_prod_code);
413: FND_MESSAGE.SET_TOKEN('BO_CODE',p_bus_obj_code);
414: FND_MSG_PUB.ADD;
415:
416: End Generate_Message;
417:
447: ACTION_CODE = p_action_code and
448: ACTIVE_FLAG = 'Y';
449: Exception
450: When NO_DATA_FOUND then
451: FND_MESSAGE.SET_NAME('JTF','JTF_NO_BUS_OBJECT');
452: FND_MESSAGE.SET_TOKEN('BO_CODE',p_bus_obj_code);
453: FND_MSG_PUB.ADD;
454: RAISE FND_API.G_EXC_ERROR;
455: When OTHERS then
448: ACTIVE_FLAG = 'Y';
449: Exception
450: When NO_DATA_FOUND then
451: FND_MESSAGE.SET_NAME('JTF','JTF_NO_BUS_OBJECT');
452: FND_MESSAGE.SET_TOKEN('BO_CODE',p_bus_obj_code);
453: FND_MSG_PUB.ADD;
454: RAISE FND_API.G_EXC_ERROR;
455: When OTHERS then
456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
475: When FND_API.G_EXC_ERROR then
476: x_return_code := FND_API.G_RET_STS_ERROR;
477: When OTHERS then
478: x_return_code := FND_API.G_RET_STS_UNEXP_ERROR;
479: FND_MESSAGE.SET_NAME('JTF','JTF_MSG_GEN_ERROR');
480: FND_MESSAGE.SET_TOKEN('PROD_CODE',p_prod_code);
481: FND_MESSAGE.SET_TOKEN('BO_CODE',p_bus_obj_code);
482: FND_MSG_PUB.ADD;
483:
476: x_return_code := FND_API.G_RET_STS_ERROR;
477: When OTHERS then
478: x_return_code := FND_API.G_RET_STS_UNEXP_ERROR;
479: FND_MESSAGE.SET_NAME('JTF','JTF_MSG_GEN_ERROR');
480: FND_MESSAGE.SET_TOKEN('PROD_CODE',p_prod_code);
481: FND_MESSAGE.SET_TOKEN('BO_CODE',p_bus_obj_code);
482: FND_MSG_PUB.ADD;
483:
484: End Generate_Message;
477: When OTHERS then
478: x_return_code := FND_API.G_RET_STS_UNEXP_ERROR;
479: FND_MESSAGE.SET_NAME('JTF','JTF_MSG_GEN_ERROR');
480: FND_MESSAGE.SET_TOKEN('PROD_CODE',p_prod_code);
481: FND_MESSAGE.SET_TOKEN('BO_CODE',p_bus_obj_code);
482: FND_MSG_PUB.ADD;
483:
484: End Generate_Message;
485:
520: ACTION_CODE = p_action_code and
521: ACTIVE_FLAG = 'Y';
522: Exception
523: When NO_DATA_FOUND then
524: FND_MESSAGE.SET_NAME('JTF','JTF_NO_BUS_OBJECT');
525: FND_MESSAGE.SET_TOKEN('BO_CODE',p_bus_obj_code);
526: FND_MSG_PUB.ADD;
527: RAISE FND_API.G_EXC_ERROR;
528: When OTHERS then
521: ACTIVE_FLAG = 'Y';
522: Exception
523: When NO_DATA_FOUND then
524: FND_MESSAGE.SET_NAME('JTF','JTF_NO_BUS_OBJECT');
525: FND_MESSAGE.SET_TOKEN('BO_CODE',p_bus_obj_code);
526: FND_MSG_PUB.ADD;
527: RAISE FND_API.G_EXC_ERROR;
528: When OTHERS then
529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
589: When FND_API.G_EXC_ERROR then
590: x_return_code := FND_API.G_RET_STS_ERROR;
591: When OTHERS then
592: x_return_code := FND_API.G_RET_STS_UNEXP_ERROR;
593: FND_MESSAGE.SET_NAME('JTF','JTF_MSG_GEN_ERROR');
594: FND_MESSAGE.SET_TOKEN('PROD_CODE',p_prod_code);
595: FND_MESSAGE.SET_TOKEN('BO_CODE',p_bus_obj_code);
596: FND_MSG_PUB.ADD;
597:
590: x_return_code := FND_API.G_RET_STS_ERROR;
591: When OTHERS then
592: x_return_code := FND_API.G_RET_STS_UNEXP_ERROR;
593: FND_MESSAGE.SET_NAME('JTF','JTF_MSG_GEN_ERROR');
594: FND_MESSAGE.SET_TOKEN('PROD_CODE',p_prod_code);
595: FND_MESSAGE.SET_TOKEN('BO_CODE',p_bus_obj_code);
596: FND_MSG_PUB.ADD;
597:
598: End Generate_Message;
591: When OTHERS then
592: x_return_code := FND_API.G_RET_STS_UNEXP_ERROR;
593: FND_MESSAGE.SET_NAME('JTF','JTF_MSG_GEN_ERROR');
594: FND_MESSAGE.SET_TOKEN('PROD_CODE',p_prod_code);
595: FND_MESSAGE.SET_TOKEN('BO_CODE',p_bus_obj_code);
596: FND_MSG_PUB.ADD;
597:
598: End Generate_Message;
599:
684: When FND_API.G_EXC_ERROR then
685: x_return_code := FND_API.G_RET_STS_ERROR;
686: When OTHERS then
687: x_return_code := FND_API.G_RET_STS_UNEXP_ERROR;
688: FND_MESSAGE.SET_NAME('JTF','JTF_MSG_GEN_ERROR');
689: FND_MESSAGE.SET_TOKEN('PROD_CODE',p_prod_code);
690: FND_MESSAGE.SET_TOKEN('BO_CODE',p_bus_obj_code);
691: FND_MSG_PUB.ADD;
692:
685: x_return_code := FND_API.G_RET_STS_ERROR;
686: When OTHERS then
687: x_return_code := FND_API.G_RET_STS_UNEXP_ERROR;
688: FND_MESSAGE.SET_NAME('JTF','JTF_MSG_GEN_ERROR');
689: FND_MESSAGE.SET_TOKEN('PROD_CODE',p_prod_code);
690: FND_MESSAGE.SET_TOKEN('BO_CODE',p_bus_obj_code);
691: FND_MSG_PUB.ADD;
692:
693: End Generate_Message;
686: When OTHERS then
687: x_return_code := FND_API.G_RET_STS_UNEXP_ERROR;
688: FND_MESSAGE.SET_NAME('JTF','JTF_MSG_GEN_ERROR');
689: FND_MESSAGE.SET_TOKEN('PROD_CODE',p_prod_code);
690: FND_MESSAGE.SET_TOKEN('BO_CODE',p_bus_obj_code);
691: FND_MSG_PUB.ADD;
692:
693: End Generate_Message;
694:
883: ACTION_CODE = p_action_code and
884: ACTIVE_FLAG = 'Y';
885: Exception
886: When NO_DATA_FOUND then
887: FND_MESSAGE.SET_NAME('JTF','JTF_NO_BUS_OBJECT');
888: FND_MESSAGE.SET_TOKEN('BO_CODE',p_bus_obj_code);
889: FND_MSG_PUB.ADD;
890: RAISE FND_API.G_EXC_ERROR;
891: When OTHERS then
884: ACTIVE_FLAG = 'Y';
885: Exception
886: When NO_DATA_FOUND then
887: FND_MESSAGE.SET_NAME('JTF','JTF_NO_BUS_OBJECT');
888: FND_MESSAGE.SET_TOKEN('BO_CODE',p_bus_obj_code);
889: FND_MSG_PUB.ADD;
890: RAISE FND_API.G_EXC_ERROR;
891: When OTHERS then
892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
900: where
901: ACTIVE_FLAG = 'Y';
902: Exception
903: When NO_DATA_FOUND then
904: FND_MESSAGE.SET_NAME('JTF','JTF_NO_HDR_DTD');
905: FND_MSG_PUB.ADD;
906: RAISE FND_API.G_EXC_ERROR;
907: When OTHERS then
908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;