1: Package Body CUG_GENERIC_WF_PKG AS
2: /* $Header: CUGGNWFB.pls 115.29 2003/03/28 19:56:55 rhungund noship $ */
3: --
4: -- To modify this template, edit file PKGBODY.TXT in TEMPLATE
5: -- directory of SQL Navigator
180: result := 'Y';
181:
182: EXCEPTION
183: WHEN l_API_ERROR THEN
184: WF_CORE.Context('CUG_GENERIC_WF_PKG', 'GET_OTHER_SR_ATTRIBUTES',
185: itemtype, itemkey, actid, funmode);
186: RAISE;
187: WHEN OTHERS THEN
188: WF_CORE.Context('CUG_GENERIC_WF_PKG', 'GET_OTHER_SR_ATTRIBUTES',
184: WF_CORE.Context('CUG_GENERIC_WF_PKG', 'GET_OTHER_SR_ATTRIBUTES',
185: itemtype, itemkey, actid, funmode);
186: RAISE;
187: WHEN OTHERS THEN
188: WF_CORE.Context('CUG_GENERIC_WF_PKG', 'GET_OTHER_SR_ATTRIBUTES',
189: itemtype, itemkey, actid, funmode);
190: RAISE;
191:
192: END GET_OTHER_SR_ATTRIBUTES;
389: EXCEPTION
390: WHEN l_API_ERROR THEN
391: WF_CORE.Raise(l_errmsg_name);
392: WHEN OTHERS THEN
393: WF_CORE.Context('CUG_GENERIC_WF_PKG', 'REPLACE_SR_OWNER',
394: itemtype, itemkey, actid, funmode);
395: RAISE;
396: END REPLACE_SR_OWNER;
397:
444: END IF;
445:
446: EXCEPTION
447: WHEN l_API_ERROR THEN
448: WF_CORE.Context('CUG_GENERIC_WF_PKG', 'ALLOW_ADDRESS_OVERWRITE',
449: itemtype, itemkey, actid, funmode);
450: RAISE;
451: WHEN OTHERS THEN
452: WF_CORE.Context('CUG_GENERIC_WF_PKG', 'ALLOW_ADDRESS_OVERWRITE',
448: WF_CORE.Context('CUG_GENERIC_WF_PKG', 'ALLOW_ADDRESS_OVERWRITE',
449: itemtype, itemkey, actid, funmode);
450: RAISE;
451: WHEN OTHERS THEN
452: WF_CORE.Context('CUG_GENERIC_WF_PKG', 'ALLOW_ADDRESS_OVERWRITE',
453: itemtype, itemkey, actid, funmode);
454: RAISE;
455:
456: END ALLOW_ADDRESS_OVERWRITE;
508: END IF;
509:
510: EXCEPTION
511: WHEN l_API_ERROR THEN
512: WF_CORE.Context('CUG_GENERIC_WF_PKG', 'DUPLICATE_CHECKING_REQUIRED',
513: itemtype, itemkey, actid, funmode);
514: RAISE;
515: WHEN OTHERS THEN
516: WF_CORE.Context('CUG_GENERIC_WF_PKG', 'DUPLICATE_CHECKING_REQUIRED',
512: WF_CORE.Context('CUG_GENERIC_WF_PKG', 'DUPLICATE_CHECKING_REQUIRED',
513: itemtype, itemkey, actid, funmode);
514: RAISE;
515: WHEN OTHERS THEN
516: WF_CORE.Context('CUG_GENERIC_WF_PKG', 'DUPLICATE_CHECKING_REQUIRED',
517: itemtype, itemkey, actid, funmode);
518: RAISE;
519: END DUPLICATE_CHECKING_REQUIRED;
520:
877: END IF;
878:
879: EXCEPTION
880: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
881: WF_CORE.Context('CUG_GENERIC_WF_PKG', 'SR_A_DUPLICATE',
882: itemtype, itemkey, actid, funmode);
883: RAISE;
884: WHEN l_API_ERROR THEN
885: WF_CORE.Context('CUG_GENERIC_WF_PKG', 'SR_A_DUPLICATE',
881: WF_CORE.Context('CUG_GENERIC_WF_PKG', 'SR_A_DUPLICATE',
882: itemtype, itemkey, actid, funmode);
883: RAISE;
884: WHEN l_API_ERROR THEN
885: WF_CORE.Context('CUG_GENERIC_WF_PKG', 'SR_A_DUPLICATE',
886: itemtype, itemkey, actid, funmode);
887: RAISE;
888: WHEN OTHERS THEN
889: WF_CORE.Context('CUG_GENERIC_WF_PKG', 'SR_A_DUPLICATE',
885: WF_CORE.Context('CUG_GENERIC_WF_PKG', 'SR_A_DUPLICATE',
886: itemtype, itemkey, actid, funmode);
887: RAISE;
888: WHEN OTHERS THEN
889: WF_CORE.Context('CUG_GENERIC_WF_PKG', 'SR_A_DUPLICATE',
890: itemtype, itemkey, actid, funmode);
891: RAISE;
892:
893:
1023: END IF;
1024:
1025: EXCEPTION
1026: WHEN l_API_ERROR THEN
1027: WF_CORE.Context('CUG_GENERIC_WF_PKG', 'UPDATE_DUPLICATE_INFO',
1028: itemtype, itemkey, actid, funmode);
1029: RAISE;
1030: WHEN OTHERS THEN
1031: WF_CORE.Context('CUG_GENERIC_WF_PKG', 'UPDATE_DUPLICATE_INFO',
1027: WF_CORE.Context('CUG_GENERIC_WF_PKG', 'UPDATE_DUPLICATE_INFO',
1028: itemtype, itemkey, actid, funmode);
1029: RAISE;
1030: WHEN OTHERS THEN
1031: WF_CORE.Context('CUG_GENERIC_WF_PKG', 'UPDATE_DUPLICATE_INFO',
1032: itemtype, itemkey, actid, funmode);
1033: RAISE;
1034:
1035:
1326: END IF; -- If funmode = 'run'
1327:
1328: EXCEPTION
1329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1330: WF_CORE.Context('CUG_GENERIC_WF_PKG', 'CREATE_ALL_SR_TASKS',
1331: itemtype, itemkey, actid, funmode);
1332: RAISE;
1333: WHEN l_API_ERROR THEN
1334: WF_CORE.Context('CUG_GENERIC_WF_PKG', 'CREATE_ALL_SR_TASKS',
1330: WF_CORE.Context('CUG_GENERIC_WF_PKG', 'CREATE_ALL_SR_TASKS',
1331: itemtype, itemkey, actid, funmode);
1332: RAISE;
1333: WHEN l_API_ERROR THEN
1334: WF_CORE.Context('CUG_GENERIC_WF_PKG', 'CREATE_ALL_SR_TASKS',
1335: itemtype, itemkey, actid, funmode);
1336: RAISE;
1337: WHEN OTHERS THEN
1338: WF_CORE.Context('CUG_GENERIC_WF_PKG', 'CREATE_ALL_SR_TASKS',
1334: WF_CORE.Context('CUG_GENERIC_WF_PKG', 'CREATE_ALL_SR_TASKS',
1335: itemtype, itemkey, actid, funmode);
1336: RAISE;
1337: WHEN OTHERS THEN
1338: WF_CORE.Context('CUG_GENERIC_WF_PKG', 'CREATE_ALL_SR_TASKS',
1339: itemtype, itemkey, actid, funmode);
1340: RAISE;
1341: END CREATE_ALL_SR_TASKS;
1342:
1510: END IF;
1511:
1512: EXCEPTION
1513: WHEN l_API_ERROR THEN
1514: WF_CORE.Context('CUG_GENERIC_WF_PKG', 'CHECK_ON_TASK_STATUS',
1515: itemtype, itemkey, actid, funmode);
1516: RAISE;
1517: WHEN OTHERS THEN
1518: WF_CORE.Context('CUG_GENERIC_WF_PKG', 'CHECK_ON_TASK_STATUS',
1514: WF_CORE.Context('CUG_GENERIC_WF_PKG', 'CHECK_ON_TASK_STATUS',
1515: itemtype, itemkey, actid, funmode);
1516: RAISE;
1517: WHEN OTHERS THEN
1518: WF_CORE.Context('CUG_GENERIC_WF_PKG', 'CHECK_ON_TASK_STATUS',
1519: itemtype, itemkey, actid, funmode);
1520: RAISE;
1521:
1522: END CHECK_ON_TASK_STATUS;
2079: CLOSE l_ServiceRequest_csr;
2080: END IF;
2081: WF_CORE.Raise(l_errmsg_name);
2082: WHEN OTHERS THEN
2083: WF_CORE.Context('CUG_GENERIC_WF_PKG', 'Update_CIC_Request_Info',
2084: itemtype, itemkey, actid, funmode);
2085: RAISE;
2086:
2087: END Update_CIC_Request_Info;
2179: EXCEPTION
2180: WHEN l_API_ERROR THEN
2181: WF_CORE.Raise(l_errmsg_name);
2182: WHEN OTHERS THEN
2183: WF_CORE.Context('CUG_GENERIC_WF_PKG', 'CIC_Initialize_Request',
2184: itemtype, itemkey, actid, funmode);
2185: RAISE;
2186:
2187: END CIC_Initialize_Request;