52:
53: IF nvl(x_return_status,'N') <> 'E' THEN
54: -- Debug Message
55: IF l_debug THEN
56: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
57: 'Sales Force Id: ' || l_salesforce_id || ' Sales Group Id :' || l_sales_group_id ||' Person id :'||l_person_id );
58: END IF;
59: UPDATE AS_SALES_CREDITS
60: SET SALESFORCE_ID = l_salesforce_id,
87: END IF;
88:
89: EXCEPTION
90: WHEN FND_API.G_EXC_ERROR THEN
91: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
92: P_API_NAME => L_API_NAME
93: ,P_PKG_NAME => G_PKG_NAME
94: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
95: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
91: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
92: P_API_NAME => L_API_NAME
93: ,P_PKG_NAME => G_PKG_NAME
94: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
95: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
96: ,X_MSG_COUNT => X_MSG_COUNT
97: ,X_MSG_DATA => X_MSG_DATA
98: ,X_RETURN_STATUS => X_RETURN_STATUS);
99:
97: ,X_MSG_DATA => X_MSG_DATA
98: ,X_RETURN_STATUS => X_RETURN_STATUS);
99:
100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
101: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
102: P_API_NAME => L_API_NAME
103: ,P_PKG_NAME => G_PKG_NAME
104: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
105: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
101: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
102: P_API_NAME => L_API_NAME
103: ,P_PKG_NAME => G_PKG_NAME
104: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
105: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
106: ,X_MSG_COUNT => X_MSG_COUNT
107: ,X_MSG_DATA => X_MSG_DATA
108: ,X_RETURN_STATUS => X_RETURN_STATUS);
109:
107: ,X_MSG_DATA => X_MSG_DATA
108: ,X_RETURN_STATUS => X_RETURN_STATUS);
109:
110: WHEN OTHERS THEN
111: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
112: P_API_NAME => L_API_NAME
113: ,P_PKG_NAME => G_PKG_NAME
114: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
115: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
110: WHEN OTHERS THEN
111: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
112: P_API_NAME => L_API_NAME
113: ,P_PKG_NAME => G_PKG_NAME
114: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
115: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
116: ,X_MSG_COUNT => X_MSG_COUNT
117: ,X_MSG_DATA => X_MSG_DATA
118: ,X_RETURN_STATUS => X_RETURN_STATUS);
111: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
112: P_API_NAME => L_API_NAME
113: ,P_PKG_NAME => G_PKG_NAME
114: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
115: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
116: ,X_MSG_COUNT => X_MSG_COUNT
117: ,X_MSG_DATA => X_MSG_DATA
118: ,X_RETURN_STATUS => X_RETURN_STATUS);
119: END RECONCILE_SALESCREDIT;
193: X_sales_stage_id := l_sales_stage_id;
194: X_sales_methodology_id := l_sales_methodology_id;
195: EXCEPTION
196: WHEN FND_API.G_EXC_ERROR THEN
197: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
198: P_API_NAME => L_API_NAME
199: ,P_PKG_NAME => G_PKG_NAME
200: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
201: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
197: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
198: P_API_NAME => L_API_NAME
199: ,P_PKG_NAME => G_PKG_NAME
200: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
201: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
202: ,X_MSG_COUNT => X_MSG_COUNT
203: ,X_MSG_DATA => X_MSG_DATA
204: ,X_RETURN_STATUS => X_RETURN_STATUS);
205:
203: ,X_MSG_DATA => X_MSG_DATA
204: ,X_RETURN_STATUS => X_RETURN_STATUS);
205:
206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
207: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
208: P_API_NAME => L_API_NAME
209: ,P_PKG_NAME => G_PKG_NAME
210: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
211: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
207: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
208: P_API_NAME => L_API_NAME
209: ,P_PKG_NAME => G_PKG_NAME
210: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
211: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
212: ,X_MSG_COUNT => X_MSG_COUNT
213: ,X_MSG_DATA => X_MSG_DATA
214: ,X_RETURN_STATUS => X_RETURN_STATUS);
215:
213: ,X_MSG_DATA => X_MSG_DATA
214: ,X_RETURN_STATUS => X_RETURN_STATUS);
215:
216: WHEN OTHERS THEN
217: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
218: P_API_NAME => L_API_NAME
219: ,P_PKG_NAME => G_PKG_NAME
220: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
221: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
216: WHEN OTHERS THEN
217: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
218: P_API_NAME => L_API_NAME
219: ,P_PKG_NAME => G_PKG_NAME
220: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
221: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
222: ,X_MSG_COUNT => X_MSG_COUNT
223: ,X_MSG_DATA => X_MSG_DATA
224: ,X_RETURN_STATUS => X_RETURN_STATUS);
217: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
218: P_API_NAME => L_API_NAME
219: ,P_PKG_NAME => G_PKG_NAME
220: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
221: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
222: ,X_MSG_COUNT => X_MSG_COUNT
223: ,X_MSG_DATA => X_MSG_DATA
224: ,X_RETURN_STATUS => X_RETURN_STATUS);
225: END CHECK_SALES_STAGE;
270: header_rec.owner_salesforce_id := P_Identity_Salesforce_Id;
271: header_rec.owner_sales_group_id := P_identity_salesgroup_id;
272: header_rec.last_update_date := l_last_update_date;
273: IF l_debug THEN
274: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
275: 'Before calling Update opp Header Lead id : ' || p_lead_id ||' Sales Force id :'|| P_Identity_Salesforce_Id ||
276: ' Sales Group Id :' || P_identity_salesgroup_id ||
277: ' Sales Methodology id :'||p_sales_methodology_id );
278: END IF;
298: RAISE FND_API.G_EXC_ERROR;
299: END IF;
300: EXCEPTION
301: WHEN FND_API.G_EXC_ERROR THEN
302: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
303: P_API_NAME => L_API_NAME
304: ,P_PKG_NAME => G_PKG_NAME
305: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
306: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
302: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
303: P_API_NAME => L_API_NAME
304: ,P_PKG_NAME => G_PKG_NAME
305: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
306: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
307: ,X_MSG_COUNT => X_MSG_COUNT
308: ,X_MSG_DATA => X_MSG_DATA
309: ,X_RETURN_STATUS => X_RETURN_STATUS);
310:
308: ,X_MSG_DATA => X_MSG_DATA
309: ,X_RETURN_STATUS => X_RETURN_STATUS);
310:
311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
312: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
313: P_API_NAME => L_API_NAME
314: ,P_PKG_NAME => G_PKG_NAME
315: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
316: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
312: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
313: P_API_NAME => L_API_NAME
314: ,P_PKG_NAME => G_PKG_NAME
315: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
316: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
317: ,X_MSG_COUNT => X_MSG_COUNT
318: ,X_MSG_DATA => X_MSG_DATA
319: ,X_RETURN_STATUS => X_RETURN_STATUS);
320:
318: ,X_MSG_DATA => X_MSG_DATA
319: ,X_RETURN_STATUS => X_RETURN_STATUS);
320:
321: WHEN OTHERS THEN
322: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
323: P_API_NAME => L_API_NAME
324: ,P_PKG_NAME => G_PKG_NAME
325: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
326: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
321: WHEN OTHERS THEN
322: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
323: P_API_NAME => L_API_NAME
324: ,P_PKG_NAME => G_PKG_NAME
325: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
326: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
327: ,X_MSG_COUNT => X_MSG_COUNT
328: ,X_MSG_DATA => X_MSG_DATA
329: ,X_RETURN_STATUS => X_RETURN_STATUS);
322: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
323: P_API_NAME => L_API_NAME
324: ,P_PKG_NAME => G_PKG_NAME
325: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
326: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
327: ,X_MSG_COUNT => X_MSG_COUNT
328: ,X_MSG_DATA => X_MSG_DATA
329: ,X_RETURN_STATUS => X_RETURN_STATUS);
330: END RECONCILE_SALESMETHODOLOGY;