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

Line 259: x_return_status := FND_API.G_RET_STS_SUCCESS;

255:
256: BEGIN
257: l_task_id := jtf_tasks_pub.p_task_user_hooks.task_id;
258:
259: x_return_status := FND_API.G_RET_STS_SUCCESS;
260:
261: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
262: RETURN;
263: END IF;

Line 279: x_return_status := FND_API.G_RET_STS_ERROR;

275: csm_task_event_pkg.task_ins_init(p_task_id=>l_task_id);
276:
277: EXCEPTION
278: WHEN OTHERS THEN
279: x_return_status := FND_API.G_RET_STS_ERROR;
280: l_sqlerrno := to_char(SQLCODE);
281: l_sqlerrmsg := substr(SQLERRM, 1,2000);
282: l_error_msg := ' Exception in TASK_POST_INS for task_id:'
283: || to_char(l_task_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line 301: x_return_status := FND_API.G_RET_STS_SUCCESS;

297:
298: l_task_id JTF_TASKS_B.TASK_ID%TYPE;
299:
300: BEGIN
301: x_return_status := FND_API.G_RET_STS_SUCCESS;
302:
303: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
304: RETURN;
305: END IF;

Line 313: x_return_status := FND_API.G_RET_STS_ERROR;

309: csm_task_event_pkg.task_del_init(p_task_id=>l_task_id);
310:
311: EXCEPTION
312: WHEN OTHERS THEN
313: x_return_status := FND_API.G_RET_STS_ERROR;
314: l_sqlerrno := to_char(SQLCODE);
315: l_sqlerrmsg := substr(SQLERRM, 1,2000);
316: l_error_msg := ' Exception in TASK_POST_DEL for task_id:'
317: || to_char(l_task_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line 385: x_return_status := FND_API.G_RET_STS_SUCCESS;

381: BEGIN
382:
383: l_task_assignment_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id;
384:
385: x_return_status := FND_API.G_RET_STS_SUCCESS;
386:
387: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
388: RETURN;
389: END IF;

Line 429: x_return_status := FND_API.G_RET_STS_ERROR;

425: RAISE_START_AUTO_SYNC_EVENT('CSM_TASK_ASSIGNMENTS',to_char(l_task_assignment_id),'NEW');
426:
427: EXCEPTION
428: WHEN OTHERS THEN
429: x_return_status := FND_API.G_RET_STS_ERROR;
430: l_sqlerrno := to_char(SQLCODE);
431: l_sqlerrmsg := substr(SQLERRM, 1,2000);
432: l_error_msg := l_error_msg || '-Exception for Task_Assignment_Post_Ins :' || TO_CHAR(l_task_assignment_id)
433: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line 469: x_return_status := FND_API.G_RET_STS_SUCCESS;

465: FROM jtf_rs_resource_extns jtrs
466: WHERE jtrs.resource_id = p_resource_id;
467:
468: BEGIN
469: x_return_status := FND_API.G_RET_STS_SUCCESS;
470:
471: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
472: RETURN;
473: END IF;

Line 509: x_return_status := FND_API.G_RET_STS_ERROR;

505: END IF;
506:
507: EXCEPTION
508: WHEN OTHERS THEN
509: x_return_status := FND_API.G_RET_STS_ERROR;
510: l_sqlerrno := to_char(SQLCODE);
511: l_sqlerrmsg := substr(SQLERRM, 1,2000);
512: l_error_msg := l_error_msg || '-Exception for Task_Assignment_Pre_Upd :' || TO_CHAR(l_task_assignment_id)
513: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line 607: x_return_status := FND_API.G_RET_STS_SUCCESS;

603: BEGIN
604:
605: l_task_assignment_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id;
606:
607: x_return_status := FND_API.G_RET_STS_SUCCESS;
608:
609: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
610: RETURN;
611: END IF;

Line 797: x_return_status := FND_API.G_RET_STS_ERROR;

793: 'CSM_WF_PKG.Task_Assignment_Post_Upd',FND_LOG.LEVEL_PROCEDURE);
794:
795: EXCEPTION
796: WHEN OTHERS THEN
797: x_return_status := FND_API.G_RET_STS_ERROR;
798: l_sqlerrno := to_char(SQLCODE);
799: l_sqlerrmsg := substr(SQLERRM, 1,2000);
800: l_error_msg := l_error_msg || '-Exception for Task_Assignment_Post_Upd :' || TO_CHAR(l_task_assignment_id)
801: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line 829: x_return_status := FND_API.G_RET_STS_SUCCESS;

825: BEGIN
826:
827: l_task_assignment_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id;
828:
829: x_return_status := FND_API.G_RET_STS_SUCCESS;
830:
831: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
832: RETURN;
833: END IF;

Line 840: x_return_status := FND_API.G_RET_STS_ERROR ;

836: p_error_msg=>l_error_msg,
837: x_return_status=>l_return_status);
838: EXCEPTION
839: WHEN OTHERS THEN
840: x_return_status := FND_API.G_RET_STS_ERROR ;
841: l_sqlerrno := to_char(SQLCODE);
842: l_sqlerrmsg := substr(SQLERRM, 1,2000);
843: l_error_msg := l_error_msg || '-Exception for Task_Assignment_Post_Del :' || TO_CHAR(l_task_assignment_id)
844: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line 886: x_return_status := FND_API.G_RET_STS_SUCCESS;

882: WHERE TASK_ID = b_task_id;
883:
884:
885: BEGIN
886: x_return_status := FND_API.G_RET_STS_SUCCESS;
887:
888: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
889: RETURN;
890: END IF;

Line 913: x_return_status := FND_API.G_RET_STS_ERROR;

909: CLOSE l_task_pre_upd_csr;
910:
911: EXCEPTION
912: WHEN OTHERS THEN
913: x_return_status := FND_API.G_RET_STS_ERROR;
914: l_sqlerrno := to_char(SQLCODE);
915: l_sqlerrmsg := substr(SQLERRM, 1,2000);
916: l_error_msg := 'Exception in Task_Pre_Upd for task_id:' || TO_CHAR(l_jtf_task_id)
917: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line 996: x_return_status := FND_API.G_RET_STS_SUCCESS;

992:
993: BEGIN
994: l_jtf_task_id := jtf_tasks_pub.p_task_user_hooks.task_id;
995:
996: x_return_status := FND_API.G_RET_STS_SUCCESS;
997:
998: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
999: RETURN;
1000: END IF;

Line 1165: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1161: CSM_UTIL_PKG.LOG('Do updates for task_id:' || l_jtf_task_id ,
1162: 'CSM_WF_PKG.Task_Post_Upd',FND_LOG.LEVEL_PROCEDURE);
1163:
1164: csm_task_event_pkg.TASK_MAKE_DIRTY_U_FOREACHUSER(l_jtf_task_id,l_error_msg, l_return_status);
1165: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1166: csm_util_pkg.LOG(l_error_msg, 'CSM_WF_PKG.Task_Pre_Upd', FND_LOG.LEVEL_ERROR);
1167: END IF;
1168:
1169: CSM_UTIL_PKG.LOG('Leaving CSM_WF_PKG.Task_Post_Upd for task_id:' || l_jtf_task_id ,

Line 1178: x_return_status := FND_API.G_RET_STS_ERROR;

1174:
1175:
1176: EXCEPTION
1177: WHEN OTHERS THEN
1178: x_return_status := FND_API.G_RET_STS_ERROR;
1179: l_sqlerrno := to_char(SQLCODE);
1180: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1181: l_error_msg := l_error_msg || '-' || 'Exception in Task_Post_Upd for task_id:' || l_jtf_task_id
1182: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line 1244: x_return_status := FND_API.G_RET_STS_SUCCESS;

1240: BEGIN
1241:
1242: l_incident_id := cs_servicerequest_pvt.user_hooks_rec.request_id;
1243:
1244: x_return_status := FND_API.G_RET_STS_SUCCESS;
1245:
1246: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
1247: RETURN;
1248: END IF;

Line 1266: x_return_status := FND_API.G_RET_STS_ERROR ;

1262: csm_sr_event_pkg.sr_ins_init(l_incident_id);
1263:
1264: EXCEPTION
1265: WHEN OTHERS THEN
1266: x_return_status := FND_API.G_RET_STS_ERROR ;
1267: l_sqlerrno := to_char(SQLCODE);
1268: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1269: l_error_msg := l_error_msg || '- Exception in SR_Post_Ins for incident_id:'
1270: || TO_CHAR(l_incident_id) || l_sqlerrno || ':' || l_sqlerrmsg;

Line 1338: x_return_status := FND_API.G_RET_STS_SUCCESS;

1334:
1335: l_sr_cont_pts_pre_upd_rec l_sr_cont_pts_pre_upd_csr%ROWTYPE;
1336:
1337: BEGIN
1338: x_return_status := FND_API.G_RET_STS_SUCCESS;
1339:
1340: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
1341: RETURN;
1342: END IF;

Line 1397: x_return_status := FND_API.G_RET_STS_ERROR;

1393: CLOSE l_sr_cont_pts_pre_upd_csr;
1394:
1395: EXCEPTION
1396: WHEN OTHERS THEN
1397: x_return_status := FND_API.G_RET_STS_ERROR;
1398: l_sqlerrno := to_char(SQLCODE);
1399: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1400: l_error_msg := 'Exception in sr_pre_upd for incident_id:' || TO_CHAR(l_incident_id)
1401: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line 1529: x_return_status := FND_API.G_RET_STS_SUCCESS;

1525: BEGIN
1526:
1527: l_incident_id := cs_servicerequest_pvt.user_hooks_rec.request_id;
1528:
1529: x_return_status := FND_API.G_RET_STS_SUCCESS;
1530:
1531:
1532: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
1533: RETURN;

Line 1722: x_return_status := FND_API.G_RET_STS_ERROR;

1718: RAISE_START_AUTO_SYNC_EVENT('CSM_INCIDENTS_ALL',to_char(l_incident_id),'UPDATE');
1719:
1720: EXCEPTION
1721: WHEN OTHERS THEN
1722: x_return_status := FND_API.G_RET_STS_ERROR;
1723: l_sqlerrno := to_char(SQLCODE);
1724: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1725: l_error_msg := 'Exception in sr_post_upd for incident_id:' || TO_CHAR(l_incident_id)
1726: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line 1751: x_return_status := FND_API.G_RET_STS_SUCCESS;

1747: l_sqlerrno VARCHAR2(20);
1748: l_sqlerrmsg VARCHAR2(2000);
1749:
1750: BEGIN
1751: x_return_status := FND_API.G_RET_STS_SUCCESS;
1752:
1753: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
1754: RETURN;
1755: END IF;

Line 1762: x_return_status := FND_API.G_RET_STS_ERROR;

1758: p_group_id=>p_group_id);
1759: CSM_PO_LOCATIONS_EVENT_PKG.GRP_ADDRESS_I(p_group_id,p_resource_id);
1760: EXCEPTION
1761: WHEN OTHERS THEN
1762: x_return_status := FND_API.G_RET_STS_ERROR;
1763: l_sqlerrno := to_char(SQLCODE);
1764: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1765: CSM_UTIL_PKG.LOG('Exception in JTF_RS_Group_Member_Post_Ins for resource_id: ' || TO_CHAR(p_resource_id)
1766: || ' and group_id: ' || TO_CHAR(p_group_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg,

Line 1804: x_return_status := FND_API.G_RET_STS_SUCCESS;

1800: l_sqlerrmsg VARCHAR2(2000);
1801:
1802: BEGIN
1803:
1804: x_return_status := FND_API.G_RET_STS_SUCCESS;
1805:
1806: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
1807: RETURN;
1808: END IF;

Line 1815: x_return_status := FND_API.G_RET_STS_ERROR;

1811: p_group_id=>p_group_id);
1812: CSM_PO_LOCATIONS_EVENT_PKG.GRP_ADDRESS_D(p_group_id,p_resource_id);
1813: EXCEPTION
1814: WHEN OTHERS THEN
1815: x_return_status := FND_API.G_RET_STS_ERROR;
1816: l_sqlerrno := to_char(SQLCODE);
1817: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1818: CSM_UTIL_PKG.LOG('Exception in JTF_RS_Group_Member_Pre_Del for resource_id: ' || TO_CHAR(p_resource_id)
1819: || ' and group_id: ' || TO_CHAR(p_group_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg,

Line 1842: x_return_status := FND_API.G_RET_STS_SUCCESS;

1838:
1839: BEGIN
1840: l_debrief_header_id := CSF_DEBRIEF_HEADERS_PKG.user_hooks_rec.debrief_header_id;
1841:
1842: x_return_status := FND_API.G_RET_STS_SUCCESS;
1843:
1844: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
1845: RETURN;
1846: END IF;

Line 1853: x_return_status := FND_API.G_RET_STS_ERROR;

1849: p_h_user_id=>NULL,
1850: p_flow_type=>NULL);
1851: EXCEPTION
1852: WHEN OTHERS THEN
1853: x_return_status := FND_API.G_RET_STS_ERROR;
1854: l_sqlerrno := to_char(SQLCODE);
1855: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1856: l_error_msg := 'Exception in CSF_Debrief_Header_Post_Ins for debrief_header_id:' || TO_CHAR(l_debrief_header_id)
1857: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line 1864: x_return_status := FND_API.G_RET_STS_SUCCESS;

1860:
1861: PROCEDURE CSF_Debrief_Header_Pre_Upd(x_return_status OUT NOCOPY VARCHAR2)
1862: IS
1863: BEGIN
1864: x_return_status := FND_API.G_RET_STS_SUCCESS;
1865: END CSF_Debrief_Header_Pre_Upd;
1866:
1867: PROCEDURE CSF_Debrief_Header_Post_Upd(x_return_status OUT NOCOPY VARCHAR2)
1868: IS

Line 1883: x_return_status := FND_API.G_RET_STS_SUCCESS;

1879: FROM csm_debrief_headers_acc acc
1880: WHERE acc.debrief_header_id = p_debrief_header_id;
1881:
1882: BEGIN
1883: x_return_status := FND_API.G_RET_STS_SUCCESS;
1884:
1885: l_debrief_header_id := CSF_DEBRIEF_Headers_PKG.user_hooks_rec.debrief_header_id;
1886:
1887: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN

Line 1900: x_return_status := FND_API.G_RET_STS_ERROR;

1896: END LOOP;
1897:
1898: EXCEPTION
1899: WHEN OTHERS THEN
1900: x_return_status := FND_API.G_RET_STS_ERROR;
1901: l_sqlerrno := to_char(SQLCODE);
1902: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1903: l_error_msg := 'Exception in CSF_Debrief_Header_Post_Upd for debrief_header_id:' || TO_CHAR(l_debrief_header_id)
1904: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line 1941: x_return_status := FND_API.G_RET_STS_SUCCESS;

1937:
1938: l_csm_debrfHdDel_rec l_csm_debrfHdDel_csr%ROWTYPE;
1939:
1940: BEGIN
1941: x_return_status := FND_API.G_RET_STS_SUCCESS;
1942:
1943: l_debrief_header_id := CSF_DEBRIEF_HEADERS_PKG.user_hooks_rec.debrief_header_id;
1944:
1945: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN

Line 1962: x_return_status := FND_API.G_RET_STS_ERROR;

1958: p_user_id=>l_csm_debrfHdDel_rec.user_id,
1959: p_flow_type=>NULL);
1960: EXCEPTION
1961: WHEN OTHERS THEN
1962: x_return_status := FND_API.G_RET_STS_ERROR;
1963: l_sqlerrno := to_char(SQLCODE);
1964: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1965: l_error_msg := 'Exception in CSF_Debrief_Header_Post_Del for debrief_header_id:' || TO_CHAR(l_debrief_header_id)
1966: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line 1986: x_return_status := FND_API.G_RET_STS_SUCCESS;

1982: l_error_msg VARCHAR2(4000);
1983: l_return_status VARCHAR2(2000);
1984:
1985: BEGIN
1986: x_return_status := FND_API.G_RET_STS_SUCCESS;
1987:
1988: l_debrief_line_id := CSF_DEBRIEF_LINES_PKG.user_hooks_rec.debrief_line_id;
1989:
1990: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN

Line 2000: x_return_status := FND_API.G_RET_STS_ERROR;

1996: p_flow_type=>NULL);
1997:
1998: EXCEPTION
1999: WHEN OTHERS THEN
2000: x_return_status := FND_API.G_RET_STS_ERROR;
2001: l_sqlerrno := to_char(SQLCODE);
2002: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2003: l_error_msg := 'Exception in CSF_Debrief_Line_Post_Ins for debrief_Line_id:' || TO_CHAR(l_debrief_line_id)
2004: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line 2030: x_return_status := FND_API.G_RET_STS_SUCCESS;

2026: FROM csf_debrief_lines
2027: WHERE debrief_line_id = p_debrief_line_id;
2028:
2029: BEGIN
2030: x_return_status := FND_API.G_RET_STS_SUCCESS;
2031:
2032: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2033: RETURN;
2034: END IF;

Line 2048: x_return_status := FND_API.G_RET_STS_ERROR;

2044: CLOSE l_debrief_line_pre_upd;
2045:
2046: EXCEPTION
2047: WHEN OTHERS THEN
2048: x_return_status := FND_API.G_RET_STS_ERROR;
2049: l_sqlerrno := to_char(SQLCODE);
2050: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2051: l_error_msg := 'Exception in CSF_Debrief_Line_Pre_Upd for debrief_Line_id:' || TO_CHAR(l_debrief_line_id)
2052: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line 2078: x_return_status := FND_API.G_RET_STS_SUCCESS;

2074:
2075: r_debrief_line_post_upd_rec l_debrief_line_post_upd%ROWTYPE;
2076:
2077: BEGIN
2078: x_return_status := FND_API.G_RET_STS_SUCCESS;
2079:
2080: l_debrief_line_id := CSF_DEBRIEF_LINES_PKG.user_hooks_rec.debrief_line_id;
2081:
2082: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN

Line 2116: x_return_status := FND_API.G_RET_STS_ERROR;

2112:
2113:
2114: EXCEPTION
2115: WHEN OTHERS THEN
2116: x_return_status := FND_API.G_RET_STS_ERROR;
2117: l_sqlerrno := to_char(SQLCODE);
2118: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2119: l_error_msg := 'Exception in CSF_Debrief_Line_Post_Upd for debrief_Line_id:' || TO_CHAR(l_debrief_line_id)
2120: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line 2147: x_return_status := FND_API.G_RET_STS_SUCCESS;

2143:
2144: l_csm_debrfLnDel_rec l_csm_debrfLnDel_csr%ROWTYPE;
2145:
2146: BEGIN
2147: x_return_status := FND_API.G_RET_STS_SUCCESS;
2148:
2149: l_debrief_line_id := CSF_DEBRIEF_LINES_PKG.user_hooks_rec.debrief_line_id;
2150:
2151: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN

Line 2168: x_return_status := FND_API.G_RET_STS_ERROR;

2164: p_user_id=>l_csm_debrfLnDel_rec.user_id,
2165: p_flow_type=>NULL);
2166: EXCEPTION
2167: WHEN OTHERS THEN
2168: x_return_status := FND_API.G_RET_STS_ERROR;
2169: l_sqlerrno := to_char(SQLCODE);
2170: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2171: l_error_msg := 'Exception in CSF_Debrief_Line_Post_Del for debrief_Line_id:' || TO_CHAR(l_debrief_line_id)
2172: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line 2183: x_return_status := FND_API.G_RET_STS_SUCCESS;

2179: l_sqlerrno VARCHAR2(20);
2180: l_sqlerrmsg VARCHAR2(2000);
2181:
2182: BEGIN
2183: x_return_status := FND_API.G_RET_STS_SUCCESS;
2184:
2185: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2186: RETURN;
2187: END IF;

Line 2201: x_return_status := FND_API.G_RET_STS_ERROR;

2197: 'CSM_WF_PKG.CSP_Inv_Loc_Assignmnt_Post_Ins', FND_LOG.LEVEL_PROCEDURE );
2198:
2199: EXCEPTION
2200: WHEN OTHERS THEN
2201: x_return_status := FND_API.G_RET_STS_ERROR;
2202: l_sqlerrno := to_char(SQLCODE);
2203: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2204: CSM_UTIL_PKG.LOG('Exception in CSP_Inv_Loc_Assignmnt_Post_Ins for csp_inv_loc_assignment_id: ' || TO_CHAR(l_csp_inv_loc_assignment_id)
2205: || ':' || l_sqlerrno || ':' || l_sqlerrmsg,

Line 2233: x_return_status := FND_API.G_RET_STS_SUCCESS;

2229: WHERE cila.csp_inv_loc_assignment_id = p_csp_inv_loc_assignment_id
2230: AND au.resource_id = cila.resource_id;
2231:
2232: BEGIN
2233: x_return_status := FND_API.G_RET_STS_SUCCESS;
2234:
2235: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2236: RETURN;
2237: END IF;

Line 2270: x_return_status := FND_API.G_RET_STS_ERROR;

2266: CSM_UTIL_PKG.LOG('Leaving CSP_Inv_Loc_Assignmnt_Pre_Upd for csp_inv_loc_assignment_id: ' || TO_CHAR(l_csp_inv_loc_assignment_id),
2267: 'CSM_WF_PKG.CSP_Inv_Loc_Assignmnt_Pre_Upd', FND_LOG.LEVEL_PROCEDURE );
2268: EXCEPTION
2269: WHEN OTHERS THEN
2270: x_return_status := FND_API.G_RET_STS_ERROR;
2271: l_sqlerrno := to_char(SQLCODE);
2272: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2273: CSM_UTIL_PKG.LOG('Exception in CSP_Inv_Loc_Assignmnt_Pre_Upd for csp_inv_loc_assignment_id: ' || TO_CHAR(l_csp_inv_loc_assignment_id)
2274: || ':' || l_sqlerrno || ':' || l_sqlerrmsg,

Line 2306: x_return_status := FND_API.G_RET_STS_SUCCESS;

2302: WHERE cila.csp_inv_loc_assignment_id = p_csp_inv_loc_assignment_id
2303: AND au.resource_id = cila.resource_id;
2304:
2305: BEGIN
2306: x_return_status := FND_API.G_RET_STS_SUCCESS;
2307:
2308: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2309: RETURN;
2310: END IF;

Line 2343: x_return_status := FND_API.G_RET_STS_ERROR;

2339: END IF;
2340:
2341: EXCEPTION
2342: WHEN OTHERS THEN
2343: x_return_status := FND_API.G_RET_STS_ERROR;
2344: l_sqlerrno := to_char(SQLCODE);
2345: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2346: CSM_UTIL_PKG.LOG('Exception in CSP_Inv_Loc_Assignmnt_Post_Upd for csp_inv_loc_assignment_id: ' || TO_CHAR(l_csp_inv_loc_assignment_id)
2347: || ':' || l_sqlerrno || ':' || l_sqlerrmsg,

Line 2358: x_return_status := FND_API.G_RET_STS_SUCCESS;

2354: l_sqlerrno VARCHAR2(20);
2355: l_sqlerrmsg VARCHAR2(2000);
2356:
2357: BEGIN
2358: x_return_status := FND_API.G_RET_STS_SUCCESS;
2359:
2360: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2361: RETURN;
2362: END IF;

Line 2376: x_return_status := FND_API.G_RET_STS_ERROR;

2372: 'CSM_WF_PKG.CSP_Inv_Loc_Assg_Post_Del', FND_LOG.LEVEL_PROCEDURE );
2373:
2374: EXCEPTION
2375: WHEN OTHERS THEN
2376: x_return_status := FND_API.G_RET_STS_ERROR;
2377: l_sqlerrno := to_char(SQLCODE);
2378: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2379: CSM_UTIL_PKG.LOG('Exception in CSP_Inv_Loc_Assg_Post_Del for csp_inv_loc_assignment_id: ' || TO_CHAR(l_csp_inv_loc_assignment_id)
2380: || ':' || l_sqlerrno || ':' || l_sqlerrmsg,

Line 2422: x_return_status := FND_API.G_RET_STS_SUCCESS;

2418: AND acc.org_id = pla.org_id
2419: AND acc.RESOURCE_TYPE= decode(rcr.resource_type,'RS_GROUP','G','E'));
2420:
2421: BEGIN
2422: x_return_status := FND_API.G_RET_STS_SUCCESS;
2423:
2424: l_location_id := csp_ship_to_address_pvt.g_inv_loc_id;
2425:
2426: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN

Line 2449: x_return_status := FND_API.G_RET_STS_ERROR;

2445: FND_LOG.LEVEL_PROCEDURE );
2446:
2447: EXCEPTION
2448: WHEN OTHERS THEN
2449: x_return_status := FND_API.G_RET_STS_ERROR;
2450: l_sqlerrno := to_char(SQLCODE);
2451: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2452: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_SHIP_TO_ADDRESS_POST_INS:' || l_sqlerrno || ':' || l_sqlerrmsg,
2453: 'CSM_WF_PKG.CSP_SHIP_TO_ADDRESS_POST_INS', FND_LOG.LEVEL_EXCEPTION);

Line 2473: x_return_status := FND_API.G_RET_STS_SUCCESS;

2469: FROM csm_po_loc_ass_all_acc acc
2470: WHERE acc.location_id = p_locationid;
2471:
2472: BEGIN
2473: x_return_status := FND_API.G_RET_STS_SUCCESS;
2474:
2475: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2476: RETURN;
2477: END IF;

Line 2506: x_return_status := FND_API.G_RET_STS_ERROR;

2502: FND_LOG.LEVEL_PROCEDURE );
2503:
2504: EXCEPTION
2505: WHEN OTHERS THEN
2506: x_return_status := FND_API.G_RET_STS_ERROR;
2507: l_sqlerrno := to_char(SQLCODE);
2508: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2509: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_SHIP_TO_ADDRESS_POST_UPD:' || l_sqlerrno || ':' || l_sqlerrmsg,
2510: 'CSM_WF_PKG.CSP_SHIP_TO_ADDRESS_POST_UPD', FND_LOG.LEVEL_EXCEPTION);

Line 2540: x_return_status := FND_API.G_RET_STS_SUCCESS;

2536: AND jtrs.resource_id = ta.resource_id
2537: ;
2538:
2539: BEGIN
2540: x_return_status := FND_API.G_RET_STS_SUCCESS;
2541:
2542: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2543: RETURN;
2544: END IF;

Line 2566: x_return_status := FND_API.G_RET_STS_ERROR;

2562: FND_LOG.LEVEL_PROCEDURE );
2563:
2564: EXCEPTION
2565: WHEN OTHERS THEN
2566: x_return_status := FND_API.G_RET_STS_ERROR;
2567: l_sqlerrno := to_char(SQLCODE);
2568: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2569: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_HEADERS_POST_INS:' || l_sqlerrno || ':' || l_sqlerrmsg,
2570: 'CSM_WF_PKG.CSP_REQ_HEADERS_POST_INS', FND_LOG.LEVEL_EXCEPTION);

Line 2587: x_return_status := FND_API.G_RET_STS_SUCCESS;

2583: FROM csm_req_headers_acc acc
2584: WHERE acc.requirement_header_id = p_req_header_id;
2585:
2586: BEGIN
2587: x_return_status := FND_API.G_RET_STS_SUCCESS;
2588:
2589: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2590: RETURN;
2591: END IF;

Line 2608: x_return_status := FND_API.G_RET_STS_ERROR;

2604: FND_LOG.LEVEL_PROCEDURE );
2605:
2606: EXCEPTION
2607: WHEN OTHERS THEN
2608: x_return_status := FND_API.G_RET_STS_ERROR;
2609: l_sqlerrno := to_char(SQLCODE);
2610: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2611: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_HEADERS_POST_UPD:' || l_sqlerrno || ':' || l_sqlerrmsg,
2612: 'CSM_WF_PKG.CSP_REQ_HEADERS_POST_UPD', FND_LOG.LEVEL_EXCEPTION);

Line 2628: x_return_status := FND_API.G_RET_STS_SUCCESS;

2624: FROM csm_req_headers_acc acc
2625: WHERE acc.requirement_header_id = p_req_header_id;
2626:
2627: BEGIN
2628: x_return_status := FND_API.G_RET_STS_SUCCESS;
2629:
2630: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2631: RETURN;
2632: END IF;

Line 2649: x_return_status := FND_API.G_RET_STS_ERROR;

2645: FND_LOG.LEVEL_PROCEDURE );
2646:
2647: EXCEPTION
2648: WHEN OTHERS THEN
2649: x_return_status := FND_API.G_RET_STS_ERROR;
2650: l_sqlerrno := to_char(SQLCODE);
2651: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2652: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_HEADERS_POST_DEL:' || l_sqlerrno || ':' || l_sqlerrmsg,
2653: 'CSM_WF_PKG.CSP_REQ_HEADERS_POST_DEL', FND_LOG.LEVEL_EXCEPTION);

Line 2689: x_return_status := FND_API.G_RET_STS_SUCCESS;

2685: AND jtrs.resource_id = ta.resource_id
2686: ;
2687:
2688: BEGIN
2689: x_return_status := FND_API.G_RET_STS_SUCCESS;
2690:
2691: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2692: RETURN;
2693: END IF;

Line 2715: x_return_status := FND_API.G_RET_STS_ERROR;

2711: FND_LOG.LEVEL_PROCEDURE );
2712:
2713: EXCEPTION
2714: WHEN OTHERS THEN
2715: x_return_status := FND_API.G_RET_STS_ERROR;
2716: l_sqlerrno := to_char(SQLCODE);
2717: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2718: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_LINES_POST_INS:' || l_sqlerrno || ':' || l_sqlerrmsg,
2719: 'CSM_WF_PKG.CSP_REQ_LINES_POST_INS', FND_LOG.LEVEL_EXCEPTION);

Line 2735: x_return_status := FND_API.G_RET_STS_SUCCESS;

2731: FROM csm_req_lines_acc acc
2732: WHERE acc.requirement_line_id = p_req_line_id;
2733:
2734: BEGIN
2735: x_return_status := FND_API.G_RET_STS_SUCCESS;
2736:
2737: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2738: RETURN;
2739: END IF;

Line 2756: x_return_status := FND_API.G_RET_STS_ERROR;

2752: FND_LOG.LEVEL_PROCEDURE );
2753:
2754: EXCEPTION
2755: WHEN OTHERS THEN
2756: x_return_status := FND_API.G_RET_STS_ERROR;
2757: l_sqlerrno := to_char(SQLCODE);
2758: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2759: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_LINES_POST_UPD:' || l_sqlerrno || ':' || l_sqlerrmsg,
2760: 'CSM_WF_PKG.CSP_REQ_LINES_POST_UPD', FND_LOG.LEVEL_EXCEPTION);

Line 2776: x_return_status := FND_API.G_RET_STS_SUCCESS;

2772: FROM csm_req_lines_acc acc
2773: WHERE acc.requirement_line_id = p_req_line_id;
2774:
2775: BEGIN
2776: x_return_status := FND_API.G_RET_STS_SUCCESS;
2777:
2778: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2779: RETURN;
2780: END IF;

Line 2797: x_return_status := FND_API.G_RET_STS_ERROR;

2793: CSM_UTIL_PKG.LOG('Leaving CSM_WF_PKG.CSP_REQ_LINES_POST_DEL', 'CSM_WF_PKG.CSP_REQ_LINES_POST_DEL',
2794: FND_LOG.LEVEL_PROCEDURE );
2795: EXCEPTION
2796: WHEN OTHERS THEN
2797: x_return_status := FND_API.G_RET_STS_ERROR;
2798: l_sqlerrno := to_char(SQLCODE);
2799: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2800: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_LINES_POST_DEL:' || l_sqlerrno || ':' || l_sqlerrmsg,
2801: 'CSM_WF_PKG.CSP_REQ_LINES_POST_DEL', FND_LOG.LEVEL_EXCEPTION);

Line 2812: x_return_status := FND_API.G_RET_STS_SUCCESS;

2808: l_sqlerrno varchar2(20);
2809: l_sqlerrmsg varchar2(2000);
2810:
2811: BEGIN
2812: x_return_status := FND_API.G_RET_STS_SUCCESS;
2813:
2814: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2815: RETURN;
2816: END IF;

Line 2837: x_return_status := FND_API.G_RET_STS_ERROR;

2833: FND_LOG.LEVEL_PROCEDURE );
2834:
2835: EXCEPTION
2836: WHEN OTHERS THEN
2837: x_return_status := FND_API.G_RET_STS_ERROR;
2838: l_sqlerrno := to_char(SQLCODE);
2839: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2840: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_INS:' || l_sqlerrno || ':' || l_sqlerrmsg,
2841: 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_INS', FND_LOG.LEVEL_EXCEPTION);

Line 2842: x_return_status := FND_API.G_RET_STS_ERROR;

2838: l_sqlerrno := to_char(SQLCODE);
2839: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2840: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_INS:' || l_sqlerrno || ':' || l_sqlerrmsg,
2841: 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_INS', FND_LOG.LEVEL_EXCEPTION);
2842: x_return_status := FND_API.G_RET_STS_ERROR;
2843: END CSP_REQ_LINE_DETAILS_POST_INS;
2844:
2845: PROCEDURE CSP_REQ_LINE_DETAILS_POST_UPD(x_return_status OUT NOCOPY varchar2)
2846: IS

Line 2853: x_return_status := FND_API.G_RET_STS_SUCCESS;

2849: l_sqlerrno varchar2(20);
2850: l_sqlerrmsg varchar2(2000);
2851:
2852: BEGIN
2853: x_return_status := FND_API.G_RET_STS_SUCCESS;
2854:
2855: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2856: RETURN;
2857: END IF;

Line 2872: x_return_status := FND_API.G_RET_STS_ERROR;

2868: FND_LOG.LEVEL_PROCEDURE );
2869:
2870: EXCEPTION
2871: WHEN OTHERS THEN
2872: x_return_status := FND_API.G_RET_STS_ERROR;
2873: l_sqlerrno := to_char(SQLCODE);
2874: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2875: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_UPD:' || l_sqlerrno || ':' || l_sqlerrmsg,
2876: 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_UPD', FND_LOG.LEVEL_EXCEPTION);

Line 2877: x_return_status := FND_API.G_RET_STS_ERROR;

2873: l_sqlerrno := to_char(SQLCODE);
2874: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2875: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_UPD:' || l_sqlerrno || ':' || l_sqlerrmsg,
2876: 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_UPD', FND_LOG.LEVEL_EXCEPTION);
2877: x_return_status := FND_API.G_RET_STS_ERROR;
2878: END CSP_REQ_LINE_DETAILS_POST_UPD;
2879:
2880: PROCEDURE CSP_REQ_LINE_DETAILS_PRE_DEL(x_return_status OUT NOCOPY varchar2)
2881: IS

Line 2888: x_return_status := FND_API.G_RET_STS_SUCCESS;

2884: l_sqlerrno varchar2(20);
2885: l_sqlerrmsg varchar2(2000);
2886:
2887: BEGIN
2888: x_return_status := FND_API.G_RET_STS_SUCCESS;
2889:
2890: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2891: RETURN;
2892: END IF;

Line 2907: x_return_status := FND_API.G_RET_STS_ERROR;

2903: FND_LOG.LEVEL_PROCEDURE );
2904:
2905: EXCEPTION
2906: WHEN OTHERS THEN
2907: x_return_status := FND_API.G_RET_STS_ERROR;
2908: l_sqlerrno := to_char(SQLCODE);
2909: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2910: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_LINE_DETAILS_PRE_DEL:' || l_sqlerrno || ':' || l_sqlerrmsg,
2911: 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_PRE_DEL', FND_LOG.LEVEL_EXCEPTION);

Line 2944: x_return_status := FND_API.G_RET_STS_SUCCESS;

2940: l_error_msg VARCHAR2(4000);
2941: l_return_status VARCHAR2(2000);
2942:
2943: BEGIN
2944: x_return_status := FND_API.G_RET_STS_SUCCESS;
2945:
2946: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2947: RETURN;
2948: END IF;

Line 2951: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2947: RETURN;
2948: END IF;
2949:
2950: csm_notes_event_pkg.notes_make_dirty_i_foreachuser(p_jtf_note_id,l_error_msg,l_return_status);
2951: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2952: csm_util_pkg.LOG(l_error_msg, 'CSM_WF_PKG.JTF_Note_Post_Ins', FND_LOG.LEVEL_ERROR);
2953: END IF;
2954:
2955: EXCEPTION

Line 2957: x_return_status := FND_API.G_RET_STS_ERROR ;

2953: END IF;
2954:
2955: EXCEPTION
2956: WHEN OTHERS THEN
2957: x_return_status := FND_API.G_RET_STS_ERROR ;
2958: l_sqlerrno := to_char(SQLCODE);
2959: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2960: l_error_msg := l_error_msg || '- Exception in JTF_Note_Post_Ins for note_id:'
2961: || TO_CHAR(p_jtf_note_id) || l_sqlerrno || ':' || l_sqlerrmsg;

Line 2995: x_return_status := FND_API.G_RET_STS_SUCCESS;

2991: l_error_msg VARCHAR2(4000);
2992: l_return_status VARCHAR2(4000);
2993:
2994: BEGIN
2995: x_return_status := FND_API.G_RET_STS_SUCCESS;
2996:
2997: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2998: RETURN;
2999: END IF;

Line 3002: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2998: RETURN;
2999: END IF;
3000:
3001: csm_notes_event_pkg.notes_make_dirty_i_foreachuser(p_jtf_note_id, l_error_msg, l_return_status);
3002: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3003: csm_util_pkg.LOG(l_error_msg, 'CSM_WF_PKG.JTF_Note_Pre_Upd', FND_LOG.LEVEL_ERROR);
3004: END IF;
3005:
3006: EXCEPTION

Line 3008: x_return_status := FND_API.G_RET_STS_ERROR ;

3004: END IF;
3005:
3006: EXCEPTION
3007: WHEN OTHERS THEN
3008: x_return_status := FND_API.G_RET_STS_ERROR ;
3009: l_sqlerrno := to_char(SQLCODE);
3010: l_sqlerrmsg := substr(SQLERRM, 1,2000);
3011: l_error_msg := l_error_msg || '- Exception in JTF_Note_PRE_Upd for note_id:'
3012: || TO_CHAR(p_jtf_note_id) || l_sqlerrno || ':' || l_sqlerrmsg;

Line 3030: x_return_status := FND_API.G_RET_STS_SUCCESS;

3026: l_sqlerrmsg VARCHAR2(4000);
3027: l_error_msg VARCHAR2(4000);
3028: l_return_status VARCHAR2(4000);
3029: BEGIN
3030: x_return_status := FND_API.G_RET_STS_SUCCESS;
3031: EXCEPTION
3032: WHEN OTHERS THEN
3033: x_return_status := FND_API.G_RET_STS_ERROR ;
3034: l_sqlerrno := to_char(SQLCODE);

Line 3033: x_return_status := FND_API.G_RET_STS_ERROR ;

3029: BEGIN
3030: x_return_status := FND_API.G_RET_STS_SUCCESS;
3031: EXCEPTION
3032: WHEN OTHERS THEN
3033: x_return_status := FND_API.G_RET_STS_ERROR ;
3034: l_sqlerrno := to_char(SQLCODE);
3035: l_sqlerrmsg := substr(SQLERRM, 1,2000);
3036: l_error_msg := l_error_msg || '- Exception in JTF_Note_POST_Upd for note_id:'
3037: || TO_CHAR(p_jtf_note_id) || l_sqlerrno || ':' || l_sqlerrmsg;

Line 3110: x_return_status := FND_API.G_RET_STS_SUCCESS;

3106: l_return_status VARCHAR2(2000);
3107: l_instance_id csi_item_instances.instance_id%TYPE;
3108:
3109: BEGIN
3110: x_return_status := FND_API.G_RET_STS_SUCCESS;
3111:
3112: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
3113: RETURN;
3114: END IF;

Line 3117: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3113: RETURN;
3114: END IF;
3115:
3116: CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCE_MDIRTY_U_ECHUSER(p_instance_id, l_error_msg, l_return_status);
3117: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3118: csm_util_pkg.LOG(l_error_msg, 'CSM_WF_PKG.CSI_Item_Instance_Pre_Upd', FND_LOG.LEVEL_ERROR);
3119: END IF;
3120:
3121: EXCEPTION

Line 3123: x_return_status := FND_API.G_RET_STS_ERROR;

3119: END IF;
3120:
3121: EXCEPTION
3122: WHEN OTHERS THEN
3123: x_return_status := FND_API.G_RET_STS_ERROR;
3124: l_sqlerrno := to_char(SQLCODE);
3125: l_sqlerrmsg := substr(SQLERRM, 1,2000);
3126: l_error_msg := 'Exception in CSI_Item_Instance_Pre_Upd for instance_id:' || TO_CHAR(p_instance_id)
3127: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line 3133: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

3129: END CSI_Item_Instance_Pre_Upd;
3130:
3131: Procedure CS_Counter_Post_Ins(
3132: P_Api_Version IN NUMBER,
3133: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3134: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3135: X_Return_Status OUT NOCOPY VARCHAR2,
3136: X_Msg_Count OUT NOCOPY NUMBER,
3137: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 3134: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

3130:
3131: Procedure CS_Counter_Post_Ins(
3132: P_Api_Version IN NUMBER,
3133: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3134: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3135: X_Return_Status OUT NOCOPY VARCHAR2,
3136: X_Msg_Count OUT NOCOPY NUMBER,
3137: X_Msg_Data OUT NOCOPY VARCHAR2,
3138: p_counter_id IN NUMBER,

Line 3150: x_return_status := FND_API.G_RET_STS_SUCCESS;

3146: l_error_msg VARCHAR2(4000);
3147: l_return_status VARCHAR2(2000);
3148:
3149: BEGIN
3150: x_return_status := FND_API.G_RET_STS_SUCCESS;
3151:
3152: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
3153: RETURN;
3154: END IF;

Line 3157: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3153: RETURN;
3154: END IF;
3155:
3156: csm_counter_event_pkg.CTR_MAKE_DIRTY_I_FOREACHUSER(p_counter_id, l_error_msg, l_return_status);
3157: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3158: csm_util_pkg.LOG(l_error_msg, 'CSM_WF_PKG.CS_Counter_Post_Ins', FND_LOG.LEVEL_ERROR);
3159: END IF;
3160:
3161: EXCEPTION

Line 3163: x_return_status := FND_API.G_RET_STS_ERROR;

3159: END IF;
3160:
3161: EXCEPTION
3162: WHEN OTHERS THEN
3163: x_return_status := FND_API.G_RET_STS_ERROR;
3164: l_sqlerrno := to_char(SQLCODE);
3165: l_sqlerrmsg := substr(SQLERRM, 1,2000);
3166: l_error_msg := 'Exception in CS_Counter_Post_Ins for counter_id:' || TO_CHAR(p_counter_id)
3167: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line 3173: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

3169: END CS_Counter_Post_Ins;
3170:
3171: Procedure CS_Counter_Pre_Del(
3172: P_Api_Version IN NUMBER,
3173: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3174: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3175: X_Return_Status OUT NOCOPY VARCHAR2,
3176: X_Msg_Count OUT NOCOPY NUMBER,
3177: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 3174: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

3170:
3171: Procedure CS_Counter_Pre_Del(
3172: P_Api_Version IN NUMBER,
3173: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3174: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3175: X_Return_Status OUT NOCOPY VARCHAR2,
3176: X_Msg_Count OUT NOCOPY NUMBER,
3177: X_Msg_Data OUT NOCOPY VARCHAR2,
3178: p_counter_id IN NUMBER

Line 3187: x_return_status := FND_API.G_RET_STS_SUCCESS;

3183: l_error_msg VARCHAR2(4000);
3184: l_return_status VARCHAR2(2000);
3185:
3186: BEGIN
3187: x_return_status := FND_API.G_RET_STS_SUCCESS;
3188:
3189: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
3190: RETURN;
3191: END IF;

Line 3194: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3190: RETURN;
3191: END IF;
3192:
3193: csm_counter_event_pkg.COUNTER_MDIRTY_D(p_counter_id, l_error_msg, l_return_status);
3194: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3195: csm_util_pkg.LOG(l_error_msg, 'CSM_WF_PKG.CS_Counter_Pre_Del', FND_LOG.LEVEL_ERROR);
3196: END IF;
3197:
3198: EXCEPTION

Line 3200: x_return_status := FND_API.G_RET_STS_ERROR;

3196: END IF;
3197:
3198: EXCEPTION
3199: WHEN OTHERS THEN
3200: x_return_status := FND_API.G_RET_STS_ERROR;
3201: l_sqlerrno := to_char(SQLCODE);
3202: l_sqlerrmsg := substr(SQLERRM, 1,2000);
3203: l_error_msg := 'Exception in CS_Counter_Pre_Del for counter_id:' || TO_CHAR(p_counter_id)
3204: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line 3210: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

3206: END CS_Counter_Pre_Del;
3207:
3208: PROCEDURE CS_CTR_GRP_INSTANCE_CRE_POST(
3209: P_Api_Version IN NUMBER,
3210: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3211: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3212: X_Return_Status OUT NOCOPY VARCHAR2,
3213: X_Msg_Count OUT NOCOPY NUMBER,
3214: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 3211: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

3207:
3208: PROCEDURE CS_CTR_GRP_INSTANCE_CRE_POST(
3209: P_Api_Version IN NUMBER,
3210: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3211: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3212: X_Return_Status OUT NOCOPY VARCHAR2,
3213: X_Msg_Count OUT NOCOPY NUMBER,
3214: X_Msg_Data OUT NOCOPY VARCHAR2,
3215: p_source_object_cd IN VARCHAR2,

Line 3251: x_return_status := FND_API.G_RET_STS_SUCCESS;

3247: l_error_msg VARCHAR2(4000);
3248: l_return_status VARCHAR2(2000);
3249:
3250: BEGIN
3251: x_return_status := FND_API.G_RET_STS_SUCCESS;
3252:
3253: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
3254: RETURN;
3255: END IF;

Line 3288: x_return_status := FND_API.G_RET_STS_ERROR;

3284: END LOOP;
3285:
3286: EXCEPTION
3287: WHEN OTHERS THEN
3288: x_return_status := FND_API.G_RET_STS_ERROR;
3289: l_sqlerrno := to_char(SQLCODE);
3290: l_sqlerrmsg := substr(SQLERRM, 1,2000);
3291: l_error_msg := 'Exception in CS_CTR_GRP_INSTANCE_CRE_POST for COUNTER_GROUP_ID:' || TO_CHAR(p_ctr_grp_id)
3292: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line 3298: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

3294: END CS_CTR_GRP_INSTANCE_CRE_POST;
3295:
3296: PROCEDURE CS_CTR_GRP_INSTANCE_PRE_DEL(
3297: P_Api_Version IN NUMBER,
3298: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3299: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3300: X_Return_Status OUT NOCOPY VARCHAR2,
3301: X_Msg_Count OUT NOCOPY NUMBER,
3302: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 3299: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

3295:
3296: PROCEDURE CS_CTR_GRP_INSTANCE_PRE_DEL(
3297: P_Api_Version IN NUMBER,
3298: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3299: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3300: X_Return_Status OUT NOCOPY VARCHAR2,
3301: X_Msg_Count OUT NOCOPY NUMBER,
3302: X_Msg_Data OUT NOCOPY VARCHAR2,
3303: p_source_object_cd IN VARCHAR2,

Line 3326: x_return_status := FND_API.G_RET_STS_SUCCESS;

3322: AND counters.counter_group_id = counter_groups.counter_group_id
3323: AND counters.TYPE = 'REGULAR';
3324:
3325: BEGIN
3326: x_return_status := FND_API.G_RET_STS_SUCCESS;
3327:
3328: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
3329: RETURN;
3330: END IF;

Line 3350: x_return_status := FND_API.G_RET_STS_ERROR;

3346: END LOOP;
3347:
3348: EXCEPTION
3349: WHEN OTHERS THEN
3350: x_return_status := FND_API.G_RET_STS_ERROR;
3351: l_sqlerrno := to_char(SQLCODE);
3352: l_sqlerrmsg := substr(SQLERRM, 1,2000);
3353: l_error_msg := 'Exception in CS_CTR_GRP_INSTANCE_PRE_DEL for source_object_id:' || TO_CHAR(p_source_object_id)
3354: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line 3386: x_return_status := FND_API.G_RET_STS_SUCCESS;

3382: AND counter_groups.source_object_code = 'CP'
3383: AND acc.instance_id = counter_groups.source_object_id;
3384:
3385: BEGIN
3386: x_return_status := FND_API.G_RET_STS_SUCCESS;
3387:
3388: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
3389: RETURN;
3390: END IF;

Line 3408: x_return_status := FND_API.G_RET_STS_ERROR;

3404: END LOOP;
3405:
3406: EXCEPTION
3407: WHEN OTHERS THEN
3408: x_return_status := FND_API.G_RET_STS_ERROR;
3409: l_sqlerrno := to_char(SQLCODE);
3410: l_sqlerrmsg := substr(SQLERRM, 1,2000);
3411: l_error_msg := 'Exception in CS_COUNTER_GRP_Post_Upd for counter_grp_id:' || TO_CHAR(p_ctr_grp_id)
3412: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line 3418: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

3414: END CS_COUNTER_GRP_Post_Upd;
3415:
3416: PROCEDURE CS_COUNTERS_INSTANTIATE_POST(
3417: P_Api_Version IN NUMBER,
3418: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3419: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3420: X_Return_Status OUT NOCOPY VARCHAR2,
3421: X_Msg_Count OUT NOCOPY NUMBER,
3422: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 3419: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

3415:
3416: PROCEDURE CS_COUNTERS_INSTANTIATE_POST(
3417: P_Api_Version IN NUMBER,
3418: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3419: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3420: X_Return_Status OUT NOCOPY VARCHAR2,
3421: X_Msg_Count OUT NOCOPY NUMBER,
3422: X_Msg_Data OUT NOCOPY VARCHAR2,
3423: p_counter_group_id_template IN NUMBER,

Line 3432: x_return_status := FND_API.G_RET_STS_SUCCESS;

3428: )
3429: IS
3430: l_object_version_number NUMBER;
3431: BEGIN
3432: x_return_status := FND_API.G_RET_STS_SUCCESS;
3433:
3434: CS_CTR_GRP_INSTANCE_CRE_POST(
3435: P_Api_Version,
3436: P_Init_Msg_List,

Line 3460: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

3456: If yes, do update
3457: ------------*/
3458: Procedure CS_Counter_Pre_Upd(
3459: P_Api_Version IN NUMBER,
3460: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3461: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3462: X_Return_Status OUT NOCOPY VARCHAR2,
3463: X_Msg_Count OUT NOCOPY NUMBER,
3464: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 3461: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

3457: ------------*/
3458: Procedure CS_Counter_Pre_Upd(
3459: P_Api_Version IN NUMBER,
3460: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3461: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3462: X_Return_Status OUT NOCOPY VARCHAR2,
3463: X_Msg_Count OUT NOCOPY NUMBER,
3464: X_Msg_Data OUT NOCOPY VARCHAR2,
3465: p_counter_id IN NUMBER,

Line 3467: p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,

3463: X_Msg_Count OUT NOCOPY NUMBER,
3464: X_Msg_Data OUT NOCOPY VARCHAR2,
3465: p_counter_id IN NUMBER,
3466: p_object_version_number IN NUMBER,
3467: p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3468: x_object_version_number OUT NOCOPY NUMBER
3469: -- p_user_id in number,
3470: -- p_cs_counters cs_counters%rowtype
3471: )

Line 3504: x_return_status := FND_API.G_RET_STS_SUCCESS;

3500: FROM dual;
3501:
3502: BEGIN
3503: -- csm_util_pkg.log('csm_wf_pkg.cs_counter_pre_upd eneterd');
3504: x_return_status := FND_API.G_RET_STS_SUCCESS;
3505:
3506: EXCEPTION
3507: --log the error
3508: WHEN OTHERS THEN

Line 3514: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

3510: END CS_Counter_Pre_Upd;
3511:
3512: PROCEDURE CS_Counter_Post_Upd(
3513: P_Api_Version IN NUMBER,
3514: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3515: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3516: X_Return_Status OUT NOCOPY VARCHAR2,
3517: X_Msg_Count OUT NOCOPY NUMBER,
3518: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 3515: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

3511:
3512: PROCEDURE CS_Counter_Post_Upd(
3513: P_Api_Version IN NUMBER,
3514: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3515: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3516: X_Return_Status OUT NOCOPY VARCHAR2,
3517: X_Msg_Count OUT NOCOPY NUMBER,
3518: X_Msg_Data OUT NOCOPY VARCHAR2,
3519: p_counter_id IN NUMBER,

Line 3521: p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,

3517: X_Msg_Count OUT NOCOPY NUMBER,
3518: X_Msg_Data OUT NOCOPY VARCHAR2,
3519: p_counter_id IN NUMBER,
3520: p_object_version_number IN NUMBER,
3521: p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3522: x_object_version_number OUT NOCOPY NUMBER)
3523: IS
3524: l_sqlerrno VARCHAR2(20);
3525: l_sqlerrmsg VARCHAR2(4000);

Line 3542: x_return_status := FND_API.G_RET_STS_SUCCESS;

3538:
3539: l_acc_cnt NUMBER;
3540:
3541: BEGIN
3542: x_return_status := FND_API.G_RET_STS_SUCCESS;
3543:
3544: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
3545: RETURN;
3546: END IF;

Line 3559: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3555: END IF;
3556: CLOSE l_acc_csr;
3557:
3558: csm_counter_event_pkg.CTR_MAKE_DIRTY_U_FOREACHUSER(p_counter_id, l_error_msg, l_return_status);
3559: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3560: csm_util_pkg.LOG(l_error_msg, 'CSM_WF_PKG.CS_Counter_Post_Upd', FND_LOG.LEVEL_ERROR);
3561: END IF;
3562:
3563: EXCEPTION

Line 3565: x_return_status := FND_API.G_RET_STS_ERROR;

3561: END IF;
3562:
3563: EXCEPTION
3564: WHEN OTHERS THEN
3565: x_return_status := FND_API.G_RET_STS_ERROR;
3566: l_sqlerrno := to_char(SQLCODE);
3567: l_sqlerrmsg := substr(SQLERRM, 1,2000);
3568: l_error_msg := 'Exception in CS_Counter_Post_Upd for counter_id:' || TO_CHAR(p_counter_id)
3569: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line 3598: x_return_status := FND_API.G_RET_STS_SUCCESS;

3594: l_error_msg VARCHAR2(4000);
3595: l_return_status VARCHAR2(2000);
3596:
3597: BEGIN
3598: x_return_status := FND_API.G_RET_STS_SUCCESS;
3599:
3600: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
3601: RETURN;
3602: END IF;

Line 3607: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3603:
3604: l_counter_grp_log_id := p_counter_grp_log_id;
3605:
3606: csm_counter_event_pkg.CTR_VAL_MAKE_DIRTY_FOREACHUSER(l_counter_grp_log_id, l_error_msg, l_return_status);
3607: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3608: csm_util_pkg.LOG(l_error_msg, 'CSM_WF_PKG.CS_Counter_Value_Post_Ins', FND_LOG.LEVEL_ERROR);
3609: END IF;
3610:
3611: EXCEPTION

Line 3613: x_return_status := FND_API.G_RET_STS_ERROR;

3609: END IF;
3610:
3611: EXCEPTION
3612: WHEN OTHERS THEN
3613: x_return_status := FND_API.G_RET_STS_ERROR;
3614: l_sqlerrno := to_char(SQLCODE);
3615: l_sqlerrmsg := substr(SQLERRM, 1,2000);
3616: l_error_msg := 'Exception in CS_Counter_Value_Post_Ins for counter_grp_log_id:' || TO_CHAR(l_counter_grp_log_id)
3617: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line 3644: x_return_status := FND_API.G_RET_STS_SUCCESS;

3640: l_error_msg VARCHAR2(4000);
3641: l_return_status VARCHAR2(2000);
3642:
3643: BEGIN
3644: x_return_status := FND_API.G_RET_STS_SUCCESS;
3645:
3646: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
3647: RETURN;
3648: END IF;

Line 3653: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3649:
3650: l_counter_grp_log_id := p_counter_grp_log_id;
3651:
3652: csm_counter_event_pkg.CTR_VAL_MAKE_DIRTY_FOREACHUSER(l_counter_grp_log_id, l_error_msg, l_return_status);
3653: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3654: csm_util_pkg.LOG(l_error_msg, 'CSM_WF_PKG.CS_Counter_Value_Pre_Upd', FND_LOG.LEVEL_ERROR);
3655: END IF;
3656:
3657: EXCEPTION

Line 3659: x_return_status := FND_API.G_RET_STS_ERROR;

3655: END IF;
3656:
3657: EXCEPTION
3658: WHEN OTHERS THEN
3659: x_return_status := FND_API.G_RET_STS_ERROR;
3660: l_sqlerrno := to_char(SQLCODE);
3661: l_sqlerrmsg := substr(SQLERRM, 1,2000);
3662: l_error_msg := 'Exception in CS_Counter_Value_Pre_Upd for counter_grp_log_id:' || TO_CHAR(l_counter_grp_log_id)
3663: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;