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.CUG_GENERIC_WF_PKG dependencies on FND_API

Line 130: RAISE fnd_api.g_exc_unexpected_error;

126: ELSE
127: OPEN l_IncidentAddress_csr;
128: FETCH l_IncidentAddress_csr INTO l_IncidentAddress_rec;
129: IF (l_IncidentAddress_csr%NOTFOUND) THEN
130: RAISE fnd_api.g_exc_unexpected_error;
131: END IF;
132:
133: l_incident_address := l_IncidentAddress_rec.address1 || ',' ||
134: l_IncidentAddress_rec.address2 || ',' ||

Line 338: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) OR

334: p_employee_id => l_source_id,
335: p_role_name => l_owner_role,
336: p_role_display_name => l_owner_name );
337:
338: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) OR
339: (l_owner_role is NULL) THEN
340: IF(FND_PROFILE.Value('CUG_DEFAULT_SR_WF_ROLE') is null) THEN
341: wf_core.context( pkg_name => 'CUG_GENERIC_WKFLW_PKG',
342: proc_name => 'Replace_SR_Owner',

Line 740: RAISE fnd_api.g_exc_unexpected_error;

736: p_duplicate_time_frame => l_duplicate_date);
737:
738:
739: IF (l_duplicate_date IS NULL) THEN
740: RAISE fnd_api.g_exc_unexpected_error;
741: END IF;
742:
743: -- Begin changes by ANEEMUCH 13-May-2002
744: /*

Line 748: RAISE fnd_api.g_exc_unexpected_error;

744: /*
745: OPEN l_IncidentAddress_csr;
746: FETCH l_IncidentAddress_csr into l_IncidentAddress_rec;
747: IF (l_IncidentAddress_csr%NOTFOUND) THEN
748: RAISE fnd_api.g_exc_unexpected_error;
749: END IF;
750: */
751: -- End of changes by ANEEMUCH 13-May-2002
752:

Line 815: RAISE fnd_api.g_exc_unexpected_error;

811: p_duplicate_time_frame => l_duplicate_date);
812:
813:
814: IF (l_duplicate_date IS NULL) THEN
815: RAISE fnd_api.g_exc_unexpected_error;
816: END IF;
817:
818:
819: l_match_found := 1;

Line 880: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

876: result := 'N';
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

Line 965: IF NOT (l_return_status = fnd_api.g_ret_sts_success)

961: p_creation_date => sysdate,
962: p_note_type => 'Duplicate Service Request'
963: );
964:
965: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
966: THEN
967: l_return_status := fnd_api.g_ret_sts_unexp_error;
968: RAISE fnd_api.g_exc_unexpected_error;
969: END IF;

Line 967: l_return_status := fnd_api.g_ret_sts_unexp_error;

963: );
964:
965: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
966: THEN
967: l_return_status := fnd_api.g_ret_sts_unexp_error;
968: RAISE fnd_api.g_exc_unexpected_error;
969: END IF;
970:
971: JTF_NOTES_PUB.Create_note_context (

Line 968: RAISE fnd_api.g_exc_unexpected_error;

964:
965: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
966: THEN
967: l_return_status := fnd_api.g_ret_sts_unexp_error;
968: RAISE fnd_api.g_exc_unexpected_error;
969: END IF;
970:
971: JTF_NOTES_PUB.Create_note_context (
972: x_return_status => l_return_status,

Line 982: IF NOT (l_return_status = fnd_api.g_ret_sts_success)

978: p_note_context_type => 'Duplicate',
979: x_note_context_id => l_note_context_id);
980:
981:
982: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
983: THEN
984: l_return_status := fnd_api.g_ret_sts_unexp_error;
985: RAISE fnd_api.g_exc_unexpected_error;
986: END IF;

Line 984: l_return_status := fnd_api.g_ret_sts_unexp_error;

980:
981:
982: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
983: THEN
984: l_return_status := fnd_api.g_ret_sts_unexp_error;
985: RAISE fnd_api.g_exc_unexpected_error;
986: END IF;
987: */
988:

Line 985: RAISE fnd_api.g_exc_unexpected_error;

981:
982: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
983: THEN
984: l_return_status := fnd_api.g_ret_sts_unexp_error;
985: RAISE fnd_api.g_exc_unexpected_error;
986: END IF;
987: */
988:
989: SELECT jtf_notes_s.NEXTVAL INTO l_note_context_id FROM dual;

Line 1021: RAISE fnd_api.g_exc_unexpected_error;

1017: l_created_by,
1018: l_last_update_login);
1019:
1020: ELSE
1021: RAISE fnd_api.g_exc_unexpected_error;
1022: END IF;
1023: END IF;
1024:
1025: EXCEPTION

Line 1161: RAISE fnd_api.g_exc_unexpected_error;

1157: IF (l_SRTasks_rec.sr_attribute_code IS NOT NULL) THEN
1158: OPEN c_SRAttr_Value_csr;
1159: FETCH c_SRAttr_Value_csr into l_SRAttr_Value_rec;
1160: IF (c_SRAttr_Value_csr%NOTFOUND) THEN
1161: RAISE fnd_api.g_exc_unexpected_error;
1162: ELSIF (l_SRAttr_Value_rec.sr_attribute_value IS NULL) THEN
1163: null;
1164: ELSE
1165: l_sr_attribute_value := l_SRAttr_Value_rec.sr_attribute_value;

Line 1260: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN

1256: x_task_id => l_task_id
1257: );
1258:
1259: /* 08/30 -- begin - to fix bug# 1964265 */
1260: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
1261: result := 'N';
1262: ELSE
1263: /* 08/30 -- end - to fix bug# 1964265 */
1264:

Line 1312: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1308: x_msg_count => l_msg_count,
1309: x_msg_data => l_msg_data
1310: );
1311:
1312: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1313: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1314: END IF;
1315:
1316: END IF;

Line 1313: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1309: x_msg_data => l_msg_data
1310: );
1311:
1312: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1313: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1314: END IF;
1315:
1316: END IF;
1317: CLOSE c_Workflow_Check_csr;

Line 1329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1325:
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

Line 1589: RAISE fnd_api.g_exc_unexpected_error;

1585:
1586: OPEN c_DuplicateTimeInfo_csr;
1587: FETCH c_DuplicateTimeInfo_csr INTO l_DuplicateTimeInfo_rec;
1588: IF (c_DuplicateTimeInfo_csr%NOTFOUND) THEN
1589: RAISE fnd_api.g_exc_unexpected_error;
1590: END IF;
1591:
1592: l_duplicate_uom := l_DuplicateTimeInfo_rec.duplicate_uom;
1593:

Line 1597: RAISE fnd_api.g_exc_unexpected_error;

1593:
1594: OPEN c_UOM_Conversion_Rate_csr;
1595: FETCH c_UOM_Conversion_Rate_csr into l_UOM_Conversion_Rate_rec;
1596: IF (c_UOM_Conversion_Rate_csr%NOTFOUND) THEN
1597: RAISE fnd_api.g_exc_unexpected_error;
1598: END IF;
1599:
1600: IF ( l_DuplicateTimeInfo_rec.duplicate_uom = 'Day') THEN
1601: l_multiple_by := 1;

Line 1688: x_return_status := fnd_api.g_ret_sts_success;

1684:
1685:
1686:
1687: SAVEPOINT start_task_workflow;
1688: x_return_status := fnd_api.g_ret_sts_success;
1689: l_task_dep_id := p_tsk_typ_attr_dep_id;
1690:
1691: IF fnd_api.to_boolean (p_init_msg_list)
1692: THEN

Line 1691: IF fnd_api.to_boolean (p_init_msg_list)

1687: SAVEPOINT start_task_workflow;
1688: x_return_status := fnd_api.g_ret_sts_success;
1689: l_task_dep_id := p_tsk_typ_attr_dep_id;
1690:
1691: IF fnd_api.to_boolean (p_init_msg_list)
1692: THEN
1693: fnd_msg_pub.initialize;
1694: END IF;
1695:

Line 1712: RAISE fnd_api.g_exc_unexpected_error;

1708: IF c_task_details%NOTFOUND
1709: THEN
1710: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_ID');
1711: fnd_msg_pub.add;
1712: RAISE fnd_api.g_exc_unexpected_error;
1713: END IF;
1714: CLOSE c_task_details;
1715:
1716:

Line 1786: raise fnd_api.g_exc_unexpected_error;

1782: /* Roopa
1783: l_owner_user_name := jtf_rs_resource_pub.get_wf_role( l_owner_id );
1784:
1785: if l_owner_user_name is null then
1786: raise fnd_api.g_exc_unexpected_error;
1787: end if ;
1788: End Roopa */
1789:
1790:

Line 1829: IF fnd_api.to_boolean (p_commit)

1825: itemtype => 'JTFTASK',
1826: itemkey => l_itemkey
1827: );
1828:
1829: IF fnd_api.to_boolean (p_commit)
1830: THEN
1831: -- COMMIT WORK;
1832: return;
1833: END IF;

Line 1839: WHEN fnd_api.g_exc_unexpected_error

1835:
1836: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1837:
1838: EXCEPTION
1839: WHEN fnd_api.g_exc_unexpected_error
1840: THEN
1841: ROLLBACK TO start_task_workflow;
1842: x_return_status := fnd_api.g_ret_sts_unexp_error;
1843: fnd_msg_pub.count_and_get (

Line 1842: x_return_status := fnd_api.g_ret_sts_unexp_error;

1838: EXCEPTION
1839: WHEN fnd_api.g_exc_unexpected_error
1840: THEN
1841: ROLLBACK TO start_task_workflow;
1842: x_return_status := fnd_api.g_ret_sts_unexp_error;
1843: fnd_msg_pub.count_and_get (
1844: p_count => x_msg_count,
1845: p_data => x_msg_data
1846: );

Line 1860: x_return_status := fnd_api.g_ret_sts_unexp_error;

1856: fnd_message.set_token('ERROR_STACK', l_errstack);
1857: fnd_msg_pub.add;
1858: end if;
1859:
1860: x_return_status := fnd_api.g_ret_sts_unexp_error;
1861: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1862: END;
1863:
1864:

Line 2013: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) OR

2009: p_employee_id => l_ServiceRequest_rec.incident_owner_id,
2010: p_role_name => l_owner_role,
2011: p_role_display_name => l_owner_name );
2012:
2013: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) OR
2014: (l_owner_role is NULL) THEN
2015: wf_core.context( pkg_name => 'CS_WORKFLOW_PUB',
2016: proc_name => 'Get_Employee_Role',
2017: arg1 => 'p_employee_id=>'||

Line 2133: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2129: p_itemkey => itemkey,
2130: p_request_number => l_request_number,
2131: p_wf_process_id => l_dummy );
2132:
2133: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2134: wf_core.context( pkg_name => 'CS_WORKFLOW_PUB',
2135: proc_name => 'Decode_Servereq_Itemkey',
2136: arg1 => 'p_itemkey=>'||itemkey );
2137: l_errmsg_name := 'CS_WF_SR_CANT_DECODE_ITEMKEY';