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 263: x_return_status := FND_API.G_RET_STS_SUCCESS;

259: );
260:
261:
262: BEGIN
263: x_return_status := FND_API.G_RET_STS_SUCCESS;
264:
265: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
266: RETURN;
267: END IF;

Line 283: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 305: x_return_status := FND_API.G_RET_STS_SUCCESS;

301:
302: l_task_id JTF_TASKS_B.TASK_ID%TYPE;
303:
304: BEGIN
305: x_return_status := FND_API.G_RET_STS_SUCCESS;
306:
307: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
308: RETURN;
309: END IF;

Line 317: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 392: x_return_status := FND_API.G_RET_STS_SUCCESS;

388:
389: l_assignee_user_id NUMBER;
390:
391: BEGIN
392: x_return_status := FND_API.G_RET_STS_SUCCESS;
393:
394: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
395: RETURN;
396: END IF;

Line 433: x_return_status := FND_API.G_RET_STS_ERROR;

429: x_return_status=>l_return_status);
430:
431: EXCEPTION
432: WHEN OTHERS THEN
433: x_return_status := FND_API.G_RET_STS_ERROR;
434: l_sqlerrno := to_char(SQLCODE);
435: l_sqlerrmsg := substr(SQLERRM, 1,2000);
436: l_error_msg := l_error_msg || '-Exception for Task_Assignment_Post_Ins :' || TO_CHAR(l_task_assignment_id)
437: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line 473: x_return_status := FND_API.G_RET_STS_SUCCESS;

469: FROM jtf_rs_resource_extns jtrs
470: WHERE jtrs.resource_id = p_resource_id;
471:
472: BEGIN
473: x_return_status := FND_API.G_RET_STS_SUCCESS;
474:
475: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
476: RETURN;
477: END IF;

Line 513: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 614: x_return_status := FND_API.G_RET_STS_SUCCESS;

610:
611: l_assignee_user_id NUMBER;
612:
613: BEGIN
614: x_return_status := FND_API.G_RET_STS_SUCCESS;
615:
616: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
617: RETURN;
618: END IF;

Line 800: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 829: x_return_status := FND_API.G_RET_STS_SUCCESS;

825: l_error_msg VARCHAR2(4000);
826: l_return_status VARCHAR2(2000);
827:
828: BEGIN
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 842: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 888: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 915: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1001: x_return_status := FND_API.G_RET_STS_SUCCESS;

997: l_task_downloadable_to_owner BOOLEAN;
998: l_owner_id NUMBER;
999: l_owner_resource_id NUMBER;
1000: BEGIN
1001: x_return_status := FND_API.G_RET_STS_SUCCESS;
1002:
1003: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
1004: RETURN;
1005: END IF;

Line 1166: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1175: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1238: x_return_status := FND_API.G_RET_STS_SUCCESS;

1234: FROM cs_incidents_all_b
1235: WHERE incident_id = p_incident_id;
1236:
1237: BEGIN
1238: x_return_status := FND_API.G_RET_STS_SUCCESS;
1239:
1240: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
1241: RETURN;
1242: END IF;

Line 1260: x_return_status := FND_API.G_RET_STS_ERROR ;

1256: csm_sr_event_pkg.sr_ins_init(l_incident_id);
1257:
1258: EXCEPTION
1259: WHEN OTHERS THEN
1260: x_return_status := FND_API.G_RET_STS_ERROR ;
1261: l_sqlerrno := to_char(SQLCODE);
1262: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1263: l_error_msg := l_error_msg || '- Exception in SR_Post_Ins for incident_id:'
1264: || TO_CHAR(l_incident_id) || l_sqlerrno || ':' || l_sqlerrmsg;

Line 1332: x_return_status := FND_API.G_RET_STS_SUCCESS;

1328:
1329: l_sr_cont_pts_pre_upd_rec l_sr_cont_pts_pre_upd_csr%ROWTYPE;
1330:
1331: BEGIN
1332: x_return_status := FND_API.G_RET_STS_SUCCESS;
1333:
1334: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
1335: RETURN;
1336: END IF;

Line 1391: x_return_status := FND_API.G_RET_STS_ERROR;

1387: CLOSE l_sr_cont_pts_pre_upd_csr;
1388:
1389: EXCEPTION
1390: WHEN OTHERS THEN
1391: x_return_status := FND_API.G_RET_STS_ERROR;
1392: l_sqlerrno := to_char(SQLCODE);
1393: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1394: l_error_msg := 'Exception in sr_pre_upd for incident_id:' || TO_CHAR(l_incident_id)
1395: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line 1519: x_return_status := FND_API.G_RET_STS_SUCCESS;

1515:
1516:
1517:
1518: BEGIN
1519: x_return_status := FND_API.G_RET_STS_SUCCESS;
1520:
1521: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
1522: RETURN;
1523: END IF;

Line 1709: x_return_status := FND_API.G_RET_STS_ERROR;

1705: END LOOP;
1706:
1707: EXCEPTION
1708: WHEN OTHERS THEN
1709: x_return_status := FND_API.G_RET_STS_ERROR;
1710: l_sqlerrno := to_char(SQLCODE);
1711: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1712: l_error_msg := 'Exception in sr_post_upd for incident_id:' || TO_CHAR(l_incident_id)
1713: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line 1738: x_return_status := FND_API.G_RET_STS_SUCCESS;

1734: l_sqlerrno VARCHAR2(20);
1735: l_sqlerrmsg VARCHAR2(2000);
1736:
1737: BEGIN
1738: x_return_status := FND_API.G_RET_STS_SUCCESS;
1739:
1740: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
1741: RETURN;
1742: END IF;

Line 1748: x_return_status := FND_API.G_RET_STS_ERROR;

1744: csm_resource_extns_event_pkg.rs_group_members_ins_init(p_resource_id=>p_resource_id,
1745: p_group_id=>p_group_id);
1746: EXCEPTION
1747: WHEN OTHERS THEN
1748: x_return_status := FND_API.G_RET_STS_ERROR;
1749: l_sqlerrno := to_char(SQLCODE);
1750: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1751: CSM_UTIL_PKG.LOG('Exception in JTF_RS_Group_Member_Post_Ins for resource_id: ' || TO_CHAR(p_resource_id)
1752: || ' and group_id: ' || TO_CHAR(p_group_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg,

Line 1789: x_return_status := FND_API.G_RET_STS_SUCCESS;

1785: l_sqlerrno VARCHAR2(20);
1786: l_sqlerrmsg VARCHAR2(2000);
1787:
1788: BEGIN
1789: x_return_status := FND_API.G_RET_STS_SUCCESS;
1790:
1791: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
1792: RETURN;
1793: END IF;

Line 1799: x_return_status := FND_API.G_RET_STS_ERROR;

1795: csm_resource_extns_event_pkg.rs_group_members_del_init(p_resource_id=>p_resource_id,
1796: p_group_id=>p_group_id);
1797: EXCEPTION
1798: WHEN OTHERS THEN
1799: x_return_status := FND_API.G_RET_STS_ERROR;
1800: l_sqlerrno := to_char(SQLCODE);
1801: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1802: CSM_UTIL_PKG.LOG('Exception in JTF_RS_Group_Member_Pre_Del for resource_id: ' || TO_CHAR(p_resource_id)
1803: || ' and group_id: ' || TO_CHAR(p_group_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg,

Line 1824: x_return_status := FND_API.G_RET_STS_SUCCESS;

1820: l_error_msg VARCHAR2(4000);
1821: l_return_status VARCHAR2(2000);
1822:
1823: BEGIN
1824: x_return_status := FND_API.G_RET_STS_SUCCESS;
1825:
1826: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
1827: RETURN;
1828: END IF;

Line 1837: x_return_status := FND_API.G_RET_STS_ERROR;

1833: p_h_user_id=>NULL,
1834: p_flow_type=>NULL);
1835: EXCEPTION
1836: WHEN OTHERS THEN
1837: x_return_status := FND_API.G_RET_STS_ERROR;
1838: l_sqlerrno := to_char(SQLCODE);
1839: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1840: l_error_msg := 'Exception in CSF_Debrief_Header_Post_Ins for debrief_header_id:' || TO_CHAR(l_debrief_header_id)
1841: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line 1848: x_return_status := FND_API.G_RET_STS_SUCCESS;

1844:
1845: PROCEDURE CSF_Debrief_Header_Pre_Upd(x_return_status OUT NOCOPY VARCHAR2)
1846: IS
1847: BEGIN
1848: x_return_status := FND_API.G_RET_STS_SUCCESS;
1849: END CSF_Debrief_Header_Pre_Upd;
1850:
1851: PROCEDURE CSF_Debrief_Header_Post_Upd(x_return_status OUT NOCOPY VARCHAR2)
1852: IS

Line 1867: x_return_status := FND_API.G_RET_STS_SUCCESS;

1863: FROM csm_debrief_headers_acc acc
1864: WHERE acc.debrief_header_id = p_debrief_header_id;
1865:
1866: BEGIN
1867: x_return_status := FND_API.G_RET_STS_SUCCESS;
1868:
1869: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
1870: RETURN;
1871: END IF;

Line 1884: x_return_status := FND_API.G_RET_STS_ERROR;

1880: END LOOP;
1881:
1882: EXCEPTION
1883: WHEN OTHERS THEN
1884: x_return_status := FND_API.G_RET_STS_ERROR;
1885: l_sqlerrno := to_char(SQLCODE);
1886: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1887: l_error_msg := 'Exception in CSF_Debrief_Header_Post_Upd for debrief_header_id:' || TO_CHAR(l_debrief_header_id)
1888: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line 1925: x_return_status := FND_API.G_RET_STS_SUCCESS;

1921:
1922: l_csm_debrfHdDel_rec l_csm_debrfHdDel_csr%ROWTYPE;
1923:
1924: BEGIN
1925: x_return_status := FND_API.G_RET_STS_SUCCESS;
1926:
1927: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
1928: RETURN;
1929: END IF;

Line 1946: x_return_status := FND_API.G_RET_STS_ERROR;

1942: p_user_id=>l_csm_debrfHdDel_rec.user_id,
1943: p_flow_type=>NULL);
1944: EXCEPTION
1945: WHEN OTHERS THEN
1946: x_return_status := FND_API.G_RET_STS_ERROR;
1947: l_sqlerrno := to_char(SQLCODE);
1948: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1949: l_error_msg := 'Exception in CSF_Debrief_Header_Post_Del for debrief_header_id:' || TO_CHAR(l_debrief_header_id)
1950: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line 1970: x_return_status := FND_API.G_RET_STS_SUCCESS;

1966: l_error_msg VARCHAR2(4000);
1967: l_return_status VARCHAR2(2000);
1968:
1969: BEGIN
1970: x_return_status := FND_API.G_RET_STS_SUCCESS;
1971:
1972: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
1973: RETURN;
1974: END IF;

Line 1984: x_return_status := FND_API.G_RET_STS_ERROR;

1980: p_flow_type=>NULL);
1981:
1982: EXCEPTION
1983: WHEN OTHERS THEN
1984: x_return_status := FND_API.G_RET_STS_ERROR;
1985: l_sqlerrno := to_char(SQLCODE);
1986: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1987: l_error_msg := 'Exception in CSF_Debrief_Line_Post_Ins for debrief_Line_id:' || TO_CHAR(l_debrief_line_id)
1988: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line 2014: x_return_status := FND_API.G_RET_STS_SUCCESS;

2010: FROM csf_debrief_lines
2011: WHERE debrief_line_id = p_debrief_line_id;
2012:
2013: BEGIN
2014: x_return_status := FND_API.G_RET_STS_SUCCESS;
2015:
2016: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2017: RETURN;
2018: END IF;

Line 2032: x_return_status := FND_API.G_RET_STS_ERROR;

2028: CLOSE l_debrief_line_pre_upd;
2029:
2030: EXCEPTION
2031: WHEN OTHERS THEN
2032: x_return_status := FND_API.G_RET_STS_ERROR;
2033: l_sqlerrno := to_char(SQLCODE);
2034: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2035: l_error_msg := 'Exception in CSF_Debrief_Line_Pre_Upd for debrief_Line_id:' || TO_CHAR(l_debrief_line_id)
2036: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line 2062: x_return_status := FND_API.G_RET_STS_SUCCESS;

2058:
2059: r_debrief_line_post_upd_rec l_debrief_line_post_upd%ROWTYPE;
2060:
2061: BEGIN
2062: x_return_status := FND_API.G_RET_STS_SUCCESS;
2063:
2064: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2065: RETURN;
2066: END IF;

Line 2100: x_return_status := FND_API.G_RET_STS_ERROR;

2096:
2097:
2098: EXCEPTION
2099: WHEN OTHERS THEN
2100: x_return_status := FND_API.G_RET_STS_ERROR;
2101: l_sqlerrno := to_char(SQLCODE);
2102: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2103: l_error_msg := 'Exception in CSF_Debrief_Line_Post_Upd for debrief_Line_id:' || TO_CHAR(l_debrief_line_id)
2104: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line 2131: x_return_status := FND_API.G_RET_STS_SUCCESS;

2127:
2128: l_csm_debrfLnDel_rec l_csm_debrfLnDel_csr%ROWTYPE;
2129:
2130: BEGIN
2131: x_return_status := FND_API.G_RET_STS_SUCCESS;
2132:
2133: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2134: RETURN;
2135: END IF;

Line 2152: x_return_status := FND_API.G_RET_STS_ERROR;

2148: p_user_id=>l_csm_debrfLnDel_rec.user_id,
2149: p_flow_type=>NULL);
2150: EXCEPTION
2151: WHEN OTHERS THEN
2152: x_return_status := FND_API.G_RET_STS_ERROR;
2153: l_sqlerrno := to_char(SQLCODE);
2154: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2155: l_error_msg := 'Exception in CSF_Debrief_Line_Post_Del for debrief_Line_id:' || TO_CHAR(l_debrief_line_id)
2156: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line 2167: x_return_status := FND_API.G_RET_STS_SUCCESS;

2163: l_sqlerrno VARCHAR2(20);
2164: l_sqlerrmsg VARCHAR2(2000);
2165:
2166: BEGIN
2167: x_return_status := FND_API.G_RET_STS_SUCCESS;
2168:
2169: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2170: RETURN;
2171: END IF;

Line 2185: x_return_status := FND_API.G_RET_STS_ERROR;

2181: 'CSM_WF_PKG.CSP_Inv_Loc_Assignmnt_Post_Ins', FND_LOG.LEVEL_PROCEDURE );
2182:
2183: EXCEPTION
2184: WHEN OTHERS THEN
2185: x_return_status := FND_API.G_RET_STS_ERROR;
2186: l_sqlerrno := to_char(SQLCODE);
2187: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2188: 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)
2189: || ':' || l_sqlerrno || ':' || l_sqlerrmsg,

Line 2217: x_return_status := FND_API.G_RET_STS_SUCCESS;

2213: WHERE cila.csp_inv_loc_assignment_id = p_csp_inv_loc_assignment_id
2214: AND au.resource_id = cila.resource_id;
2215:
2216: BEGIN
2217: x_return_status := FND_API.G_RET_STS_SUCCESS;
2218:
2219: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2220: RETURN;
2221: END IF;

Line 2254: x_return_status := FND_API.G_RET_STS_ERROR;

2250: 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),
2251: 'CSM_WF_PKG.CSP_Inv_Loc_Assignmnt_Pre_Upd', FND_LOG.LEVEL_PROCEDURE );
2252: EXCEPTION
2253: WHEN OTHERS THEN
2254: x_return_status := FND_API.G_RET_STS_ERROR;
2255: l_sqlerrno := to_char(SQLCODE);
2256: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2257: 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)
2258: || ':' || l_sqlerrno || ':' || l_sqlerrmsg,

Line 2290: x_return_status := FND_API.G_RET_STS_SUCCESS;

2286: WHERE cila.csp_inv_loc_assignment_id = p_csp_inv_loc_assignment_id
2287: AND au.resource_id = cila.resource_id;
2288:
2289: BEGIN
2290: x_return_status := FND_API.G_RET_STS_SUCCESS;
2291:
2292: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2293: RETURN;
2294: END IF;

Line 2327: x_return_status := FND_API.G_RET_STS_ERROR;

2323: END IF;
2324:
2325: EXCEPTION
2326: WHEN OTHERS THEN
2327: x_return_status := FND_API.G_RET_STS_ERROR;
2328: l_sqlerrno := to_char(SQLCODE);
2329: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2330: 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)
2331: || ':' || l_sqlerrno || ':' || l_sqlerrmsg,

Line 2342: x_return_status := FND_API.G_RET_STS_SUCCESS;

2338: l_sqlerrno VARCHAR2(20);
2339: l_sqlerrmsg VARCHAR2(2000);
2340:
2341: BEGIN
2342: x_return_status := FND_API.G_RET_STS_SUCCESS;
2343:
2344: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2345: RETURN;
2346: END IF;

Line 2360: x_return_status := FND_API.G_RET_STS_ERROR;

2356: 'CSM_WF_PKG.CSP_Inv_Loc_Assg_Post_Del', FND_LOG.LEVEL_PROCEDURE );
2357:
2358: EXCEPTION
2359: WHEN OTHERS THEN
2360: x_return_status := FND_API.G_RET_STS_ERROR;
2361: l_sqlerrno := to_char(SQLCODE);
2362: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2363: 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)
2364: || ':' || l_sqlerrno || ':' || l_sqlerrmsg,

Line 2407: x_return_status := FND_API.G_RET_STS_SUCCESS;

2403: AND acc.location_id = pla.location_id
2404: AND acc.site_use_id = csu.site_use_id);
2405:
2406: BEGIN
2407: x_return_status := FND_API.G_RET_STS_SUCCESS;
2408:
2409: l_location_id := csp_ship_to_address_pvt.g_inv_loc_id;
2410:
2411: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN

Line 2439: x_return_status := FND_API.G_RET_STS_ERROR;

2435: FND_LOG.LEVEL_PROCEDURE );
2436:
2437: EXCEPTION
2438: WHEN OTHERS THEN
2439: x_return_status := FND_API.G_RET_STS_ERROR;
2440: l_sqlerrno := to_char(SQLCODE);
2441: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2442: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_SHIP_TO_ADDRESS_POST_INS:' || l_sqlerrno || ':' || l_sqlerrmsg,
2443: 'CSM_WF_PKG.CSP_SHIP_TO_ADDRESS_POST_INS', FND_LOG.LEVEL_EXCEPTION);

Line 2478: x_return_status := FND_API.G_RET_STS_SUCCESS;

2474: AND cas.status = 'A' -- only active sites
2475: AND hps.location_id = hzl.location_id;
2476:
2477: BEGIN
2478: x_return_status := FND_API.G_RET_STS_SUCCESS;
2479:
2480: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2481: RETURN;
2482: END IF;

Line 2514: x_return_status := FND_API.G_RET_STS_ERROR;

2510: FND_LOG.LEVEL_PROCEDURE );
2511:
2512: EXCEPTION
2513: WHEN OTHERS THEN
2514: x_return_status := FND_API.G_RET_STS_ERROR;
2515: l_sqlerrno := to_char(SQLCODE);
2516: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2517: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_SHIP_TO_ADDRESS_POST_UPD:' || l_sqlerrno || ':' || l_sqlerrmsg,
2518: 'CSM_WF_PKG.CSP_SHIP_TO_ADDRESS_POST_UPD', FND_LOG.LEVEL_EXCEPTION);

Line 2548: x_return_status := FND_API.G_RET_STS_SUCCESS;

2544: AND jtrs.resource_id = ta.resource_id
2545: ;
2546:
2547: BEGIN
2548: x_return_status := FND_API.G_RET_STS_SUCCESS;
2549:
2550: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2551: RETURN;
2552: END IF;

Line 2574: x_return_status := FND_API.G_RET_STS_ERROR;

2570: FND_LOG.LEVEL_PROCEDURE );
2571:
2572: EXCEPTION
2573: WHEN OTHERS THEN
2574: x_return_status := FND_API.G_RET_STS_ERROR;
2575: l_sqlerrno := to_char(SQLCODE);
2576: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2577: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_HEADERS_POST_INS:' || l_sqlerrno || ':' || l_sqlerrmsg,
2578: 'CSM_WF_PKG.CSP_REQ_HEADERS_POST_INS', FND_LOG.LEVEL_EXCEPTION);

Line 2595: x_return_status := FND_API.G_RET_STS_SUCCESS;

2591: FROM csm_req_headers_acc acc
2592: WHERE acc.requirement_header_id = p_req_header_id;
2593:
2594: BEGIN
2595: x_return_status := FND_API.G_RET_STS_SUCCESS;
2596:
2597: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2598: RETURN;
2599: END IF;

Line 2616: x_return_status := FND_API.G_RET_STS_ERROR;

2612: FND_LOG.LEVEL_PROCEDURE );
2613:
2614: EXCEPTION
2615: WHEN OTHERS THEN
2616: x_return_status := FND_API.G_RET_STS_ERROR;
2617: l_sqlerrno := to_char(SQLCODE);
2618: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2619: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_HEADERS_POST_UPD:' || l_sqlerrno || ':' || l_sqlerrmsg,
2620: 'CSM_WF_PKG.CSP_REQ_HEADERS_POST_UPD', FND_LOG.LEVEL_EXCEPTION);

Line 2636: x_return_status := FND_API.G_RET_STS_SUCCESS;

2632: FROM csm_req_headers_acc acc
2633: WHERE acc.requirement_header_id = p_req_header_id;
2634:
2635: BEGIN
2636: x_return_status := FND_API.G_RET_STS_SUCCESS;
2637:
2638: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2639: RETURN;
2640: END IF;

Line 2657: x_return_status := FND_API.G_RET_STS_ERROR;

2653: FND_LOG.LEVEL_PROCEDURE );
2654:
2655: EXCEPTION
2656: WHEN OTHERS THEN
2657: x_return_status := FND_API.G_RET_STS_ERROR;
2658: l_sqlerrno := to_char(SQLCODE);
2659: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2660: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_HEADERS_POST_DEL:' || l_sqlerrno || ':' || l_sqlerrmsg,
2661: 'CSM_WF_PKG.CSP_REQ_HEADERS_POST_DEL', FND_LOG.LEVEL_EXCEPTION);

Line 2697: x_return_status := FND_API.G_RET_STS_SUCCESS;

2693: AND jtrs.resource_id = ta.resource_id
2694: ;
2695:
2696: BEGIN
2697: x_return_status := FND_API.G_RET_STS_SUCCESS;
2698:
2699: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2700: RETURN;
2701: END IF;

Line 2723: x_return_status := FND_API.G_RET_STS_ERROR;

2719: FND_LOG.LEVEL_PROCEDURE );
2720:
2721: EXCEPTION
2722: WHEN OTHERS THEN
2723: x_return_status := FND_API.G_RET_STS_ERROR;
2724: l_sqlerrno := to_char(SQLCODE);
2725: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2726: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_LINES_POST_INS:' || l_sqlerrno || ':' || l_sqlerrmsg,
2727: 'CSM_WF_PKG.CSP_REQ_LINES_POST_INS', FND_LOG.LEVEL_EXCEPTION);

Line 2743: x_return_status := FND_API.G_RET_STS_SUCCESS;

2739: FROM csm_req_lines_acc acc
2740: WHERE acc.requirement_line_id = p_req_line_id;
2741:
2742: BEGIN
2743: x_return_status := FND_API.G_RET_STS_SUCCESS;
2744:
2745: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2746: RETURN;
2747: END IF;

Line 2764: x_return_status := FND_API.G_RET_STS_ERROR;

2760: FND_LOG.LEVEL_PROCEDURE );
2761:
2762: EXCEPTION
2763: WHEN OTHERS THEN
2764: x_return_status := FND_API.G_RET_STS_ERROR;
2765: l_sqlerrno := to_char(SQLCODE);
2766: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2767: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_LINES_POST_UPD:' || l_sqlerrno || ':' || l_sqlerrmsg,
2768: 'CSM_WF_PKG.CSP_REQ_LINES_POST_UPD', FND_LOG.LEVEL_EXCEPTION);

Line 2784: x_return_status := FND_API.G_RET_STS_SUCCESS;

2780: FROM csm_req_lines_acc acc
2781: WHERE acc.requirement_line_id = p_req_line_id;
2782:
2783: BEGIN
2784: x_return_status := FND_API.G_RET_STS_SUCCESS;
2785:
2786: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2787: RETURN;
2788: END IF;

Line 2805: x_return_status := FND_API.G_RET_STS_ERROR;

2801: CSM_UTIL_PKG.LOG('Leaving CSM_WF_PKG.CSP_REQ_LINES_POST_DEL', 'CSM_WF_PKG.CSP_REQ_LINES_POST_DEL',
2802: FND_LOG.LEVEL_PROCEDURE );
2803: EXCEPTION
2804: WHEN OTHERS THEN
2805: x_return_status := FND_API.G_RET_STS_ERROR;
2806: l_sqlerrno := to_char(SQLCODE);
2807: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2808: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_LINES_POST_DEL:' || l_sqlerrno || ':' || l_sqlerrmsg,
2809: 'CSM_WF_PKG.CSP_REQ_LINES_POST_DEL', FND_LOG.LEVEL_EXCEPTION);

Line 2832: x_return_status := FND_API.G_RET_STS_SUCCESS;

2828: FROM csp_req_line_details
2829: WHERE req_line_detail_id = p_req_line_detail_id;
2830:
2831: BEGIN
2832: x_return_status := FND_API.G_RET_STS_SUCCESS;
2833:
2834: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2835: RETURN;
2836: END IF;

Line 2856: x_return_status := FND_API.G_RET_STS_ERROR;

2852: FND_LOG.LEVEL_PROCEDURE );
2853:
2854: EXCEPTION
2855: WHEN OTHERS THEN
2856: x_return_status := FND_API.G_RET_STS_ERROR;
2857: l_sqlerrno := to_char(SQLCODE);
2858: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2859: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_INS:' || l_sqlerrno || ':' || l_sqlerrmsg,
2860: 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_INS', FND_LOG.LEVEL_EXCEPTION);

Line 2861: x_return_status := FND_API.G_RET_STS_ERROR;

2857: l_sqlerrno := to_char(SQLCODE);
2858: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2859: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_INS:' || l_sqlerrno || ':' || l_sqlerrmsg,
2860: 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_INS', FND_LOG.LEVEL_EXCEPTION);
2861: x_return_status := FND_API.G_RET_STS_ERROR;
2862: END CSP_REQ_LINE_DETAILS_POST_INS;
2863:
2864: PROCEDURE CSP_REQ_LINE_DETAILS_POST_UPD(x_return_status OUT NOCOPY varchar2)
2865: IS

Line 2884: x_return_status := FND_API.G_RET_STS_SUCCESS;

2880: FROM csp_req_line_details
2881: WHERE req_line_detail_id = p_req_line_detail_id;
2882:
2883: BEGIN
2884: x_return_status := FND_API.G_RET_STS_SUCCESS;
2885:
2886: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2887: RETURN;
2888: END IF;

Line 2909: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2914: x_return_status := FND_API.G_RET_STS_ERROR;

2910: l_sqlerrno := to_char(SQLCODE);
2911: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2912: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_UPD:' || l_sqlerrno || ':' || l_sqlerrmsg,
2913: 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_UPD', FND_LOG.LEVEL_EXCEPTION);
2914: x_return_status := FND_API.G_RET_STS_ERROR;
2915: END CSP_REQ_LINE_DETAILS_POST_UPD;
2916:
2917: PROCEDURE CSP_REQ_LINE_DETAILS_PRE_DEL(x_return_status OUT NOCOPY varchar2)
2918: IS

Line 2937: x_return_status := FND_API.G_RET_STS_SUCCESS;

2933: FROM csp_req_line_details
2934: WHERE req_line_detail_id = p_req_line_detail_id;
2935:
2936: BEGIN
2937: x_return_status := FND_API.G_RET_STS_SUCCESS;
2938:
2939: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2940: RETURN;
2941: END IF;

Line 2962: x_return_status := FND_API.G_RET_STS_ERROR;

2958: FND_LOG.LEVEL_PROCEDURE );
2959:
2960: EXCEPTION
2961: WHEN OTHERS THEN
2962: x_return_status := FND_API.G_RET_STS_ERROR;
2963: l_sqlerrno := to_char(SQLCODE);
2964: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2965: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_LINE_DETAILS_PRE_DEL:' || l_sqlerrno || ':' || l_sqlerrmsg,
2966: 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_PRE_DEL', FND_LOG.LEVEL_EXCEPTION);

Line 2999: x_return_status := FND_API.G_RET_STS_SUCCESS;

2995: l_error_msg VARCHAR2(4000);
2996: l_return_status VARCHAR2(2000);
2997:
2998: BEGIN
2999: x_return_status := FND_API.G_RET_STS_SUCCESS;
3000:
3001: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
3002: RETURN;
3003: END IF;

Line 3006: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3002: RETURN;
3003: END IF;
3004:
3005: csm_notes_event_pkg.notes_make_dirty_i_foreachuser(p_jtf_note_id,l_error_msg,l_return_status);
3006: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3007: csm_util_pkg.LOG(l_error_msg, 'CSM_WF_PKG.JTF_Note_Post_Ins', FND_LOG.LEVEL_ERROR);
3008: END IF;
3009:
3010: EXCEPTION

Line 3012: x_return_status := FND_API.G_RET_STS_ERROR ;

3008: END IF;
3009:
3010: EXCEPTION
3011: WHEN OTHERS THEN
3012: x_return_status := FND_API.G_RET_STS_ERROR ;
3013: l_sqlerrno := to_char(SQLCODE);
3014: l_sqlerrmsg := substr(SQLERRM, 1,2000);
3015: l_error_msg := l_error_msg || '- Exception in JTF_Note_Post_Ins for note_id:'
3016: || TO_CHAR(p_jtf_note_id) || l_sqlerrno || ':' || l_sqlerrmsg;

Line 3050: x_return_status := FND_API.G_RET_STS_SUCCESS;

3046: l_error_msg VARCHAR2(4000);
3047: l_return_status VARCHAR2(4000);
3048:
3049: BEGIN
3050: x_return_status := FND_API.G_RET_STS_SUCCESS;
3051:
3052: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
3053: RETURN;
3054: END IF;

Line 3057: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3053: RETURN;
3054: END IF;
3055:
3056: csm_notes_event_pkg.notes_make_dirty_i_foreachuser(p_jtf_note_id, l_error_msg, l_return_status);
3057: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3058: csm_util_pkg.LOG(l_error_msg, 'CSM_WF_PKG.JTF_Note_Pre_Upd', FND_LOG.LEVEL_ERROR);
3059: END IF;
3060:
3061: EXCEPTION

Line 3063: x_return_status := FND_API.G_RET_STS_ERROR ;

3059: END IF;
3060:
3061: EXCEPTION
3062: WHEN OTHERS THEN
3063: x_return_status := FND_API.G_RET_STS_ERROR ;
3064: l_sqlerrno := to_char(SQLCODE);
3065: l_sqlerrmsg := substr(SQLERRM, 1,2000);
3066: l_error_msg := l_error_msg || '- Exception in JTF_Note_PRE_Upd for note_id:'
3067: || TO_CHAR(p_jtf_note_id) || l_sqlerrno || ':' || l_sqlerrmsg;

Line 3140: x_return_status := FND_API.G_RET_STS_SUCCESS;

3136: l_return_status VARCHAR2(2000);
3137: l_instance_id csi_item_instances.instance_id%TYPE;
3138:
3139: BEGIN
3140: x_return_status := FND_API.G_RET_STS_SUCCESS;
3141:
3142: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
3143: RETURN;
3144: END IF;

Line 3147: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3143: RETURN;
3144: END IF;
3145:
3146: CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCE_MDIRTY_U_ECHUSER(p_instance_id, l_error_msg, l_return_status);
3147: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3148: csm_util_pkg.LOG(l_error_msg, 'CSM_WF_PKG.CSI_Item_Instance_Pre_Upd', FND_LOG.LEVEL_ERROR);
3149: END IF;
3150:
3151: EXCEPTION

Line 3153: x_return_status := FND_API.G_RET_STS_ERROR;

3149: END IF;
3150:
3151: EXCEPTION
3152: WHEN OTHERS THEN
3153: x_return_status := FND_API.G_RET_STS_ERROR;
3154: l_sqlerrno := to_char(SQLCODE);
3155: l_sqlerrmsg := substr(SQLERRM, 1,2000);
3156: l_error_msg := 'Exception in CSI_Item_Instance_Pre_Upd for instance_id:' || TO_CHAR(p_instance_id)
3157: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

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

3159: END CSI_Item_Instance_Pre_Upd;
3160:
3161: Procedure CS_Counter_Post_Ins(
3162: P_Api_Version IN NUMBER,
3163: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3164: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3165: X_Return_Status OUT NOCOPY VARCHAR2,
3166: X_Msg_Count OUT NOCOPY NUMBER,
3167: X_Msg_Data OUT NOCOPY VARCHAR2,

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

3160:
3161: Procedure CS_Counter_Post_Ins(
3162: P_Api_Version IN NUMBER,
3163: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3164: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3165: X_Return_Status OUT NOCOPY VARCHAR2,
3166: X_Msg_Count OUT NOCOPY NUMBER,
3167: X_Msg_Data OUT NOCOPY VARCHAR2,
3168: p_counter_id IN NUMBER,

Line 3180: x_return_status := FND_API.G_RET_STS_SUCCESS;

3176: l_error_msg VARCHAR2(4000);
3177: l_return_status VARCHAR2(2000);
3178:
3179: BEGIN
3180: x_return_status := FND_API.G_RET_STS_SUCCESS;
3181:
3182: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
3183: RETURN;
3184: END IF;

Line 3187: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3183: RETURN;
3184: END IF;
3185:
3186: csm_counter_event_pkg.CTR_MAKE_DIRTY_I_FOREACHUSER(p_counter_id, l_error_msg, l_return_status);
3187: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3188: csm_util_pkg.LOG(l_error_msg, 'CSM_WF_PKG.CS_Counter_Post_Ins', FND_LOG.LEVEL_ERROR);
3189: END IF;
3190:
3191: EXCEPTION

Line 3193: x_return_status := FND_API.G_RET_STS_ERROR;

3189: END IF;
3190:
3191: EXCEPTION
3192: WHEN OTHERS THEN
3193: x_return_status := FND_API.G_RET_STS_ERROR;
3194: l_sqlerrno := to_char(SQLCODE);
3195: l_sqlerrmsg := substr(SQLERRM, 1,2000);
3196: l_error_msg := 'Exception in CS_Counter_Post_Ins for counter_id:' || TO_CHAR(p_counter_id)
3197: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

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

3199: END CS_Counter_Post_Ins;
3200:
3201: Procedure CS_Counter_Pre_Del(
3202: P_Api_Version IN NUMBER,
3203: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3204: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3205: X_Return_Status OUT NOCOPY VARCHAR2,
3206: X_Msg_Count OUT NOCOPY NUMBER,
3207: X_Msg_Data OUT NOCOPY VARCHAR2,

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

3200:
3201: Procedure CS_Counter_Pre_Del(
3202: P_Api_Version IN NUMBER,
3203: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3204: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3205: X_Return_Status OUT NOCOPY VARCHAR2,
3206: X_Msg_Count OUT NOCOPY NUMBER,
3207: X_Msg_Data OUT NOCOPY VARCHAR2,
3208: p_counter_id IN NUMBER

Line 3217: x_return_status := FND_API.G_RET_STS_SUCCESS;

3213: l_error_msg VARCHAR2(4000);
3214: l_return_status VARCHAR2(2000);
3215:
3216: BEGIN
3217: x_return_status := FND_API.G_RET_STS_SUCCESS;
3218:
3219: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
3220: RETURN;
3221: END IF;

Line 3224: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3220: RETURN;
3221: END IF;
3222:
3223: csm_counter_event_pkg.COUNTER_MDIRTY_D(p_counter_id, l_error_msg, l_return_status);
3224: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3225: csm_util_pkg.LOG(l_error_msg, 'CSM_WF_PKG.CS_Counter_Pre_Del', FND_LOG.LEVEL_ERROR);
3226: END IF;
3227:
3228: EXCEPTION

Line 3230: x_return_status := FND_API.G_RET_STS_ERROR;

3226: END IF;
3227:
3228: EXCEPTION
3229: WHEN OTHERS THEN
3230: x_return_status := FND_API.G_RET_STS_ERROR;
3231: l_sqlerrno := to_char(SQLCODE);
3232: l_sqlerrmsg := substr(SQLERRM, 1,2000);
3233: l_error_msg := 'Exception in CS_Counter_Pre_Del for counter_id:' || TO_CHAR(p_counter_id)
3234: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

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

3236: END CS_Counter_Pre_Del;
3237:
3238: PROCEDURE CS_CTR_GRP_INSTANCE_CRE_POST(
3239: P_Api_Version IN NUMBER,
3240: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3241: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3242: X_Return_Status OUT NOCOPY VARCHAR2,
3243: X_Msg_Count OUT NOCOPY NUMBER,
3244: X_Msg_Data OUT NOCOPY VARCHAR2,

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

3237:
3238: PROCEDURE CS_CTR_GRP_INSTANCE_CRE_POST(
3239: P_Api_Version IN NUMBER,
3240: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3241: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3242: X_Return_Status OUT NOCOPY VARCHAR2,
3243: X_Msg_Count OUT NOCOPY NUMBER,
3244: X_Msg_Data OUT NOCOPY VARCHAR2,
3245: p_source_object_cd IN VARCHAR2,

Line 3281: x_return_status := FND_API.G_RET_STS_SUCCESS;

3277: l_error_msg VARCHAR2(4000);
3278: l_return_status VARCHAR2(2000);
3279:
3280: BEGIN
3281: x_return_status := FND_API.G_RET_STS_SUCCESS;
3282:
3283: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
3284: RETURN;
3285: END IF;

Line 3318: x_return_status := FND_API.G_RET_STS_ERROR;

3314: END LOOP;
3315:
3316: EXCEPTION
3317: WHEN OTHERS THEN
3318: x_return_status := FND_API.G_RET_STS_ERROR;
3319: l_sqlerrno := to_char(SQLCODE);
3320: l_sqlerrmsg := substr(SQLERRM, 1,2000);
3321: l_error_msg := 'Exception in CS_CTR_GRP_INSTANCE_CRE_POST for COUNTER_GROUP_ID:' || TO_CHAR(p_ctr_grp_id)
3322: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

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

3324: END CS_CTR_GRP_INSTANCE_CRE_POST;
3325:
3326: PROCEDURE CS_CTR_GRP_INSTANCE_PRE_DEL(
3327: P_Api_Version IN NUMBER,
3328: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3329: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3330: X_Return_Status OUT NOCOPY VARCHAR2,
3331: X_Msg_Count OUT NOCOPY NUMBER,
3332: X_Msg_Data OUT NOCOPY VARCHAR2,

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

3325:
3326: PROCEDURE CS_CTR_GRP_INSTANCE_PRE_DEL(
3327: P_Api_Version IN NUMBER,
3328: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3329: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3330: X_Return_Status OUT NOCOPY VARCHAR2,
3331: X_Msg_Count OUT NOCOPY NUMBER,
3332: X_Msg_Data OUT NOCOPY VARCHAR2,
3333: p_source_object_cd IN VARCHAR2,

Line 3356: x_return_status := FND_API.G_RET_STS_SUCCESS;

3352: AND counters.counter_group_id = counter_groups.counter_group_id
3353: AND counters.TYPE = 'REGULAR';
3354:
3355: BEGIN
3356: x_return_status := FND_API.G_RET_STS_SUCCESS;
3357:
3358: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
3359: RETURN;
3360: END IF;

Line 3380: x_return_status := FND_API.G_RET_STS_ERROR;

3376: END LOOP;
3377:
3378: EXCEPTION
3379: WHEN OTHERS THEN
3380: x_return_status := FND_API.G_RET_STS_ERROR;
3381: l_sqlerrno := to_char(SQLCODE);
3382: l_sqlerrmsg := substr(SQLERRM, 1,2000);
3383: l_error_msg := 'Exception in CS_CTR_GRP_INSTANCE_PRE_DEL for source_object_id:' || TO_CHAR(p_source_object_id)
3384: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line 3416: x_return_status := FND_API.G_RET_STS_SUCCESS;

3412: AND counter_groups.source_object_code = 'CP'
3413: AND acc.instance_id = counter_groups.source_object_id;
3414:
3415: BEGIN
3416: x_return_status := FND_API.G_RET_STS_SUCCESS;
3417:
3418: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
3419: RETURN;
3420: END IF;

Line 3438: x_return_status := FND_API.G_RET_STS_ERROR;

3434: END LOOP;
3435:
3436: EXCEPTION
3437: WHEN OTHERS THEN
3438: x_return_status := FND_API.G_RET_STS_ERROR;
3439: l_sqlerrno := to_char(SQLCODE);
3440: l_sqlerrmsg := substr(SQLERRM, 1,2000);
3441: l_error_msg := 'Exception in CS_COUNTER_GRP_Post_Upd for counter_grp_id:' || TO_CHAR(p_ctr_grp_id)
3442: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

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

3444: END CS_COUNTER_GRP_Post_Upd;
3445:
3446: PROCEDURE CS_COUNTERS_INSTANTIATE_POST(
3447: P_Api_Version IN NUMBER,
3448: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3449: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3450: X_Return_Status OUT NOCOPY VARCHAR2,
3451: X_Msg_Count OUT NOCOPY NUMBER,
3452: X_Msg_Data OUT NOCOPY VARCHAR2,

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

3445:
3446: PROCEDURE CS_COUNTERS_INSTANTIATE_POST(
3447: P_Api_Version IN NUMBER,
3448: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3449: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3450: X_Return_Status OUT NOCOPY VARCHAR2,
3451: X_Msg_Count OUT NOCOPY NUMBER,
3452: X_Msg_Data OUT NOCOPY VARCHAR2,
3453: p_counter_group_id_template IN NUMBER,

Line 3462: x_return_status := FND_API.G_RET_STS_SUCCESS;

3458: )
3459: IS
3460: l_object_version_number NUMBER;
3461: BEGIN
3462: x_return_status := FND_API.G_RET_STS_SUCCESS;
3463:
3464: CS_CTR_GRP_INSTANCE_CRE_POST(
3465: P_Api_Version,
3466: P_Init_Msg_List,

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

3486: If yes, do update
3487: ------------*/
3488: Procedure CS_Counter_Pre_Upd(
3489: P_Api_Version IN NUMBER,
3490: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3491: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3492: X_Return_Status OUT NOCOPY VARCHAR2,
3493: X_Msg_Count OUT NOCOPY NUMBER,
3494: X_Msg_Data OUT NOCOPY VARCHAR2,

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

3487: ------------*/
3488: Procedure CS_Counter_Pre_Upd(
3489: P_Api_Version IN NUMBER,
3490: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3491: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3492: X_Return_Status OUT NOCOPY VARCHAR2,
3493: X_Msg_Count OUT NOCOPY NUMBER,
3494: X_Msg_Data OUT NOCOPY VARCHAR2,
3495: p_counter_id IN NUMBER,

Line 3497: p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,

3493: X_Msg_Count OUT NOCOPY NUMBER,
3494: X_Msg_Data OUT NOCOPY VARCHAR2,
3495: p_counter_id IN NUMBER,
3496: p_object_version_number IN NUMBER,
3497: p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3498: x_object_version_number OUT NOCOPY NUMBER
3499: -- p_user_id in number,
3500: -- p_cs_counters cs_counters%rowtype
3501: )

Line 3534: x_return_status := FND_API.G_RET_STS_SUCCESS;

3530: FROM dual;
3531:
3532: BEGIN
3533: -- csm_util_pkg.log('csm_wf_pkg.cs_counter_pre_upd eneterd');
3534: x_return_status := FND_API.G_RET_STS_SUCCESS;
3535:
3536: EXCEPTION
3537: --log the error
3538: WHEN OTHERS THEN

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

3540: END CS_Counter_Pre_Upd;
3541:
3542: PROCEDURE CS_Counter_Post_Upd(
3543: P_Api_Version IN NUMBER,
3544: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3545: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3546: X_Return_Status OUT NOCOPY VARCHAR2,
3547: X_Msg_Count OUT NOCOPY NUMBER,
3548: X_Msg_Data OUT NOCOPY VARCHAR2,

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

3541:
3542: PROCEDURE CS_Counter_Post_Upd(
3543: P_Api_Version IN NUMBER,
3544: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3545: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3546: X_Return_Status OUT NOCOPY VARCHAR2,
3547: X_Msg_Count OUT NOCOPY NUMBER,
3548: X_Msg_Data OUT NOCOPY VARCHAR2,
3549: p_counter_id IN NUMBER,

Line 3551: p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,

3547: X_Msg_Count OUT NOCOPY NUMBER,
3548: X_Msg_Data OUT NOCOPY VARCHAR2,
3549: p_counter_id IN NUMBER,
3550: p_object_version_number IN NUMBER,
3551: p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3552: x_object_version_number OUT NOCOPY NUMBER)
3553: IS
3554: l_sqlerrno VARCHAR2(20);
3555: l_sqlerrmsg VARCHAR2(4000);

Line 3572: x_return_status := FND_API.G_RET_STS_SUCCESS;

3568:
3569: l_acc_cnt NUMBER;
3570:
3571: BEGIN
3572: x_return_status := FND_API.G_RET_STS_SUCCESS;
3573:
3574: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
3575: RETURN;
3576: END IF;

Line 3589: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3585: END IF;
3586: CLOSE l_acc_csr;
3587:
3588: csm_counter_event_pkg.CTR_MAKE_DIRTY_U_FOREACHUSER(p_counter_id, l_error_msg, l_return_status);
3589: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3590: csm_util_pkg.LOG(l_error_msg, 'CSM_WF_PKG.CS_Counter_Post_Upd', FND_LOG.LEVEL_ERROR);
3591: END IF;
3592:
3593: EXCEPTION

Line 3595: x_return_status := FND_API.G_RET_STS_ERROR;

3591: END IF;
3592:
3593: EXCEPTION
3594: WHEN OTHERS THEN
3595: x_return_status := FND_API.G_RET_STS_ERROR;
3596: l_sqlerrno := to_char(SQLCODE);
3597: l_sqlerrmsg := substr(SQLERRM, 1,2000);
3598: l_error_msg := 'Exception in CS_Counter_Post_Upd for counter_id:' || TO_CHAR(p_counter_id)
3599: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line 3628: x_return_status := FND_API.G_RET_STS_SUCCESS;

3624: l_error_msg VARCHAR2(4000);
3625: l_return_status VARCHAR2(2000);
3626:
3627: BEGIN
3628: x_return_status := FND_API.G_RET_STS_SUCCESS;
3629:
3630: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
3631: RETURN;
3632: END IF;

Line 3637: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3633:
3634: l_counter_grp_log_id := p_counter_grp_log_id;
3635:
3636: csm_counter_event_pkg.CTR_VAL_MAKE_DIRTY_FOREACHUSER(l_counter_grp_log_id, l_error_msg, l_return_status);
3637: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3638: csm_util_pkg.LOG(l_error_msg, 'CSM_WF_PKG.CS_Counter_Value_Post_Ins', FND_LOG.LEVEL_ERROR);
3639: END IF;
3640:
3641: EXCEPTION

Line 3643: x_return_status := FND_API.G_RET_STS_ERROR;

3639: END IF;
3640:
3641: EXCEPTION
3642: WHEN OTHERS THEN
3643: x_return_status := FND_API.G_RET_STS_ERROR;
3644: l_sqlerrno := to_char(SQLCODE);
3645: l_sqlerrmsg := substr(SQLERRM, 1,2000);
3646: l_error_msg := 'Exception in CS_Counter_Value_Post_Ins for counter_grp_log_id:' || TO_CHAR(l_counter_grp_log_id)
3647: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;

Line 3674: x_return_status := FND_API.G_RET_STS_SUCCESS;

3670: l_error_msg VARCHAR2(4000);
3671: l_return_status VARCHAR2(2000);
3672:
3673: BEGIN
3674: x_return_status := FND_API.G_RET_STS_SUCCESS;
3675:
3676: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
3677: RETURN;
3678: END IF;

Line 3683: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3679:
3680: l_counter_grp_log_id := p_counter_grp_log_id;
3681:
3682: csm_counter_event_pkg.CTR_VAL_MAKE_DIRTY_FOREACHUSER(l_counter_grp_log_id, l_error_msg, l_return_status);
3683: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3684: csm_util_pkg.LOG(l_error_msg, 'CSM_WF_PKG.CS_Counter_Value_Pre_Upd', FND_LOG.LEVEL_ERROR);
3685: END IF;
3686:
3687: EXCEPTION

Line 3689: x_return_status := FND_API.G_RET_STS_ERROR;

3685: END IF;
3686:
3687: EXCEPTION
3688: WHEN OTHERS THEN
3689: x_return_status := FND_API.G_RET_STS_ERROR;
3690: l_sqlerrno := to_char(SQLCODE);
3691: l_sqlerrmsg := substr(SQLERRM, 1,2000);
3692: l_error_msg := 'Exception in CS_Counter_Value_Pre_Upd for counter_grp_log_id:' || TO_CHAR(l_counter_grp_log_id)
3693: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;