19: --Parameters
20: --
21: --IN
22: -- p_api_version_number IN NUMBER Required
23: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
24: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
25: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
26: -- p_reg_det_rec IN RegistrationDetails Required
27: --
20: --
21: --IN
22: -- p_api_version_number IN NUMBER Required
23: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
24: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
25: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
26: -- p_reg_det_rec IN RegistrationDetails Required
27: --
28: --OUT
21: --IN
22: -- p_api_version_number IN NUMBER Required
23: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
24: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
25: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
26: -- p_reg_det_rec IN RegistrationDetails Required
27: --
28: --OUT
29: -- x_return_status OUT VARCHAR2
36: --
37: --End of Comments
38: --==============================================================================
39: PROCEDURE Register( p_api_version_number IN NUMBER
40: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
41: , p_commit IN VARCHAR2 := FND_API.G_FALSE
42: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
43:
44: , x_return_status OUT NOCOPY VARCHAR2
37: --End of Comments
38: --==============================================================================
39: PROCEDURE Register( p_api_version_number IN NUMBER
40: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
41: , p_commit IN VARCHAR2 := FND_API.G_FALSE
42: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
43:
44: , x_return_status OUT NOCOPY VARCHAR2
45: , x_msg_count OUT NOCOPY NUMBER
38: --==============================================================================
39: PROCEDURE Register( p_api_version_number IN NUMBER
40: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
41: , p_commit IN VARCHAR2 := FND_API.G_FALSE
42: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
43:
44: , x_return_status OUT NOCOPY VARCHAR2
45: , x_msg_count OUT NOCOPY NUMBER
46: , x_msg_data OUT NOCOPY VARCHAR2
45: , x_msg_count OUT NOCOPY NUMBER
46: , x_msg_data OUT NOCOPY VARCHAR2
47:
48: , p_reg_det_rec IN RegistrationDetails
49: , p_block_fulfillment IN VARCHAR2 := FND_API.G_TRUE
50: , p_owner_user_id IN NUMBER
51: , p_application_id IN NUMBER
52:
53: , x_confirm_code OUT NOCOPY VARCHAR2
75: SAVEPOINT Register_Dialog_Regs_PUB;
76: AMS_Utility_PVT.debug_message(l_full_name || ': start');
77:
78: -- Standard call to check for call compatibility.
79: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
80: p_api_version_number,
81: l_api_name,
82: G_PKG_NAME)
83: THEN
80: p_api_version_number,
81: l_api_name,
82: G_PKG_NAME)
83: THEN
84: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
85: END IF;
86:
87: l_return_status := FND_API.g_ret_sts_success;
88:
83: THEN
84: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
85: END IF;
86:
87: l_return_status := FND_API.g_ret_sts_success;
88:
89: -- Initialize message list if p_init_msg_list is set to TRUE.
90: IF FND_API.to_Boolean( p_init_msg_list )
91: THEN
86:
87: l_return_status := FND_API.g_ret_sts_success;
88:
89: -- Initialize message list if p_init_msg_list is set to TRUE.
90: IF FND_API.to_Boolean( p_init_msg_list )
91: THEN
92: FND_MSG_PUB.initialize;
93: END IF;
94:
96: , x_reg_det_rec => l_reg_det_rec
97: );
98:
99: AMS_Registrants_Pub.Register( p_api_version_number => 1.0
100: , p_init_msg_list => FND_API.G_FALSE
101: , p_commit => FND_API.G_FALSE
102: , p_validation_level => p_validation_level
103:
104: , x_return_status => l_return_status
97: );
98:
99: AMS_Registrants_Pub.Register( p_api_version_number => 1.0
100: , p_init_msg_list => FND_API.G_FALSE
101: , p_commit => FND_API.G_FALSE
102: , p_validation_level => p_validation_level
103:
104: , x_return_status => l_return_status
105: , x_msg_count => x_msg_count
112:
113: , x_confirm_code => x_confirm_code
114: );
115:
116: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
117: THEN
118: RAISE FND_API.g_exc_unexpected_error;
119: ELSIF (l_return_status = FND_API.g_ret_sts_error)
120: THEN
114: );
115:
116: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
117: THEN
118: RAISE FND_API.g_exc_unexpected_error;
119: ELSIF (l_return_status = FND_API.g_ret_sts_error)
120: THEN
121: RAISE FND_API.g_exc_error;
122: END IF; -- l_return_status
115:
116: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
117: THEN
118: RAISE FND_API.g_exc_unexpected_error;
119: ELSIF (l_return_status = FND_API.g_ret_sts_error)
120: THEN
121: RAISE FND_API.g_exc_error;
122: END IF; -- l_return_status
123:
117: THEN
118: RAISE FND_API.g_exc_unexpected_error;
119: ELSIF (l_return_status = FND_API.g_ret_sts_error)
120: THEN
121: RAISE FND_API.g_exc_error;
122: END IF; -- l_return_status
123:
124: open c_get_extra_details(x_confirm_code);
125: fetch c_get_extra_details
126: into x_party_id,
127: x_system_status_code;
128: close c_get_extra_details;
129:
130: IF FND_API.to_boolean(p_commit)
131: THEN
132: COMMIT;
133: END IF; -- p_commit
134:
131: THEN
132: COMMIT;
133: END IF; -- p_commit
134:
135: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
136: , p_count => x_msg_count
137: , p_data => x_msg_data
138: );
139:
142: AMS_Utility_PVT.debug_message(l_full_name || ': end');
143:
144: EXCEPTION
145:
146: WHEN FND_API.g_exc_error
147: THEN
148: ROLLBACK TO Register_Registrants_PUB;
149: x_return_status := FND_API.g_ret_sts_error;
150: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
145:
146: WHEN FND_API.g_exc_error
147: THEN
148: ROLLBACK TO Register_Registrants_PUB;
149: x_return_status := FND_API.g_ret_sts_error;
150: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
151: , p_count => x_msg_count
152: , p_data => x_msg_data
153: );
146: WHEN FND_API.g_exc_error
147: THEN
148: ROLLBACK TO Register_Registrants_PUB;
149: x_return_status := FND_API.g_ret_sts_error;
150: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
151: , p_count => x_msg_count
152: , p_data => x_msg_data
153: );
154:
156: fnd_message.set_encoded(fnd_msg_pub.get(x_msg_count));
157: x_msg_data := fnd_message.get;
158:
159:
160: WHEN FND_API.g_exc_unexpected_error
161: THEN
162: ROLLBACK TO Register_Registrants_PUB;
163: x_return_status := FND_API.g_ret_sts_unexp_error ;
164: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
159:
160: WHEN FND_API.g_exc_unexpected_error
161: THEN
162: ROLLBACK TO Register_Registrants_PUB;
163: x_return_status := FND_API.g_ret_sts_unexp_error ;
164: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
165: , p_count => x_msg_count
166: , p_data => x_msg_data
167: );
160: WHEN FND_API.g_exc_unexpected_error
161: THEN
162: ROLLBACK TO Register_Registrants_PUB;
163: x_return_status := FND_API.g_ret_sts_unexp_error ;
164: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
165: , p_count => x_msg_count
166: , p_data => x_msg_data
167: );
168:
168:
169: WHEN OTHERS
170: THEN
171: ROLLBACK TO Register_Registrants_PUB;
172: x_return_status := FND_API.g_ret_sts_unexp_error ;
173: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
174: THEN
175: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
176: END IF; -- check_msg_level
173: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
174: THEN
175: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
176: END IF; -- check_msg_level
177: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
178: , p_count => x_msg_count
179: , p_data => x_msg_data
180: );
181:
193: --Parameters
194: --
195: --IN
196: -- p_api_version_number IN NUMBER Required
197: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
198: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
199: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
200: -- p_confirm_code IN RegistrationDetails Required
201: --
194: --
195: --IN
196: -- p_api_version_number IN NUMBER Required
197: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
198: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
199: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
200: -- p_confirm_code IN RegistrationDetails Required
201: --
202: --OUT
195: --IN
196: -- p_api_version_number IN NUMBER Required
197: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
198: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
199: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
200: -- p_confirm_code IN RegistrationDetails Required
201: --
202: --OUT
203: -- x_return_status OUT VARCHAR2
208: --
209: --End of Comments
210: --==============================================================================
211: Procedure IsRegistered( p_api_version_number IN NUMBER
212: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
213: , p_commit IN VARCHAR2 := FND_API.G_FALSE
214: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
215:
216: , x_return_status OUT NOCOPY VARCHAR2
209: --End of Comments
210: --==============================================================================
211: Procedure IsRegistered( p_api_version_number IN NUMBER
212: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
213: , p_commit IN VARCHAR2 := FND_API.G_FALSE
214: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
215:
216: , x_return_status OUT NOCOPY VARCHAR2
217: , x_msg_count OUT NOCOPY NUMBER
210: --==============================================================================
211: Procedure IsRegistered( p_api_version_number IN NUMBER
212: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
213: , p_commit IN VARCHAR2 := FND_API.G_FALSE
214: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
215:
216: , x_return_status OUT NOCOPY VARCHAR2
217: , x_msg_count OUT NOCOPY NUMBER
218: , x_msg_data OUT NOCOPY VARCHAR2
239: SAVEPOINT IsRegistered_Dialog_Regs_PUB;
240: AMS_Utility_PVT.debug_message(l_full_name || ': start');
241:
242: -- Standard call to check for call compatibility.
243: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
244: p_api_version_number,
245: l_api_name,
246: G_PKG_NAME)
247: THEN
244: p_api_version_number,
245: l_api_name,
246: G_PKG_NAME)
247: THEN
248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
249: END IF;
250:
251: l_return_status := FND_API.g_ret_sts_success;
252:
247: THEN
248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
249: END IF;
250:
251: l_return_status := FND_API.g_ret_sts_success;
252:
253: -- Initialize message list if p_init_msg_list is set to TRUE.
254: IF FND_API.to_Boolean( p_init_msg_list )
255: THEN
250:
251: l_return_status := FND_API.g_ret_sts_success;
252:
253: -- Initialize message list if p_init_msg_list is set to TRUE.
254: IF FND_API.to_Boolean( p_init_msg_list )
255: THEN
256: FND_MSG_PUB.initialize;
257: END IF;
258:
267: else
268: x_is_registered := 'N';
269: end if;
270:
271: IF FND_API.to_boolean(p_commit)
272: THEN
273: COMMIT;
274: END IF; -- p_commit
275:
272: THEN
273: COMMIT;
274: END IF; -- p_commit
275:
276: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
277: , p_count => x_msg_count
278: , p_data => x_msg_data
279: );
280: