DBA Data[Home] [Help]

APPS.ASN_METHODOLOGY_PVT dependencies on FND_API

Line 7: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASN_METHODOLOGY_PVT';
5: PROCEDURE create_sales_meth_data
6: ( P_Api_Version_Number IN NUMBER,
7: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
8: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
9: p_object_type_code IN VARCHAR2,
10: p_object_id IN VARCHAR2,
11: p_sales_methodology_id IN NUMBER,

Line 8: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASN_METHODOLOGY_PVT';
5: PROCEDURE create_sales_meth_data
6: ( P_Api_Version_Number IN NUMBER,
7: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
8: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
9: p_object_type_code IN VARCHAR2,
10: p_object_id IN VARCHAR2,
11: p_sales_methodology_id IN NUMBER,
12: X_Return_Status OUT NOCOPY VARCHAR2,

Line 97: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

93:
94: SAVEPOINT CREATE_SALES_METH_DATA_PVT;
95:
96: -- Standard call to check for call compatibility.
97: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
98: p_api_version_number,
99: l_api_name,
100: G_PKG_NAME)
101: THEN

Line 102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

98: p_api_version_number,
99: l_api_name,
100: G_PKG_NAME)
101: THEN
102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
103: END IF;
104:
105: -- Initialize message list if p_init_msg_list is set to TRUE.
106: IF FND_API.to_Boolean( p_init_msg_list )

Line 106: IF FND_API.to_Boolean( p_init_msg_list )

102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
103: END IF;
104:
105: -- Initialize message list if p_init_msg_list is set to TRUE.
106: IF FND_API.to_Boolean( p_init_msg_list )
107: THEN
108: FND_MSG_PUB.initialize;
109: END IF;
110:

Line 111: x_return_status := FND_API.G_RET_STS_SUCCESS;

107: THEN
108: FND_MSG_PUB.initialize;
109: END IF;
110:
111: x_return_status := FND_API.G_RET_STS_SUCCESS;
112: -- BEGIN API BODY
113:
114: -- Validate object_type_code
115: IF p_object_type_code <> 'LEAD' AND p_object_type_code <> 'OPPORTUNITY' THEN

Line 126: RAISE FND_API.G_EXC_ERROR;

122: G_PROC_NAME,
123: 'ASN_CMMN_OBJTYPE_INV_ERR');
124: END IF;
125: END IF;
126: RAISE FND_API.G_EXC_ERROR;
127: END IF;
128:
129: -- Validate sales methodology ID
130: OPEN c_methodology_exists(p_sales_methodology_id);

Line 301: IF FND_API.to_Boolean( p_commit )

297: END LOOP;
298:
299:
300: -- END API BODY
301: IF FND_API.to_Boolean( p_commit )
302: THEN
303: COMMIT WORK;
304: END IF;
305:

Line 320: WHEN FND_API.G_EXC_ERROR THEN

316: 'end');
317: END IF;
318:
319: EXCEPTION
320: WHEN FND_API.G_EXC_ERROR THEN
321: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
322: P_API_NAME => L_API_NAME
323: ,P_PKG_NAME => G_PKG_NAME
324: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

326: ,X_MSG_COUNT => X_MSG_COUNT
327: ,X_MSG_DATA => X_MSG_DATA
328: ,X_RETURN_STATUS => X_RETURN_STATUS);
329:
330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
331: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
332: P_API_NAME => L_API_NAME
333: ,P_PKG_NAME => G_PKG_NAME
334: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR