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.AST_ASN_INTEROP dependencies on FND_API

Line 13: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

9: --
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AST_ASN_INTEROP';
11: PROCEDURE RECONCILE_SALESCREDIT(
12: p_api_version_number IN NUMBER,
13: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
14: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
15: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
16: p_lead_id IN NUMBER,
17: X_Return_Status OUT NOCOPY VARCHAR2,

Line 14: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AST_ASN_INTEROP';
11: PROCEDURE RECONCILE_SALESCREDIT(
12: p_api_version_number IN NUMBER,
13: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
14: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
15: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
16: p_lead_id IN NUMBER,
17: X_Return_Status OUT NOCOPY VARCHAR2,
18: X_Msg_Count OUT NOCOPY NUMBER,

Line 15: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

11: PROCEDURE RECONCILE_SALESCREDIT(
12: p_api_version_number IN NUMBER,
13: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
14: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
15: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
16: p_lead_id IN NUMBER,
17: X_Return_Status OUT NOCOPY VARCHAR2,
18: X_Msg_Count OUT NOCOPY NUMBER,
19: X_Msg_Data OUT NOCOPY VARCHAR2

Line 38: x_return_status := FND_API.G_RET_STS_SUCCESS;

34: -- Standard Start of API savepoint
35: SAVEPOINT RECONCILE_SALESCREDIT_PVT;
36:
37: -- Initialize API return status to SUCCESS
38: x_return_status := FND_API.G_RET_STS_SUCCESS;
39:
40: BEGIN
41: SELECT PERSON_ID,SALESFORCE_ID,SALES_GROUP_ID
42: INTO l_person_id,l_salesforce_id,l_sales_group_id

Line 50: RAISE FND_API.G_EXC_ERROR;

46: EXCEPTION
47: WHEN NO_DATA_FOUND OR TOO_MANY_ROWS THEN
48: FND_MESSAGE.Set_Name('AST', 'AST_ASN_INTEROP_MUST_OWNER');
49: FND_MSG_PUB.ADD;
50: RAISE FND_API.G_EXC_ERROR;
51: END;
52:
53: IF nvl(x_return_status,'N') <> 'E' THEN
54: -- Debug Message

Line 84: IF FND_API.to_Boolean( p_commit )

80: and salesgroup_id =acc.sales_group_id
81: );
82: END IF;
83:
84: IF FND_API.to_Boolean( p_commit )
85: THEN
86: COMMIT WORK;
87: END IF;
88:

Line 90: WHEN FND_API.G_EXC_ERROR THEN

86: COMMIT WORK;
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

Line 100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

96: ,X_MSG_COUNT => X_MSG_COUNT
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

Line 123: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

119: END RECONCILE_SALESCREDIT;
120:
121: PROCEDURE CHECK_SALES_STAGE(
122: p_api_version_number IN NUMBER,
123: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
124: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
125: p_sales_lead_id IN NUMBER,
126: X_sales_stage_id OUT NOCOPY NUMBER,
127: X_sales_methodology_id OUT NOCOPY NUMBER,

Line 124: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

120:
121: PROCEDURE CHECK_SALES_STAGE(
122: p_api_version_number IN NUMBER,
123: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
124: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
125: p_sales_lead_id IN NUMBER,
126: X_sales_stage_id OUT NOCOPY NUMBER,
127: X_sales_methodology_id OUT NOCOPY NUMBER,
128: X_Return_Status OUT NOCOPY VARCHAR2,

Line 163: x_return_status := FND_API.G_RET_STS_SUCCESS;

159: BEGIN
160: -- Standard Start of API savepoint
161: SAVEPOINT CHECK_SALES_STAGE_PVT;
162: -- Initialize API return status to SUCCESS
163: x_return_status := FND_API.G_RET_STS_SUCCESS;
164: -- Initialize message list if p_init_msg_list is set to TRUE.
165: IF FND_API.to_Boolean( p_init_msg_list )
166: THEN
167: FND_MSG_PUB.initialize;

Line 165: IF FND_API.to_Boolean( p_init_msg_list )

161: SAVEPOINT CHECK_SALES_STAGE_PVT;
162: -- Initialize API return status to SUCCESS
163: x_return_status := FND_API.G_RET_STS_SUCCESS;
164: -- Initialize message list if p_init_msg_list is set to TRUE.
165: IF FND_API.to_Boolean( p_init_msg_list )
166: THEN
167: FND_MSG_PUB.initialize;
168: END IF;
169: OPEN c_lead(p_sales_lead_id);

Line 188: RAISE FND_API.G_EXC_ERROR;

184: x_return_status :='E';
185: CLOSE c_first_sales_stage;
186: FND_MESSAGE.Set_Name('AST', 'AST_STAGE_NOT_SETUP_FOR_METH');
187: FND_MSG_PUB.ADD;
188: RAISE FND_API.G_EXC_ERROR;
189: END IF;
190: CLOSE c_first_sales_stage;
191: END IF;
192: END IF;

Line 196: WHEN FND_API.G_EXC_ERROR THEN

192: END IF;
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

Line 206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

202: ,X_MSG_COUNT => X_MSG_COUNT
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

Line 229: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

225: END CHECK_SALES_STAGE;
226:
227: PROCEDURE RECONCILE_SALESMETHODOLOGY(
228: p_api_version_number IN NUMBER,
229: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
230: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
231: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
232: p_lead_id IN NUMBER,
233: p_sales_stage_id IN NUMBER,

Line 230: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

226:
227: PROCEDURE RECONCILE_SALESMETHODOLOGY(
228: p_api_version_number IN NUMBER,
229: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
230: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
231: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
232: p_lead_id IN NUMBER,
233: p_sales_stage_id IN NUMBER,
234: p_sales_methodology_id IN NUMBER,

Line 231: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

227: PROCEDURE RECONCILE_SALESMETHODOLOGY(
228: p_api_version_number IN NUMBER,
229: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
230: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
231: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
232: p_lead_id IN NUMBER,
233: p_sales_stage_id IN NUMBER,
234: p_sales_methodology_id IN NUMBER,
235: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,

Line 235: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,

231: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
232: p_lead_id IN NUMBER,
233: p_sales_stage_id IN NUMBER,
234: p_sales_methodology_id IN NUMBER,
235: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
236: P_Admin_Group_Id IN NUMBER,
237: P_Identity_Salesforce_Id IN NUMBER := NULL,
238: P_identity_salesgroup_id IN NUMBER := NULL,
239: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,

Line 260: x_return_status := FND_API.G_RET_STS_SUCCESS;

256: BEGIN
257: -- Standard Start of API savepoint
258: SAVEPOINT RECONCILE_SALESMETHODOLOGY_PVT;
259: -- Initialize API return status to SUCCESS
260: x_return_status := FND_API.G_RET_STS_SUCCESS;
261:
262: OPEN c_opp(p_lead_id);
263: FETCH c_opp into l_last_update_date;
264: CLOSE c_opp;

Line 297: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

293: x_msg_count => x_msg_count,
294: x_msg_data => x_msg_data,
295: x_lead_id => l_lead_id
296: );
297: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
298: RAISE FND_API.G_EXC_ERROR;
299: END IF;
300: EXCEPTION
301: WHEN FND_API.G_EXC_ERROR THEN

Line 298: RAISE FND_API.G_EXC_ERROR;

294: x_msg_data => x_msg_data,
295: x_lead_id => l_lead_id
296: );
297: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
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(

Line 301: WHEN FND_API.G_EXC_ERROR THEN

297: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
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

Line 311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

307: ,X_MSG_COUNT => X_MSG_COUNT
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