DBA Data[Home] [Help]

APPS.AST_ASN_INTEROP dependencies on AS_UTILITY_PVT

Line 56: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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,

Line 91: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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:

Line 101: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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:

Line 111: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 114: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

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);

Line 115: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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;

Line 197: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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:

Line 207: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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:

Line 217: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 220: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

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);

Line 221: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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;

Line 274: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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;

Line 302: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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:

Line 312: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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:

Line 322: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 325: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

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);

Line 326: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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;