57: , 'Calling CSL_JTF_TASK_ASS_ACC_PKG.INSERT_ALL_ACC_RECORDS'
58: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
59: END IF;
60: CSL_JTF_TASK_ASS_ACC_PKG.INSERT_ALL_ACC_RECORDS( p_resource_id, x_return_status );
61: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
62: RAISE FND_API.G_EXC_ERROR;
63: END IF;
64:
65: COMMIT;
58: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
59: END IF;
60: CSL_JTF_TASK_ASS_ACC_PKG.INSERT_ALL_ACC_RECORDS( p_resource_id, x_return_status );
61: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
62: RAISE FND_API.G_EXC_ERROR;
63: END IF;
64:
65: COMMIT;
66:
74: END IF;
75: CSL_CS_INCIDENTS_ALL_ACC_PKG.INSERT_ALL_ACC_RECORDS
76: ( p_resource_id
77: , x_return_status );
78: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
79: RAISE FND_API.G_EXC_ERROR;
80: END IF;
81:
82: COMMIT;
75: CSL_CS_INCIDENTS_ALL_ACC_PKG.INSERT_ALL_ACC_RECORDS
76: ( p_resource_id
77: , x_return_status );
78: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
79: RAISE FND_API.G_EXC_ERROR;
80: END IF;
81:
82: COMMIT;
83:
91: END IF;
92: CSL_JTF_TASKS_ACC_PKG.INSERT_ALL_ACC_RECORDS
93: ( p_resource_id
94: , x_return_status );
95: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
96: RAISE FND_API.G_EXC_ERROR;
97: END IF;
98:
99: COMMIT;
92: CSL_JTF_TASKS_ACC_PKG.INSERT_ALL_ACC_RECORDS
93: ( p_resource_id
94: , x_return_status );
95: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
96: RAISE FND_API.G_EXC_ERROR;
97: END IF;
98:
99: COMMIT;
100:
105: , 'Calling CSL_CSP_INV_LOC_ASS_ACC_PKG.INSERT_ALL_ACC_RECORDS'
106: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
107: END IF;
108: CSL_CSP_INV_LOC_ASS_ACC_PKG.INSERT_ALL_ACC_RECORDS( p_resource_id, x_return_status );
109: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
110: RAISE FND_API.G_EXC_ERROR;
111: END IF;
112:
113: COMMIT;
106: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
107: END IF;
108: CSL_CSP_INV_LOC_ASS_ACC_PKG.INSERT_ALL_ACC_RECORDS( p_resource_id, x_return_status );
109: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
110: RAISE FND_API.G_EXC_ERROR;
111: END IF;
112:
113: COMMIT;
114:
119: , 'Calling CSL_CSP_LOCATIONS_ACC_PKG.INSERT_ALL_ACC_RECORDS'
120: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
121: END IF;
122: CSL_CSP_LOCATIONS_ACC_PKG.INSERT_ALL_ACC_RECORDS( p_resource_id, x_return_status );
123: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
124: RAISE FND_API.G_EXC_ERROR;
125: END IF;
126:
127: COMMIT;
120: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
121: END IF;
122: CSL_CSP_LOCATIONS_ACC_PKG.INSERT_ALL_ACC_RECORDS( p_resource_id, x_return_status );
123: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
124: RAISE FND_API.G_EXC_ERROR;
125: END IF;
126:
127: COMMIT;
128:
133: , 'Calling CSL_CSP_REQ_HEADERS_ACC_PKG.INSERT_ALL_ACC_RECORDS'
134: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
135: END IF;
136: CSL_CSP_REQ_HEADERS_ACC_PKG.INSERT_ALL_ACC_RECORDS( p_resource_id, x_return_status );
137: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
138: RAISE FND_API.G_EXC_ERROR;
139: END IF;
140:
141: COMMIT;
134: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
135: END IF;
136: CSL_CSP_REQ_HEADERS_ACC_PKG.INSERT_ALL_ACC_RECORDS( p_resource_id, x_return_status );
137: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
138: RAISE FND_API.G_EXC_ERROR;
139: END IF;
140:
141: COMMIT;
142:
147: , 'Calling CSL_CSP_REQ_LINES_ACC_PKG.INSERT_ALL_ACC_RECORDS'
148: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
149: END IF;
150: CSL_CSP_REQ_LINES_ACC_PKG.INSERT_ALL_ACC_RECORDS( p_resource_id, x_return_status );
151: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
152: RAISE FND_API.G_EXC_ERROR;
153: END IF;
154:
155: COMMIT;
148: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
149: END IF;
150: CSL_CSP_REQ_LINES_ACC_PKG.INSERT_ALL_ACC_RECORDS( p_resource_id, x_return_status );
151: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
152: RAISE FND_API.G_EXC_ERROR;
153: END IF;
154:
155: COMMIT;
156:
161: , 'Calling CSL_WF_NOTIFICATION_AT_ACC_PKG.INSERT_ALL_ACC_RECORDS'
162: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
163: END IF;
164: CSL_WF_NOTIFICATION_AT_ACC_PKG.INSERT_ALL_ACC_RECORDS( p_resource_id, x_return_status );
165: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
166: RAISE FND_API.G_EXC_ERROR;
167: END IF;
168:
169: COMMIT;
162: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
163: END IF;
164: CSL_WF_NOTIFICATION_AT_ACC_PKG.INSERT_ALL_ACC_RECORDS( p_resource_id, x_return_status );
165: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
166: RAISE FND_API.G_EXC_ERROR;
167: END IF;
168:
169: COMMIT;
170:
175: , 'Calling CSL_JTF_RS_GRP_MEM_ACC_PKG.INSERT_ALL_ACC_RECORDS'
176: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
177: END IF;
178: CSL_JTF_RS_GRP_MEM_ACC_PKG.INSERT_ALL_ACC_RECORDS( p_resource_id, x_return_status );
179: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
180: RAISE FND_API.G_EXC_ERROR;
181: END IF;
182:
183: COMMIT;
176: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
177: END IF;
178: CSL_JTF_RS_GRP_MEM_ACC_PKG.INSERT_ALL_ACC_RECORDS( p_resource_id, x_return_status );
179: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
180: RAISE FND_API.G_EXC_ERROR;
181: END IF;
182:
183: COMMIT;
184:
189: , 'Calling CSL_MTL_SYSTEM_ITEMS_ACC_PKG.INSERT_ALL_ACC_RECORDS'
190: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
191: END IF;
192: CSL_MTL_SYSTEM_ITEMS_ACC_PKG.INSERT_ALL_ACC_RECORDS( p_resource_id, x_return_status );
193: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
194: RAISE FND_API.G_EXC_ERROR;
195: END IF;
196:
197: /*Call Concurrent programs ( always after hook packages because of dependencies )*/
190: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
191: END IF;
192: CSL_MTL_SYSTEM_ITEMS_ACC_PKG.INSERT_ALL_ACC_RECORDS( p_resource_id, x_return_status );
193: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
194: RAISE FND_API.G_EXC_ERROR;
195: END IF;
196:
197: /*Call Concurrent programs ( always after hook packages because of dependencies )*/
198:
239: , 'Leaving CREATE_USER'
240: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
241: END IF;
242:
243: x_return_status := FND_API.G_RET_STS_SUCCESS;
244: EXCEPTION
245: WHEN FND_API.G_EXC_ERROR THEN
246: /*** api call failed -> rolback and log error ***/
247: ROLLBACK ;
241: END IF;
242:
243: x_return_status := FND_API.G_RET_STS_SUCCESS;
244: EXCEPTION
245: WHEN FND_API.G_EXC_ERROR THEN
246: /*** api call failed -> rolback and log error ***/
247: ROLLBACK ;
248:
249: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
253: , 'Exception occurred in CREATE_USER when calling API'
254: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
255: END IF;
256: fnd_msg_pub.Add_Exc_Msg('CSL_USER_PKG','CREATE_USER','API error');
257: x_return_status := FND_API.G_RET_STS_ERROR;
258:
259: WHEN OTHERS THEN
260: /*** uncaught exception -> rollback and log sql error ***/
261: ROLLBACK;
268: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
269: END IF;
270:
271: fnd_msg_pub.Add_Exc_Msg('CSL_USER_PKG','CREATE_USER',sqlerrm);
272: x_return_status := FND_API.G_RET_STS_ERROR;
273: END CREATE_USER;
274:
275: /* Put all delete_user procedures here */
276: /* TODO add jtf_RS_resource_EXTNS and JTF_group_members and fnd_user*/
851: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
852: , 'csl_user_pkg');
853: END IF;
854:
855: x_return_status := FND_API.G_RET_STS_SUCCESS;
856: EXCEPTION
857: WHEN FND_API.G_EXC_ERROR THEN
858: /*** api call failed -> rolback and log error ***/
859: ROLLBACK;
853: END IF;
854:
855: x_return_status := FND_API.G_RET_STS_SUCCESS;
856: EXCEPTION
857: WHEN FND_API.G_EXC_ERROR THEN
858: /*** api call failed -> rolback and log error ***/
859: ROLLBACK;
860:
861: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
866: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR
867: , 'csl_user_pkg');
868: END IF;
869: fnd_msg_pub.Add_Exc_Msg('CSL_USER_PKG','DELETE_USER','API error');
870: x_return_status := FND_API.G_RET_STS_ERROR;
871:
872: WHEN OTHERS THEN
873: /*** uncaught exception -> rollback and log sql error ***/
874: ROLLBACK;
882: , 'csl_user_pkg');
883: END IF;
884:
885: fnd_msg_pub.Add_Exc_Msg('CSL_USER_PKG','DELETE_USER',sqlerrm);
886: x_return_status := FND_API.G_RET_STS_ERROR;
887: END DELETE_USER;
888:
889: END CSL_USER_PKG;