DBA Data[Home] [Help]

APPS.CSL_USER_PKG dependencies on FND_API

Line 61: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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;

Line 62: RAISE FND_API.G_EXC_ERROR;

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:

Line 78: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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;

Line 79: RAISE FND_API.G_EXC_ERROR;

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:

Line 95: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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;

Line 96: RAISE FND_API.G_EXC_ERROR;

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:

Line 109: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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;

Line 110: RAISE FND_API.G_EXC_ERROR;

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:

Line 123: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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;

Line 124: RAISE FND_API.G_EXC_ERROR;

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:

Line 137: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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;

Line 138: RAISE FND_API.G_EXC_ERROR;

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:

Line 151: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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;

Line 152: RAISE FND_API.G_EXC_ERROR;

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:

Line 165: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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;

Line 166: RAISE FND_API.G_EXC_ERROR;

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:

Line 179: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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;

Line 180: RAISE FND_API.G_EXC_ERROR;

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:

Line 193: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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 )*/

Line 194: RAISE FND_API.G_EXC_ERROR;

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:

Line 243: x_return_status := FND_API.G_RET_STS_SUCCESS;

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 ;

Line 245: WHEN FND_API.G_EXC_ERROR THEN

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

Line 257: x_return_status := FND_API.G_RET_STS_ERROR;

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;

Line 272: x_return_status := FND_API.G_RET_STS_ERROR;

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*/

Line 855: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;

Line 857: WHEN FND_API.G_EXC_ERROR THEN

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

Line 870: x_return_status := FND_API.G_RET_STS_ERROR;

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;

Line 886: x_return_status := FND_API.G_RET_STS_ERROR;

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;