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_WORKFLOW_WRAPPERS dependencies on FND_API

Line 30: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false

26:
27: -- This is the procedure called by LoadPick.
28: -- wf_wrapper in turn calls wf_start_workflow which kicks off the workflow
29: PROCEDURE wf_wrapper(p_api_version IN NUMBER
30: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
31: , p_commit IN VARCHAR2 := fnd_api.g_false
32: , x_return_status OUT NOCOPY VARCHAR2
33: , x_msg_count OUT NOCOPY NUMBER
34: , x_msg_data OUT NOCOPY VARCHAR2

Line 31: , p_commit IN VARCHAR2 := fnd_api.g_false

27: -- This is the procedure called by LoadPick.
28: -- wf_wrapper in turn calls wf_start_workflow which kicks off the workflow
29: PROCEDURE wf_wrapper(p_api_version IN NUMBER
30: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
31: , p_commit IN VARCHAR2 := fnd_api.g_false
32: , x_return_status OUT NOCOPY VARCHAR2
33: , x_msg_count OUT NOCOPY NUMBER
34: , x_msg_data OUT NOCOPY VARCHAR2
35: , p_org_id IN NUMBER

Line 75: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

71: END IF;
72: -- Standard Start of API savepoint
73: SAVEPOINT wf_wrapper_PVT;
74: -- Standard call to check for call compatibility.
75: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
76: p_api_version ,
77: l_api_name ,
78: G_PKG_NAME )
79: THEN

Line 82: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

78: G_PKG_NAME )
79: THEN
80: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
81: FND_MSG_PUB.ADD;
82: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
83: END IF;
84:
85: /* Comment this out because FND package not working in WMSTST
86: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 87: IF FND_API.to_Boolean( p_init_msg_list ) THEN

83: END IF;
84:
85: /* Comment this out because FND package not working in WMSTST
86: -- Initialize message list if p_init_msg_list is set to TRUE.
87: IF FND_API.to_Boolean( p_init_msg_list ) THEN
88: -- FND_MSG_PUB.initialize;
89: END IF;
90: */
91:

Line 93: x_return_status := FND_API.G_RET_STS_SUCCESS;

89: END IF;
90: */
91:
92: -- Initialize API return status to success
93: x_return_status := FND_API.G_RET_STS_SUCCESS;
94:
95: IF (l_debug = 1) THEN
96: mdebug('before calling wms_workflow_wrappers.wf_start_workflow');
97: END IF;

Line 180: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

176: );
177:
178: x_return_status := lX_RETURN_STATUS; --Bug 6116046
179: --bug 6924639
180: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
181: IF (l_debug = 1) THEN
182: mdebug('call to startworkflow failed at 1');
183: END IF;
184:

Line 187: RAISE fnd_api.g_exc_unexpected_error;

183: END IF;
184:
185: fnd_message.set_name('WMS', 'WMS_START_WORKFLOW_FAILED');
186: fnd_msg_pub.ADD;
187: RAISE fnd_api.g_exc_unexpected_error;
188: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
189: IF (l_debug = 1) THEN
190: mdebug('call to startworkflow failed at 2 ');
191: END IF;

Line 188: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

184:
185: fnd_message.set_name('WMS', 'WMS_START_WORKFLOW_FAILED');
186: fnd_msg_pub.ADD;
187: RAISE fnd_api.g_exc_unexpected_error;
188: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
189: IF (l_debug = 1) THEN
190: mdebug('call to startworkflow failed at 2 ');
191: END IF;
192:

Line 195: RAISE fnd_api.g_exc_error;

191: END IF;
192:
193: fnd_message.set_name('WMS', 'WMS_START_WORKFLOW_FAILED');
194: fnd_msg_pub.ADD;
195: RAISE fnd_api.g_exc_error;
196: END IF;
197: --bug 6924639
198: /*
199: -- after API call, validate return status

Line 200: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS AND x_return_status <> 'Y') THEN --bug 6924639 added condition to check for x_return_status<>'Y'

196: END IF;
197: --bug 6924639
198: /*
199: -- after API call, validate return status
200: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS AND x_return_status <> 'Y') THEN --bug 6924639 added condition to check for x_return_status<>'Y'
201: IF (l_debug = 1) THEN
202: mdebug('call to startworkflow failed ');
203: END IF;
204: FND_MESSAGE.SET_NAME('WMS', 'WMS_START_WORKFLOW_FAILED');

Line 206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

202: mdebug('call to startworkflow failed ');
203: END IF;
204: FND_MESSAGE.SET_NAME('WMS', 'WMS_START_WORKFLOW_FAILED');
205: FND_MSG_PUB.ADD;
206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
207: END IF;
208: */
209: EXCEPTION
210: WHEN FND_API.G_EXC_ERROR THEN

Line 210: WHEN FND_API.G_EXC_ERROR THEN

206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
207: END IF;
208: */
209: EXCEPTION
210: WHEN FND_API.G_EXC_ERROR THEN
211: IF (l_debug = 1) THEN
212: mdebug('expected error in '||l_api_name);
213: END IF;
214: ROLLBACK TO wf_wrapper_pvt;

Line 215: x_return_status := FND_API.G_RET_STS_ERROR;

211: IF (l_debug = 1) THEN
212: mdebug('expected error in '||l_api_name);
213: END IF;
214: ROLLBACK TO wf_wrapper_pvt;
215: x_return_status := FND_API.G_RET_STS_ERROR;
216: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
217: ,p_data => x_msg_data);
218:
219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

215: x_return_status := FND_API.G_RET_STS_ERROR;
216: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
217: ,p_data => x_msg_data);
218:
219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
220: IF (l_debug = 1) THEN
221: mdebug('unexpected error in '||l_api_name);
222: END IF;
223: ROLLBACK TO wf_wrapper_pvt;

Line 225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

221: mdebug('unexpected error in '||l_api_name);
222: END IF;
223: ROLLBACK TO wf_wrapper_pvt;
224: mdebug('ROLLBACK to wf_wrapper_pvt succeeded');
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
226: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
227: ,p_data => x_msg_data);
228:
229: WHEN OTHERS THEN

Line 234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

230: IF (l_debug = 1) THEN
231: mdebug('others error in '||l_api_name);
232: END IF;
233: ROLLBACK TO wf_wrapper_pvt;
234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
235: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
236: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
237: END IF;
238: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 414: x_return_status := FND_API.G_RET_STS_SUCCESS;

410:
411: -- Standard Start of API savepoint
412: SAVEPOINT wf_start_workflow_PVT;
413:
414: x_return_status := FND_API.G_RET_STS_SUCCESS;
415:
416: -- given the reason id, get reason name
417: IF p_reason_name IS NULL THEN
418: SELECT reason_name

Line 968: RAISE fnd_api.g_exc_error;

964: -- make sure that reason name is not null
965: if (p_reason_id is null ) then
966: fnd_message.set_name('INV','INV_FIELD_INVALID');
967: fnd_msg_pub.ADD;
968: RAISE fnd_api.g_exc_error;
969: end if;
970:
971: IF (l_debug = 1) THEN
972: mdebug('Before Select WORKFLOW_NAME, WORKFLOW_PROCESS ');

Line 1413: WHEN FND_API.G_EXC_ERROR THEN

1409:
1410:
1411: EXCEPTION
1412:
1413: WHEN FND_API.G_EXC_ERROR THEN
1414: IF (l_debug = 1) THEN
1415: mdebug('exception:FND_API.G_EXC_ERROR at l_error: '||l_error);
1416: END IF;
1417: ROLLBACK TO wf_start_workflow_pvt;

Line 1415: mdebug('exception:FND_API.G_EXC_ERROR at l_error: '||l_error);

1411: EXCEPTION
1412:
1413: WHEN FND_API.G_EXC_ERROR THEN
1414: IF (l_debug = 1) THEN
1415: mdebug('exception:FND_API.G_EXC_ERROR at l_error: '||l_error);
1416: END IF;
1417: ROLLBACK TO wf_start_workflow_pvt;
1418: x_return_status := FND_API.G_RET_STS_ERROR;
1419: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 1418: x_return_status := FND_API.G_RET_STS_ERROR;

1414: IF (l_debug = 1) THEN
1415: mdebug('exception:FND_API.G_EXC_ERROR at l_error: '||l_error);
1416: END IF;
1417: ROLLBACK TO wf_start_workflow_pvt;
1418: x_return_status := FND_API.G_RET_STS_ERROR;
1419: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1420: ,p_data => x_msg_data);
1421:
1422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1418: x_return_status := FND_API.G_RET_STS_ERROR;
1419: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1420: ,p_data => x_msg_data);
1421:
1422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1423: IF (l_debug = 1) THEN
1424: mdebug('exception: FND_API.G_EXC_UNEXPECTED_ERROR at l_error: '||l_error);
1425: END IF;
1426: ROLLBACK TO wf_start_workflow_pvt;

Line 1424: mdebug('exception: FND_API.G_EXC_UNEXPECTED_ERROR at l_error: '||l_error);

1420: ,p_data => x_msg_data);
1421:
1422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1423: IF (l_debug = 1) THEN
1424: mdebug('exception: FND_API.G_EXC_UNEXPECTED_ERROR at l_error: '||l_error);
1425: END IF;
1426: ROLLBACK TO wf_start_workflow_pvt;
1427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1428: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 1427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1423: IF (l_debug = 1) THEN
1424: mdebug('exception: FND_API.G_EXC_UNEXPECTED_ERROR at l_error: '||l_error);
1425: END IF;
1426: ROLLBACK TO wf_start_workflow_pvt;
1427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1428: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1429: ,p_data => x_msg_data);
1430:
1431: WHEN OTHERS THEN

Line 1436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1432: IF (l_debug = 1) THEN
1433: mdebug('exception: in when otheres at l_error: '||l_error);
1434: END IF;
1435: ROLLBACK TO wf_start_workflow_pvt;
1436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1437: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1438: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1439: END IF;
1440: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 1456: lp_init_msg_lst VARCHAR2(250) := FND_API.G_FALSE;

1452: -- local variables
1453: l_workflow_name VARCHAR2(250) ;
1454: l_item_key VARCHAR2(250) ;
1455: lp_api_version_number NUMBER := 1.0;
1456: lp_init_msg_lst VARCHAR2(250) := FND_API.G_FALSE;
1457: lp_commit VARCHAR2(250) := FND_API.G_FALSE;
1458: lx_return_status VARCHAR2(1) ;
1459: lx_msg_count NUMBER ;
1460: lx_msg_data VARCHAR2(250);

Line 1457: lp_commit VARCHAR2(250) := FND_API.G_FALSE;

1453: l_workflow_name VARCHAR2(250) ;
1454: l_item_key VARCHAR2(250) ;
1455: lp_api_version_number NUMBER := 1.0;
1456: lp_init_msg_lst VARCHAR2(250) := FND_API.G_FALSE;
1457: lp_commit VARCHAR2(250) := FND_API.G_FALSE;
1458: lx_return_status VARCHAR2(1) ;
1459: lx_msg_count NUMBER ;
1460: lx_msg_data VARCHAR2(250);
1461: lp_organization_id NUMBER;

Line 1531: g_return_status := FND_API.G_RET_STS_SUCCESS; --Bug 6116046

1527: IF (l_debug = 1) THEN
1528: mdebug('before calling wms_txnrsn_actions_pub.suggest_alternate_location ');
1529: END IF;
1530:
1531: g_return_status := FND_API.G_RET_STS_SUCCESS; --Bug 6116046
1532: mdebug('Setting g_return_status to success');
1533: wms_txnrsn_actions_pub.suggest_alternate_location
1534: (p_api_version_number =>lp_api_version_number
1535: , p_init_msg_lst =>lp_init_msg_lst

Line 1598: WHEN fnd_api.g_exc_error THEN

1594: END IF;
1595:
1596: EXCEPTION
1597:
1598: WHEN fnd_api.g_exc_error THEN
1599: lx_return_status := fnd_api.g_ret_sts_error;
1600: --Bug 6116046 Begin
1601: mdebug('Setting g_return_status to fnd_api.g_ret_sts_error');
1602: g_return_status := fnd_api.g_ret_sts_error; --Bug 6116046

Line 1599: lx_return_status := fnd_api.g_ret_sts_error;

1595:
1596: EXCEPTION
1597:
1598: WHEN fnd_api.g_exc_error THEN
1599: lx_return_status := fnd_api.g_ret_sts_error;
1600: --Bug 6116046 Begin
1601: mdebug('Setting g_return_status to fnd_api.g_ret_sts_error');
1602: g_return_status := fnd_api.g_ret_sts_error; --Bug 6116046
1603:

Line 1601: mdebug('Setting g_return_status to fnd_api.g_ret_sts_error');

1597:
1598: WHEN fnd_api.g_exc_error THEN
1599: lx_return_status := fnd_api.g_ret_sts_error;
1600: --Bug 6116046 Begin
1601: mdebug('Setting g_return_status to fnd_api.g_ret_sts_error');
1602: g_return_status := fnd_api.g_ret_sts_error; --Bug 6116046
1603:
1604: mdebug('exception: fnd_api.g_exc_error');
1605: mdebug('wf_suggest_alt_loc lx_return_status to ' || lx_return_status);

Line 1602: g_return_status := fnd_api.g_ret_sts_error; --Bug 6116046

1598: WHEN fnd_api.g_exc_error THEN
1599: lx_return_status := fnd_api.g_ret_sts_error;
1600: --Bug 6116046 Begin
1601: mdebug('Setting g_return_status to fnd_api.g_ret_sts_error');
1602: g_return_status := fnd_api.g_ret_sts_error; --Bug 6116046
1603:
1604: mdebug('exception: fnd_api.g_exc_error');
1605: mdebug('wf_suggest_alt_loc lx_return_status to ' || lx_return_status);
1606:

Line 1604: mdebug('exception: fnd_api.g_exc_error');

1600: --Bug 6116046 Begin
1601: mdebug('Setting g_return_status to fnd_api.g_ret_sts_error');
1602: g_return_status := fnd_api.g_ret_sts_error; --Bug 6116046
1603:
1604: mdebug('exception: fnd_api.g_exc_error');
1605: mdebug('wf_suggest_alt_loc lx_return_status to ' || lx_return_status);
1606:
1607: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1608: itemkey => l_item_key,

Line 1654: WHEN fnd_api.g_exc_unexpected_error THEN

1650: );
1651: END IF;
1652:
1653:
1654: WHEN fnd_api.g_exc_unexpected_error THEN
1655: lx_return_status := fnd_api.g_ret_sts_unexp_error ;
1656:
1657: mdebug('Setting g_return_status to fnd_api.g_ret_sts_unexp_error');
1658:

Line 1655: lx_return_status := fnd_api.g_ret_sts_unexp_error ;

1651: END IF;
1652:
1653:
1654: WHEN fnd_api.g_exc_unexpected_error THEN
1655: lx_return_status := fnd_api.g_ret_sts_unexp_error ;
1656:
1657: mdebug('Setting g_return_status to fnd_api.g_ret_sts_unexp_error');
1658:
1659: g_return_status := fnd_api.g_ret_sts_unexp_error; --Bug 6116046

Line 1657: mdebug('Setting g_return_status to fnd_api.g_ret_sts_unexp_error');

1653:
1654: WHEN fnd_api.g_exc_unexpected_error THEN
1655: lx_return_status := fnd_api.g_ret_sts_unexp_error ;
1656:
1657: mdebug('Setting g_return_status to fnd_api.g_ret_sts_unexp_error');
1658:
1659: g_return_status := fnd_api.g_ret_sts_unexp_error; --Bug 6116046
1660:
1661: mdebug('exception: fnd_api.g_exc_unexpected_error');

Line 1659: g_return_status := fnd_api.g_ret_sts_unexp_error; --Bug 6116046

1655: lx_return_status := fnd_api.g_ret_sts_unexp_error ;
1656:
1657: mdebug('Setting g_return_status to fnd_api.g_ret_sts_unexp_error');
1658:
1659: g_return_status := fnd_api.g_ret_sts_unexp_error; --Bug 6116046
1660:
1661: mdebug('exception: fnd_api.g_exc_unexpected_error');
1662: mdebug('wf_suggest_alt_loc lx_return_status to ' || lx_return_status);
1663:

Line 1661: mdebug('exception: fnd_api.g_exc_unexpected_error');

1657: mdebug('Setting g_return_status to fnd_api.g_ret_sts_unexp_error');
1658:
1659: g_return_status := fnd_api.g_ret_sts_unexp_error; --Bug 6116046
1660:
1661: mdebug('exception: fnd_api.g_exc_unexpected_error');
1662: mdebug('wf_suggest_alt_loc lx_return_status to ' || lx_return_status);
1663:
1664: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1665: itemkey => l_item_key,

Line 1722: mdebug('exception: fnd_api.g_exc_unexpected_error');

1718: );
1719: END IF;
1720:
1721:
1722: mdebug('exception: fnd_api.g_exc_unexpected_error');
1723: mdebug('wf_suggest_alt_loc lx_return_status to ' || lx_return_status);
1724: g_return_status := fnd_api.g_ret_sts_unexp_error; --Bug 6116046
1725: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1726: itemkey => l_item_key,

Line 1724: g_return_status := fnd_api.g_ret_sts_unexp_error; --Bug 6116046

1720:
1721:
1722: mdebug('exception: fnd_api.g_exc_unexpected_error');
1723: mdebug('wf_suggest_alt_loc lx_return_status to ' || lx_return_status);
1724: g_return_status := fnd_api.g_ret_sts_unexp_error; --Bug 6116046
1725: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1726: itemkey => l_item_key,
1727: aname => 'XW_RETURN_STATUS',
1728: avalue => lx_return_status);

Line 1836: IF (g_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1832: aname => 'PW_INVENTORY_ITEM_ID');
1833: --Bug 6116046 Begin
1834: mdebug('g_return_status value is' || g_return_status);
1835:
1836: IF (g_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1837: IF (l_debug = 1) THEN
1838: mdebug('Throwing exception as g_return_status is not success');
1839: END IF;
1840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1836: IF (g_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1837: IF (l_debug = 1) THEN
1838: mdebug('Throwing exception as g_return_status is not success');
1839: END IF;
1840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1841: END IF;
1842: --Bug 6116046 End
1843:
1844: IF (l_debug = 1) THEN

Line 1855: p_init_msg_list => fnd_api.g_false,

1851:
1852: -- call a cycle count request for this location.
1853: wms_cycle_pvt.create_unscheduled_counts
1854: ( p_api_version => 1.0,
1855: p_init_msg_list => fnd_api.g_false,
1856: p_commit => fnd_api.g_false,
1857: x_return_status => x_return_status,
1858: x_msg_count => x_msg_count,
1859: x_msg_data => x_msg_data,

Line 1856: p_commit => fnd_api.g_false,

1852: -- call a cycle count request for this location.
1853: wms_cycle_pvt.create_unscheduled_counts
1854: ( p_api_version => 1.0,
1855: p_init_msg_list => fnd_api.g_false,
1856: p_commit => fnd_api.g_false,
1857: x_return_status => x_return_status,
1858: x_msg_count => x_msg_count,
1859: x_msg_data => x_msg_data,
1860: p_organization_id => l_organization_id,

Line 1865: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1861: p_subinventory => l_subinventory_code,
1862: p_locator_id => l_locator_id,
1863: p_inventory_item_id => l_inventory_item_id); --BUG #2867331
1864:
1865: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1866: IF (l_debug = 1) THEN
1867: mdebug('wms_cycle_pvt.create_unscheduled_counts failed');
1868: END IF;
1869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1865: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1866: IF (l_debug = 1) THEN
1867: mdebug('wms_cycle_pvt.create_unscheduled_counts failed');
1868: END IF;
1869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1870: END IF;
1871: IF (l_debug = 1) THEN
1872: mdebug('after calling wms_cycle_pvt.create_unscheduled_counts');
1873: END IF;

Line 1901: WHEN fnd_api.g_exc_error THEN

1897: avalue => x_msg_data);
1898:
1899: EXCEPTION
1900:
1901: WHEN fnd_api.g_exc_error THEN
1902: IF (l_debug = 1) THEN
1903: mdebug('exc error in wf_cycle_count');
1904: END IF;
1905: x_return_status := fnd_api.g_ret_sts_error;

Line 1905: x_return_status := fnd_api.g_ret_sts_error;

1901: WHEN fnd_api.g_exc_error THEN
1902: IF (l_debug = 1) THEN
1903: mdebug('exc error in wf_cycle_count');
1904: END IF;
1905: x_return_status := fnd_api.g_ret_sts_error;
1906: fnd_msg_pub.count_and_get
1907: ( p_count => x_msg_count,
1908: p_data => x_msg_data
1909: );

Line 1928: WHEN fnd_api.g_exc_unexpected_error THEN

1924: aname => 'XW_MSG_DATA',
1925: avalue => x_msg_data);
1926: --Bug 6116046 End
1927:
1928: WHEN fnd_api.g_exc_unexpected_error THEN
1929: IF (l_debug = 1) THEN
1930: mdebug('unexpected error in wf_cycle_count');
1931: END IF;
1932: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 1932: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1928: WHEN fnd_api.g_exc_unexpected_error THEN
1929: IF (l_debug = 1) THEN
1930: mdebug('unexpected error in wf_cycle_count');
1931: END IF;
1932: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1933: fnd_msg_pub.count_and_get
1934: ( p_count => x_msg_count,
1935: p_data => x_msg_data
1936: );

Line 1959: x_return_status := fnd_api.g_ret_sts_unexp_error;

1955: WHEN OTHERS THEN
1956: IF (l_debug = 1) THEN
1957: mdebug('others error in wf_cycle_count');
1958: END IF;
1959: x_return_status := fnd_api.g_ret_sts_unexp_error;
1960: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1961: THEN
1962: fnd_msg_pub.add_exc_msg
1963: ( g_pkg_name

Line 2056: RAISE fnd_api.g_exc_error;

2052: result :=wf_engine.eng_completed||':IS_TASK_PROCESS_NO';
2053:
2054: ELSE
2055: result :=wf_engine.eng_completed||':IS_TASK_PROCESS_ERROR';
2056: RAISE fnd_api.g_exc_error;
2057: END IF;
2058:
2059: EXCEPTION
2060: WHEN fnd_api.g_exc_error THEN

Line 2060: WHEN fnd_api.g_exc_error THEN

2056: RAISE fnd_api.g_exc_error;
2057: END IF;
2058:
2059: EXCEPTION
2060: WHEN fnd_api.g_exc_error THEN
2061: IF (l_debug = 1) THEN
2062: mdebug('exc error in wf_is_task_processed');
2063: END IF;
2064: x_return_status := fnd_api.g_ret_sts_error;

Line 2064: x_return_status := fnd_api.g_ret_sts_error;

2060: WHEN fnd_api.g_exc_error THEN
2061: IF (l_debug = 1) THEN
2062: mdebug('exc error in wf_is_task_processed');
2063: END IF;
2064: x_return_status := fnd_api.g_ret_sts_error;
2065: fnd_msg_pub.count_and_get
2066: ( p_count => x_msg_count,
2067: p_data => x_msg_data
2068: );

Line 2070: WHEN fnd_api.g_exc_unexpected_error THEN

2066: ( p_count => x_msg_count,
2067: p_data => x_msg_data
2068: );
2069:
2070: WHEN fnd_api.g_exc_unexpected_error THEN
2071: IF (l_debug = 1) THEN
2072: mdebug('unexpected error in wf_is_task_processed');
2073: END IF;
2074: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 2074: x_return_status := fnd_api.g_ret_sts_unexp_error ;

2070: WHEN fnd_api.g_exc_unexpected_error THEN
2071: IF (l_debug = 1) THEN
2072: mdebug('unexpected error in wf_is_task_processed');
2073: END IF;
2074: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2075: fnd_msg_pub.count_and_get
2076: ( p_count => x_msg_count,
2077: p_data => x_msg_data
2078: );

Line 2085: x_return_status := fnd_api.g_ret_sts_unexp_error;

2081: WHEN OTHERS THEN
2082: IF (l_debug = 1) THEN
2083: mdebug('others error in wf_is_task_processed at');
2084: END IF;
2085: x_return_status := fnd_api.g_ret_sts_unexp_error;
2086: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2087: THEN
2088: fnd_msg_pub.add_exc_msg
2089: ( g_pkg_name

Line 2177: IF (lx_return_status = fnd_api.g_ret_sts_success) THEN

2173: mdebug('after wms_task_utils_pvt.generate_next_task');
2174: mdebug('x_ret_code: '||lx_ret_code);
2175: END IF;
2176:
2177: IF (lx_return_status = fnd_api.g_ret_sts_success) THEN
2178: result :=wf_engine.eng_completed||':GEN_NEXT_TASK_YES';
2179: IF (l_debug = 1) THEN
2180: mdebug('In Generate Next Task -> Success');
2181: END IF;

Line 2197: WHEN fnd_api.g_exc_error THEN

2193: END IF;
2194: END IF;
2195:
2196: EXCEPTION
2197: WHEN fnd_api.g_exc_error THEN
2198: IF (l_debug = 1) THEN
2199: mdebug('exc error in wf_generate_next_task');
2200: END IF;
2201: lx_return_status := fnd_api.g_ret_sts_error;

Line 2201: lx_return_status := fnd_api.g_ret_sts_error;

2197: WHEN fnd_api.g_exc_error THEN
2198: IF (l_debug = 1) THEN
2199: mdebug('exc error in wf_generate_next_task');
2200: END IF;
2201: lx_return_status := fnd_api.g_ret_sts_error;
2202: fnd_msg_pub.count_and_get
2203: ( p_count => lx_msg_count,
2204: p_data => lx_msg_data
2205: );

Line 2207: WHEN fnd_api.g_exc_unexpected_error THEN

2203: ( p_count => lx_msg_count,
2204: p_data => lx_msg_data
2205: );
2206:
2207: WHEN fnd_api.g_exc_unexpected_error THEN
2208: IF (l_debug = 1) THEN
2209: mdebug('unexpected error in wf_generate_next_task');
2210: END IF;
2211: lx_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 2211: lx_return_status := fnd_api.g_ret_sts_unexp_error ;

2207: WHEN fnd_api.g_exc_unexpected_error THEN
2208: IF (l_debug = 1) THEN
2209: mdebug('unexpected error in wf_generate_next_task');
2210: END IF;
2211: lx_return_status := fnd_api.g_ret_sts_unexp_error ;
2212: fnd_msg_pub.count_and_get
2213: ( p_count => lx_msg_count,
2214: p_data => lx_msg_data
2215: );

Line 2222: lx_return_status := fnd_api.g_ret_sts_unexp_error;

2218: WHEN OTHERS THEN
2219: IF (l_debug = 1) THEN
2220: mdebug('others error in wf_generate_next_task');
2221: END IF;
2222: lx_return_status := fnd_api.g_ret_sts_unexp_error;
2223: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2224: THEN
2225: fnd_msg_pub.add_exc_msg
2226: ( g_pkg_name

Line 2319: x_return_status := fnd_api.g_ret_sts_success;

2315: -- Set savepoint for this API
2316: SAVEPOINT wms_insuff_qty_PUB;
2317:
2318: -- Initialize API return status to success
2319: x_return_status := fnd_api.g_ret_sts_success;
2320: IF p_tsk_id>0 THEN
2321: -- get necessary data to call workflow
2322: SELECT transaction_temp_id
2323: INTO l_transaction_temp_id

Line 2426: WHEN FND_API.G_EXC_ERROR THEN

2422: );
2423: END IF;
2424: EXCEPTION
2425:
2426: WHEN FND_API.G_EXC_ERROR THEN
2427: --
2428: x_return_status := FND_API.G_RET_STS_ERROR;
2429: --
2430: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 2428: x_return_status := FND_API.G_RET_STS_ERROR;

2424: EXCEPTION
2425:
2426: WHEN FND_API.G_EXC_ERROR THEN
2427: --
2428: x_return_status := FND_API.G_RET_STS_ERROR;
2429: --
2430: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
2431: ,p_data => x_msg_data);
2432: --

Line 2433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2429: --
2430: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
2431: ,p_data => x_msg_data);
2432: --
2433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2434: --
2435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2436: --
2437: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 2435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2431: ,p_data => x_msg_data);
2432: --
2433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2434: --
2435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2436: --
2437: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
2438: ,p_data => x_msg_data);
2439: --

Line 2443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2439: --
2440: WHEN OTHERS THEN
2441: ROLLBACK TO wms_insuff_qty_PUB;
2442: --
2443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2444: --
2445: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2446: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2447: END IF;

Line 2493: ; lp_init_msg_lst VARCHAR2(250) := FND_API.G_FALSE

2489: -- local variables
2490: l_workflow_name VARCHAR2(250)
2491: ; l_item_key VARCHAR2(250)
2492: ; lp_api_version_number NUMBER := 1.0
2493: ; lp_init_msg_lst VARCHAR2(250) := FND_API.G_FALSE
2494: ; lp_commit VARCHAR2(250) := FND_API.G_FALSE
2495: ; lx_return_status VARCHAR2(1)
2496: ; lx_msg_count NUMBER
2497: ; lx_msg_data VARCHAR2(250)

Line 2494: ; lp_commit VARCHAR2(250) := FND_API.G_FALSE

2490: l_workflow_name VARCHAR2(250)
2491: ; l_item_key VARCHAR2(250)
2492: ; lp_api_version_number NUMBER := 1.0
2493: ; lp_init_msg_lst VARCHAR2(250) := FND_API.G_FALSE
2494: ; lp_commit VARCHAR2(250) := FND_API.G_FALSE
2495: ; lx_return_status VARCHAR2(1)
2496: ; lx_msg_count NUMBER
2497: ; lx_msg_data VARCHAR2(250)
2498: ; lp_organization_id NUMBER

Line 2636: if (lx_return_status = fnd_api.g_ret_sts_success) then

2632:
2633:
2634: -- if successful, populate the workflow attribute XW_IS_RESERVATION_SUCCESSFUL
2635: -- with 'Y', otherwise populate with 'N'
2636: if (lx_return_status = fnd_api.g_ret_sts_success) then
2637: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
2638: itemkey => l_item_key,
2639: aname => 'XW_IS_RESERVATION_SUCCESSFUL',
2640: avalue => 'YES');

Line 2649: WHEN fnd_api.g_exc_error THEN

2645: avalue => 'NO');
2646: end if;
2647: EXCEPTION
2648:
2649: WHEN fnd_api.g_exc_error THEN
2650: lx_return_status := fnd_api.g_ret_sts_error;
2651:
2652: WHEN fnd_api.g_exc_unexpected_error THEN
2653: lx_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 2650: lx_return_status := fnd_api.g_ret_sts_error;

2646: end if;
2647: EXCEPTION
2648:
2649: WHEN fnd_api.g_exc_error THEN
2650: lx_return_status := fnd_api.g_ret_sts_error;
2651:
2652: WHEN fnd_api.g_exc_unexpected_error THEN
2653: lx_return_status := fnd_api.g_ret_sts_unexp_error ;
2654:

Line 2652: WHEN fnd_api.g_exc_unexpected_error THEN

2648:
2649: WHEN fnd_api.g_exc_error THEN
2650: lx_return_status := fnd_api.g_ret_sts_error;
2651:
2652: WHEN fnd_api.g_exc_unexpected_error THEN
2653: lx_return_status := fnd_api.g_ret_sts_unexp_error ;
2654:
2655: WHEN OTHERS THEN
2656: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

Line 2653: lx_return_status := fnd_api.g_ret_sts_unexp_error ;

2649: WHEN fnd_api.g_exc_error THEN
2650: lx_return_status := fnd_api.g_ret_sts_error;
2651:
2652: WHEN fnd_api.g_exc_unexpected_error THEN
2653: lx_return_status := fnd_api.g_ret_sts_unexp_error ;
2654:
2655: WHEN OTHERS THEN
2656: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2657: THEN