DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_VUHK dependencies on FND_API

Line 7: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

3:
4:
5: PROCEDURE Create_ServiceRequest_Pre
6: ( p_api_version IN NUMBER,
7: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
8: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
9: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
10: x_return_status OUT NOCOPY VARCHAR2,
11: x_msg_count OUT NOCOPY NUMBER,

Line 8: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

4:
5: PROCEDURE Create_ServiceRequest_Pre
6: ( p_api_version IN NUMBER,
7: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
8: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
9: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
10: x_return_status OUT NOCOPY VARCHAR2,
11: x_msg_count OUT NOCOPY NUMBER,
12: x_msg_data OUT NOCOPY VARCHAR2,

Line 9: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,

5: PROCEDURE Create_ServiceRequest_Pre
6: ( p_api_version IN NUMBER,
7: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
8: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
9: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
10: x_return_status OUT NOCOPY VARCHAR2,
11: x_msg_count OUT NOCOPY NUMBER,
12: x_msg_data OUT NOCOPY VARCHAR2,
13: p_resp_appl_id IN NUMBER DEFAULT NULL,

Line 35: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

31:
32:
33: PROCEDURE Create_ServiceRequest_Post
34: ( p_api_version IN NUMBER,
35: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
36: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
37: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
38: x_return_status OUT NOCOPY VARCHAR2,
39: x_msg_count OUT NOCOPY NUMBER,

Line 36: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

32:
33: PROCEDURE Create_ServiceRequest_Post
34: ( p_api_version IN NUMBER,
35: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
36: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
37: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
38: x_return_status OUT NOCOPY VARCHAR2,
39: x_msg_count OUT NOCOPY NUMBER,
40: x_msg_data OUT NOCOPY VARCHAR2,

Line 37: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,

33: PROCEDURE Create_ServiceRequest_Post
34: ( p_api_version IN NUMBER,
35: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
36: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
37: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
38: x_return_status OUT NOCOPY VARCHAR2,
39: x_msg_count OUT NOCOPY NUMBER,
40: x_msg_data OUT NOCOPY VARCHAR2,
41: p_resp_appl_id IN NUMBER DEFAULT NULL,

Line 64: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

60:
61:
62: PROCEDURE Update_ServiceRequest_Post
63: ( p_api_version IN NUMBER,
64: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
65: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
66: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
67: x_return_status OUT NOCOPY VARCHAR2,
68: x_msg_count OUT NOCOPY NUMBER,

Line 65: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

61:
62: PROCEDURE Update_ServiceRequest_Post
63: ( p_api_version IN NUMBER,
64: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
65: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
66: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
67: x_return_status OUT NOCOPY VARCHAR2,
68: x_msg_count OUT NOCOPY NUMBER,
69: x_msg_data OUT NOCOPY VARCHAR2,

Line 66: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,

62: PROCEDURE Update_ServiceRequest_Post
63: ( p_api_version IN NUMBER,
64: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
65: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
66: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
67: x_return_status OUT NOCOPY VARCHAR2,
68: x_msg_count OUT NOCOPY NUMBER,
69: x_msg_data OUT NOCOPY VARCHAR2,
70: p_request_id IN NUMBER,

Line 78: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,

74: p_last_updated_by IN NUMBER,
75: p_last_update_login IN NUMBER DEFAULT NULL,
76: p_last_update_date IN DATE,
77: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
78: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
79: p_notes IN CS_ServiceRequest_PVT.notes_table,
80: p_contacts IN CS_ServiceRequest_PVT.contacts_table,
81: p_audit_comments IN VARCHAR2 DEFAULT NULL,
82: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,

Line 82: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,

78: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
79: p_notes IN CS_ServiceRequest_PVT.notes_table,
80: p_contacts IN CS_ServiceRequest_PVT.contacts_table,
81: p_audit_comments IN VARCHAR2 DEFAULT NULL,
82: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
83: p_workflow_process_id IN NUMBER DEFAULT NULL,
84: x_workflow_process_id OUT NOCOPY NUMBER,
85: x_interaction_id OUT NOCOPY NUMBER
86: ) IS

Line 94: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

90:
91:
92: PROCEDURE Update_ServiceRequest_Pre
93: ( p_api_version IN NUMBER,
94: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
95: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
96: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
97: x_return_status OUT NOCOPY VARCHAR2,
98: x_msg_count OUT NOCOPY NUMBER,

Line 95: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

91:
92: PROCEDURE Update_ServiceRequest_Pre
93: ( p_api_version IN NUMBER,
94: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
95: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
96: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
97: x_return_status OUT NOCOPY VARCHAR2,
98: x_msg_count OUT NOCOPY NUMBER,
99: x_msg_data OUT NOCOPY VARCHAR2,

Line 96: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,

92: PROCEDURE Update_ServiceRequest_Pre
93: ( p_api_version IN NUMBER,
94: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
95: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
96: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
97: x_return_status OUT NOCOPY VARCHAR2,
98: x_msg_count OUT NOCOPY NUMBER,
99: x_msg_data OUT NOCOPY VARCHAR2,
100: p_request_id IN NUMBER,

Line 108: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,

104: p_last_updated_by IN NUMBER,
105: p_last_update_login IN NUMBER DEFAULT NULL,
106: p_last_update_date IN DATE,
107: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
108: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
109: p_notes IN CS_ServiceRequest_PVT.notes_table,
110: p_contacts IN CS_ServiceRequest_PVT.contacts_table,
111: p_audit_comments IN VARCHAR2 DEFAULT NULL,
112: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,

Line 112: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,

108: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
109: p_notes IN CS_ServiceRequest_PVT.notes_table,
110: p_contacts IN CS_ServiceRequest_PVT.contacts_table,
111: p_audit_comments IN VARCHAR2 DEFAULT NULL,
112: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
113: p_workflow_process_id IN NUMBER DEFAULT NULL,
114: x_workflow_process_id OUT NOCOPY NUMBER,
115: x_interaction_id OUT NOCOPY NUMBER
116: )

Line 166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

162: x_msg_data := l_msg_data;
163:
164:
165: EXCEPTION
166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
167: x_return_status := FND_API.G_RET_STS_ERROR;
168: x_msg_count := l_msg_count;
169: x_msg_data := l_msg_data;
170:

Line 167: x_return_status := FND_API.G_RET_STS_ERROR;

163:
164:
165: EXCEPTION
166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
167: x_return_status := FND_API.G_RET_STS_ERROR;
168: x_msg_count := l_msg_count;
169: x_msg_data := l_msg_data;
170:
171: FND_MSG_PUB.Count_And_Get

Line 175: WHEN FND_API.G_EXC_ERROR THEN

171: FND_MSG_PUB.Count_And_Get
172: ( p_count => x_msg_count,
173: p_data => x_msg_data
174: );
175: WHEN FND_API.G_EXC_ERROR THEN
176: x_return_status := FND_API.G_RET_STS_ERROR;
177: x_msg_count := l_msg_count;
178: x_msg_data := l_msg_data;
179:

Line 176: x_return_status := FND_API.G_RET_STS_ERROR;

172: ( p_count => x_msg_count,
173: p_data => x_msg_data
174: );
175: WHEN FND_API.G_EXC_ERROR THEN
176: x_return_status := FND_API.G_RET_STS_ERROR;
177: x_msg_count := l_msg_count;
178: x_msg_data := l_msg_data;
179:
180: FND_MSG_PUB.Count_And_Get