APPS.PN_VENDORMERGE_GRP dependencies on FND_API

Line 8: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

4: G_PKG_NAME CONSTANT VARCHAR2(30):='PN_VendorMerge_GRP';
5:
6: PROCEDURE Merge_Vendor(
7: p_api_version IN NUMBER,
8: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
9: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
10: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
11: x_return_status OUT NOCOPY VARCHAR2,
12: x_msg_count OUT NOCOPY NUMBER,

Line 9: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

5:
6: PROCEDURE Merge_Vendor(
7: p_api_version IN NUMBER,
8: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
9: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
10: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
11: x_return_status OUT NOCOPY VARCHAR2,
12: x_msg_count OUT NOCOPY NUMBER,
13: x_msg_data OUT NOCOPY VARCHAR2,

Line 10: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

6: PROCEDURE Merge_Vendor(
7: p_api_version IN NUMBER,
8: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
9: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
10: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
11: x_return_status OUT NOCOPY VARCHAR2,
12: x_msg_count OUT NOCOPY NUMBER,
13: x_msg_data OUT NOCOPY VARCHAR2,
14: p_vendor_id IN NUMBER,

Line 29: x_return_status := FND_API.G_RET_STS_SUCCESS;

25:
26: BEGIN
27:
28: -- Initialize API return status to success
29: x_return_status := FND_API.G_RET_STS_SUCCESS;
30:
31: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
32: p_api_version ,
33: l_api_name ,

Line 31: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

27:
28: -- Initialize API return status to success
29: x_return_status := FND_API.G_RET_STS_SUCCESS;
30:
31: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
32: p_api_version ,
33: l_api_name ,
34: G_PKG_NAME )
35: THEN

Line 36: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

32: p_api_version ,
33: l_api_name ,
34: G_PKG_NAME )
35: THEN
36: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
37: END IF;
38:
39: -- Initialize API message list if necessary.
40: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 41: IF FND_API.to_Boolean( p_init_msg_list) THEN

37: END IF;
38:
39: -- Initialize API message list if necessary.
40: -- Initialize message list if p_init_msg_list is set to TRUE.
41: IF FND_API.to_Boolean( p_init_msg_list) THEN
42: FND_MSG_PUB.initialize;
43: END IF;
44:
45: UPDATE pn_payment_terms

Line 56: x_return_status := FND_API.G_RET_STS_SUCCESS;

52:
53: -- Prepare message name
54: FND_MESSAGE.SET_NAME('PN','PN_PAYMENT_TERMS');
55: IF SQL%FOUND THEN
56: x_return_status := FND_API.G_RET_STS_SUCCESS;
57: l_row_count := SQL%ROWCOUNT;
58: ELSE
59: l_row_count := 0;
60: END IF;

Line 77: x_return_status := FND_API.G_RET_STS_SUCCESS;

73:
74: -- Prepare message name
75: FND_MESSAGE.SET_NAME('PN','PN_PAYMENT_ITEMS');
76: IF SQL%FOUND THEN
77: x_return_status := FND_API.G_RET_STS_SUCCESS;
78: l_row_count := SQL%ROWCOUNT;
79: ELSE
80: l_row_count := 0;
81: END IF;

Line 98: x_return_status := FND_API.G_RET_STS_SUCCESS;

94:
95: -- Prepare message name
96: FND_MESSAGE.SET_NAME('PN','PN_TERM_TEMPLATES');
97: IF SQL%FOUND THEN
98: x_return_status := FND_API.G_RET_STS_SUCCESS;
99: l_row_count := SQL%ROWCOUNT;
100: ELSE
101: l_row_count := 0;
102: END IF;

Line 118: x_return_status := FND_API.G_RET_STS_SUCCESS;

114:
115: -- Prepare message name
116: FND_MESSAGE.SET_NAME('PN','PN_PAYMENT_TERMS_HISTORY');
117: IF SQL%FOUND THEN
118: x_return_status := FND_API.G_RET_STS_SUCCESS;
119: l_row_count := SQL%ROWCOUNT;
120: ELSE
121: l_row_count := 0;
122: END IF;

Line 139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

135: EXCEPTION
136:
137: WHEN OTHERS THEN
138: ROLLBACK ;
139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
140: FND_MSG_PUB.Count_And_Get
141: ( p_count => x_msg_count,
142: p_data => x_msg_data
143: );