APPS.PO_VENDORMERGE_GRP dependencies on FND_API

Line 14: -- Default = FND_API.G_FALSE

10: -- Pre-reqs : None.
11: -- Parameters :
12: -- IN : p_api_version IN NUMBER Required
13: -- p_init_msg_list IN VARCHAR2 Optional
14: -- Default = FND_API.G_FALSE
15: -- p_commit IN VARCHAR2 Optional
16: -- Default = FND_API.G_FALSE
17: -- p_validation_level IN NUMBER Optional
18: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 16: -- Default = FND_API.G_FALSE

12: -- IN : p_api_version IN NUMBER Required
13: -- p_init_msg_list IN VARCHAR2 Optional
14: -- Default = FND_API.G_FALSE
15: -- p_commit IN VARCHAR2 Optional
16: -- Default = FND_API.G_FALSE
17: -- p_validation_level IN NUMBER Optional
18: -- Default = FND_API.G_VALID_LEVEL_FULL
19: -- parameter1
20: -- parameter2

Line 18: -- Default = FND_API.G_VALID_LEVEL_FULL

14: -- Default = FND_API.G_FALSE
15: -- p_commit IN VARCHAR2 Optional
16: -- Default = FND_API.G_FALSE
17: -- p_validation_level IN NUMBER Optional
18: -- Default = FND_API.G_VALID_LEVEL_FULL
19: -- parameter1
20: -- parameter2
21: -- .
22: -- .

Line 32: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

28: -- End of comments
29:
30: Procedure Merge_Vendor(
31: p_api_version IN NUMBER,
32: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
33: p_commit IN VARCHAR2 default FND_API.G_FALSE,
34: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
35: x_return_status OUT NOCOPY VARCHAR2,
36: x_msg_count OUT NOCOPY NUMBER,

Line 33: p_commit IN VARCHAR2 default FND_API.G_FALSE,

29:
30: Procedure Merge_Vendor(
31: p_api_version IN NUMBER,
32: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
33: p_commit IN VARCHAR2 default FND_API.G_FALSE,
34: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
35: x_return_status OUT NOCOPY VARCHAR2,
36: x_msg_count OUT NOCOPY NUMBER,
37: x_msg_data OUT NOCOPY VARCHAR2,

Line 34: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,

30: Procedure Merge_Vendor(
31: p_api_version IN NUMBER,
32: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
33: p_commit IN VARCHAR2 default FND_API.G_FALSE,
34: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
35: x_return_status OUT NOCOPY VARCHAR2,
36: x_msg_count OUT NOCOPY NUMBER,
37: x_msg_data OUT NOCOPY VARCHAR2,
38: p_vendor_id IN NUMBER,

Line 86: x_return_status := FND_API.G_RET_STS_SUCCESS;

82: PO_LOG.proc_begin(d_module, 'p_dup_party_site_id', p_dup_party_site_id);
83: END IF;
84:
85: -- Initialize API return status to success
86: x_return_status := FND_API.G_RET_STS_SUCCESS;
87:
88: l_last_updated_by := FND_GLOBAL.user_id;
89: -- Check for call compatibility.
90: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

Line 90: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

86: x_return_status := FND_API.G_RET_STS_SUCCESS;
87:
88: l_last_updated_by := FND_GLOBAL.user_id;
89: -- Check for call compatibility.
90: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
91: p_api_version ,
92: l_api_name ,
93: G_PKG_NAME )
94: THEN

Line 95: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

91: p_api_version ,
92: l_api_name ,
93: G_PKG_NAME )
94: THEN
95: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
96: END IF;
97:
98: -- Initialize API message list if necessary.
99: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 100: IF FND_API.to_Boolean( p_init_msg_list) THEN

96: END IF;
97:
98: -- Initialize API message list if necessary.
99: -- Initialize message list if p_init_msg_list is set to TRUE.
100: IF FND_API.to_Boolean( p_init_msg_list) THEN
101: FND_MSG_PUB.initialize;
102: END IF;
103:
104: d_progress := 10;

Line 599: x_return_status := FND_API.G_RET_STS_SUCCESS;

595:
596: -- Prepare message name
597: FND_MESSAGE.SET_NAME('PO','PO_ASL_ATTRIBUTES');
598: IF SQL%FOUND THEN
599: x_return_status := FND_API.G_RET_STS_SUCCESS;
600: l_row_count := SQL%ROWCOUNT;
601: ELSE
602: x_return_status := FND_API.G_RET_STS_ERROR;
603: l_row_count := 0;

Line 602: x_return_status := FND_API.G_RET_STS_ERROR;

598: IF SQL%FOUND THEN
599: x_return_status := FND_API.G_RET_STS_SUCCESS;
600: l_row_count := SQL%ROWCOUNT;
601: ELSE
602: x_return_status := FND_API.G_RET_STS_ERROR;
603: l_row_count := 0;
604: END IF;
605: FND_MESSAGE.SET_TOKEN('ROWS_DELETED',l_row_count);
606: -- Add message to API message list.

Line 642: IF FND_API.To_Boolean( p_commit ) THEN

638:
639:
640:
641: -- Standard check of p_commit.
642: IF FND_API.To_Boolean( p_commit ) THEN
643: COMMIT WORK;
644: END IF;
645:
646: IF (PO_LOG.d_proc) THEN

Line 656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

652: EXCEPTION
653:
654: WHEN OTHERS THEN
655: ROLLBACK;
656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
657:
658: IF (PO_LOG.d_proc) THEN
659: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
660: PO_LOG.proc_end(d_module);