DBA Data[Home] [Help]

APPS.RCV_UTILITIES dependencies on FND_API

Line 10: ( p_commit IN VARCHAR2 default FND_API.G_FALSE,

6:
7: /* This API is called by AP in their Supplier Merge program */
8:
9: PROCEDURE Merge_Vendor
10: ( p_commit IN VARCHAR2 default FND_API.G_FALSE,
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 32: x_return_status := FND_API.G_RET_STS_SUCCESS;

28: asn_debug.put_line('p_dup_vendor_site_id ' || p_dup_vendor_site_id);
29: END IF;
30:
31: -- Initialize API return status to success
32: x_return_status := FND_API.G_RET_STS_SUCCESS;
33: l_last_updated_by := FND_GLOBAL.user_id;
34:
35: /* Per discussion with AP:
36: - value of message count should be 0 and data should be null

Line 133: IF FND_API.To_Boolean( p_commit ) THEN

129: asn_debug.put_line('x_msg_count: ' || x_msg_count);
130: asn_debug.put_line('x_msg_data: ' || x_msg_data);
131: END IF;
132:
133: IF FND_API.To_Boolean( p_commit ) THEN
134: COMMIT WORK;
135: END IF;
136:
137: EXCEPTION

Line 140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

136:
137: EXCEPTION
138: WHEN OTHERS THEN
139: ROLLBACK;
140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
141:
142: IF (g_asn_debug = 'Y') THEN
143: asn_debug.put_line('x_return_status: ' || x_return_status);
144: asn_debug.put_line('x_msg_count: ' || x_msg_count);