eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_PARTNER_ACCNT_MGMT_PVT dependencies on FND_API

Line 13: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

9: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
10:
11: PROCEDURE Create_Customer_Account(
12: p_api_version IN NUMBER
13: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
14: ,p_commit IN VARCHAR2 := FND_API.g_false
15: ,P_partner_party_id IN NUMBER
16: ,x_return_status OUT NOCOPY VARCHAR2
17: ,x_msg_count OUT NOCOPY NUMBER

Line 14: ,p_commit IN VARCHAR2 := FND_API.g_false

10:
11: PROCEDURE Create_Customer_Account(
12: p_api_version IN NUMBER
13: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
14: ,p_commit IN VARCHAR2 := FND_API.g_false
15: ,P_partner_party_id IN NUMBER
16: ,x_return_status OUT NOCOPY VARCHAR2
17: ,x_msg_count OUT NOCOPY NUMBER
18: ,x_msg_data OUT NOCOPY VARCHAR2

Line 51: x_return_status := FND_API.g_ret_sts_success;

47: ---- Initialize---------------------
48:
49: SAVEPOINT CREATE_CUSTOMER_ACCOUNT;
50:
51: x_return_status := FND_API.g_ret_sts_success;
52:
53: IF FND_API.to_boolean(p_init_msg_list) THEN
54: FND_MSG_PUB.initialize;
55: END IF;

Line 53: IF FND_API.to_boolean(p_init_msg_list) THEN

49: SAVEPOINT CREATE_CUSTOMER_ACCOUNT;
50:
51: x_return_status := FND_API.g_ret_sts_success;
52:
53: IF FND_API.to_boolean(p_init_msg_list) THEN
54: FND_MSG_PUB.initialize;
55: END IF;
56:
57: IF NOT FND_API.compatible_api_call(

Line 57: IF NOT FND_API.compatible_api_call(

53: IF FND_API.to_boolean(p_init_msg_list) THEN
54: FND_MSG_PUB.initialize;
55: END IF;
56:
57: IF NOT FND_API.compatible_api_call(
58: l_api_version,
59: p_api_version,
60: l_api_name,
61: g_pkg_name

Line 63: RAISE FND_API.g_exc_unexpected_error;

59: p_api_version,
60: l_api_name,
61: g_pkg_name
62: ) THEN
63: RAISE FND_API.g_exc_unexpected_error;
64: END IF;
65:
66: -- figure out if the party type and party_name. party_type has to be an organization
67: OPEN C_party_info(p_partner_party_id);

Line 73: raise FND_API.G_EXC_ERROR;

69: IF (C_party_info%NOTFOUND) THEN
70: FND_MESSAGE.Set_Name('PV', 'PV_INVALID_PARTNER_PARTY_ID');
71: FND_MESSAGE.Set_Token('COLUMN', 'PARTY ID', FALSE);
72: FND_MSG_PUB.ADD;
73: raise FND_API.G_EXC_ERROR;
74: END IF;
75: CLOSE C_party_info;
76:
77:

Line 98: p_init_msg_list => FND_API.G_FALSE,

94: organization_rec.party_rec := p_party_rec;
95: organization_rec.party_rec.party_id := p_partner_party_id;
96:
97: HZ_CUST_ACCOUNT_V2PUB.create_cust_account (
98: p_init_msg_list => FND_API.G_FALSE,
99: p_cust_account_rec => account_rec,
100: p_organization_rec => organization_rec,
101: p_customer_profile_rec => cust_profile_rec,
102: p_create_profile_amt => 'Y',

Line 120: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

116:
117: END IF;
118:
119:
120: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
122: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
123: RAISE FND_API.G_EXC_ERROR;
124: END IF;

Line 121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

117: END IF;
118:
119:
120: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
122: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
123: RAISE FND_API.G_EXC_ERROR;
124: END IF;
125:

Line 122: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

118:
119:
120: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
122: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
123: RAISE FND_API.G_EXC_ERROR;
124: END IF;
125:
126:

Line 123: RAISE FND_API.G_EXC_ERROR;

119:
120: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
122: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
123: RAISE FND_API.G_EXC_ERROR;
124: END IF;
125:
126:
127: FND_MSG_PUB.Count_And_Get

Line 128: ( p_encoded => FND_API.G_FALSE,

124: END IF;
125:
126:
127: FND_MSG_PUB.Count_And_Get
128: ( p_encoded => FND_API.G_FALSE,
129: p_count => x_msg_count,
130: p_data => x_msg_data
131: );
132:

Line 133: IF FND_API.to_Boolean( p_commit ) THEN

129: p_count => x_msg_count,
130: p_data => x_msg_data
131: );
132:
133: IF FND_API.to_Boolean( p_commit ) THEN
134: COMMIT WORK;
135: END IF;
136:
137:

Line 139: WHEN FND_API.G_EXC_ERROR THEN

135: END IF;
136:
137:
138: EXCEPTION
139: WHEN FND_API.G_EXC_ERROR THEN
140: ROLLBACK TO CREATE_CUSTOMER_ACCOUNT;
141: x_return_status := FND_API.G_RET_STS_ERROR;
142: -- Standard call to get message count and if count=1, get the message
143: FND_MSG_PUB.Count_And_Get (

Line 141: x_return_status := FND_API.G_RET_STS_ERROR;

137:
138: EXCEPTION
139: WHEN FND_API.G_EXC_ERROR THEN
140: ROLLBACK TO CREATE_CUSTOMER_ACCOUNT;
141: x_return_status := FND_API.G_RET_STS_ERROR;
142: -- Standard call to get message count and if count=1, get the message
143: FND_MSG_PUB.Count_And_Get (
144: p_encoded => FND_API.G_FALSE
145: ,p_count => x_msg_count

Line 144: p_encoded => FND_API.G_FALSE

140: ROLLBACK TO CREATE_CUSTOMER_ACCOUNT;
141: x_return_status := FND_API.G_RET_STS_ERROR;
142: -- Standard call to get message count and if count=1, get the message
143: FND_MSG_PUB.Count_And_Get (
144: p_encoded => FND_API.G_FALSE
145: ,p_count => x_msg_count
146: ,p_data => x_msg_data
147: );
148:

Line 149: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

145: ,p_count => x_msg_count
146: ,p_data => x_msg_data
147: );
148:
149: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
150: ROLLBACK TO CREATE_CUSTOMER_ACCOUNT;
151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
152: -- Standard call to get message count and if count=1, get the message
153: FND_MSG_PUB.Count_And_Get (

Line 151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

147: );
148:
149: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
150: ROLLBACK TO CREATE_CUSTOMER_ACCOUNT;
151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
152: -- Standard call to get message count and if count=1, get the message
153: FND_MSG_PUB.Count_And_Get (
154: p_encoded => FND_API.G_FALSE
155: ,p_count => x_msg_count

Line 154: p_encoded => FND_API.G_FALSE

150: ROLLBACK TO CREATE_CUSTOMER_ACCOUNT;
151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
152: -- Standard call to get message count and if count=1, get the message
153: FND_MSG_PUB.Count_And_Get (
154: p_encoded => FND_API.G_FALSE
155: ,p_count => x_msg_count
156: ,p_data => x_msg_data
157: );
158:

Line 161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

157: );
158:
159: WHEN OTHERS THEN
160: ROLLBACK TO CREATE_CUSTOMER_ACCOUNT;
161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
162: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
163: THEN
164: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
165: END IF;

Line 168: p_encoded => FND_API.G_FALSE

164: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
165: END IF;
166: -- Standard call to get message count and if count=1, get the message
167: FND_MSG_PUB.Count_And_Get (
168: p_encoded => FND_API.G_FALSE
169: ,p_count => x_msg_count
170: ,p_data => x_msg_data
171: );
172:

Line 178: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

174:
175:
176: PROCEDURE Create_ACCT_SITE (
177: p_api_version IN NUMBER
178: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
179: ,p_commit IN VARCHAR2 := FND_API.g_false
180: ,p_Cust_Account_Id NUMBER
181: ,p_Party_Site_Id NUMBER
182: ,x_return_status OUT NOCOPY VARCHAR2

Line 179: ,p_commit IN VARCHAR2 := FND_API.g_false

175:
176: PROCEDURE Create_ACCT_SITE (
177: p_api_version IN NUMBER
178: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
179: ,p_commit IN VARCHAR2 := FND_API.g_false
180: ,p_Cust_Account_Id NUMBER
181: ,p_Party_Site_Id NUMBER
182: ,x_return_status OUT NOCOPY VARCHAR2
183: ,x_msg_count OUT NOCOPY NUMBER

Line 205: x_return_status := FND_API.g_ret_sts_success;

201: BEGIN
202: ---- Initialize---------------------
203: SAVEPOINT CREATE_ACCT_SITE;
204:
205: x_return_status := FND_API.g_ret_sts_success;
206:
207:
208: IF FND_API.to_boolean(p_init_msg_list) THEN
209: FND_MSG_PUB.initialize;

Line 208: IF FND_API.to_boolean(p_init_msg_list) THEN

204:
205: x_return_status := FND_API.g_ret_sts_success;
206:
207:
208: IF FND_API.to_boolean(p_init_msg_list) THEN
209: FND_MSG_PUB.initialize;
210: END IF;
211:
212: IF NOT FND_API.compatible_api_call(

Line 212: IF NOT FND_API.compatible_api_call(

208: IF FND_API.to_boolean(p_init_msg_list) THEN
209: FND_MSG_PUB.initialize;
210: END IF;
211:
212: IF NOT FND_API.compatible_api_call(
213: l_api_version,
214: p_api_version,
215: l_api_name,
216: g_pkg_name

Line 218: RAISE FND_API.g_exc_unexpected_error;

214: p_api_version,
215: l_api_name,
216: g_pkg_name
217: ) THEN
218: RAISE FND_API.g_exc_unexpected_error;
219: END IF;
220:
221:
222: Open C_acct_site (p_cust_account_id, p_party_site_id);

Line 233: p_init_msg_list => FND_API.G_FALSE,

229: p_acct_site_Rec.org_id := mo_global.get_current_org_id;
230:
231:
232: HZ_CUST_ACCOUNT_SITE_V2PUB.create_cust_acct_site (
233: p_init_msg_list => FND_API.G_FALSE,
234: p_cust_acct_site_rec => p_acct_site_rec,
235: x_cust_acct_site_id => x_customer_site_id,
236: x_return_status => x_return_status,
237: x_msg_count => x_msg_count,

Line 244: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

240: IF (PV_DEBUG_HIGH_ON) THEN
241: PVX_UTILITY_PVT.debug_message('create acct_site: x_return_status '||x_return_status);
242: END IF;
243:
244: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
246: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
247: RAISE FND_API.G_EXC_ERROR;
248: END IF;

Line 245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

241: PVX_UTILITY_PVT.debug_message('create acct_site: x_return_status '||x_return_status);
242: END IF;
243:
244: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
246: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
247: RAISE FND_API.G_EXC_ERROR;
248: END IF;
249: END IF;

Line 246: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

242: END IF;
243:
244: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
246: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
247: RAISE FND_API.G_EXC_ERROR;
248: END IF;
249: END IF;
250:

Line 247: RAISE FND_API.G_EXC_ERROR;

243:
244: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
246: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
247: RAISE FND_API.G_EXC_ERROR;
248: END IF;
249: END IF;
250:
251: Close C_acct_site;

Line 255: ( p_encoded => FND_API.G_FALSE,

251: Close C_acct_site;
252: PVX_UTILITY_PVT.debug_message('create acct_site:after create_site:x_customer_site_id '||x_customer_site_id);
253:
254: FND_MSG_PUB.Count_And_Get
255: ( p_encoded => FND_API.G_FALSE,
256: p_count => x_msg_count,
257: p_data => x_msg_data
258: );
259:

Line 260: IF FND_API.to_Boolean( p_commit ) THEN

256: p_count => x_msg_count,
257: p_data => x_msg_data
258: );
259:
260: IF FND_API.to_Boolean( p_commit ) THEN
261: COMMIT WORK;
262: END IF;
263:
264:

Line 266: WHEN FND_API.G_EXC_ERROR THEN

262: END IF;
263:
264:
265: EXCEPTION
266: WHEN FND_API.G_EXC_ERROR THEN
267: ROLLBACK TO CREATE_ACCT_SITE;
268: x_return_status := FND_API.G_RET_STS_ERROR;
269: -- Standard call to get message count and if count=1, get the message
270: FND_MSG_PUB.Count_And_Get (

Line 268: x_return_status := FND_API.G_RET_STS_ERROR;

264:
265: EXCEPTION
266: WHEN FND_API.G_EXC_ERROR THEN
267: ROLLBACK TO CREATE_ACCT_SITE;
268: x_return_status := FND_API.G_RET_STS_ERROR;
269: -- Standard call to get message count and if count=1, get the message
270: FND_MSG_PUB.Count_And_Get (
271: p_encoded => FND_API.G_FALSE
272: ,p_count => x_msg_count

Line 271: p_encoded => FND_API.G_FALSE

267: ROLLBACK TO CREATE_ACCT_SITE;
268: x_return_status := FND_API.G_RET_STS_ERROR;
269: -- Standard call to get message count and if count=1, get the message
270: FND_MSG_PUB.Count_And_Get (
271: p_encoded => FND_API.G_FALSE
272: ,p_count => x_msg_count
273: ,p_data => x_msg_data
274: );
275:

Line 276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

272: ,p_count => x_msg_count
273: ,p_data => x_msg_data
274: );
275:
276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
277: ROLLBACK TO CREATE_ACCT_SITE;
278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
279: -- Standard call to get message count and if count=1, get the message
280: FND_MSG_PUB.Count_And_Get (

Line 278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

274: );
275:
276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
277: ROLLBACK TO CREATE_ACCT_SITE;
278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
279: -- Standard call to get message count and if count=1, get the message
280: FND_MSG_PUB.Count_And_Get (
281: p_encoded => FND_API.G_FALSE
282: ,p_count => x_msg_count

Line 281: p_encoded => FND_API.G_FALSE

277: ROLLBACK TO CREATE_ACCT_SITE;
278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
279: -- Standard call to get message count and if count=1, get the message
280: FND_MSG_PUB.Count_And_Get (
281: p_encoded => FND_API.G_FALSE
282: ,p_count => x_msg_count
283: ,p_data => x_msg_data
284: );
285:

Line 288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

284: );
285:
286: WHEN OTHERS THEN
287: ROLLBACK TO CREATE_ACCT_SITE;
288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
289: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
290: THEN
291: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
292: END IF;

Line 295: p_encoded => FND_API.G_FALSE

291: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
292: END IF;
293: -- Standard call to get message count and if count=1, get the message
294: FND_MSG_PUB.Count_And_Get (
295: p_encoded => FND_API.G_FALSE
296: ,p_count => x_msg_count
297: ,p_data => x_msg_data
298: );
299:

Line 306: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

302:
303:
304: PROCEDURE Create_Party_Site_Use(
305: p_api_version IN NUMBER,
306: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
307: p_commit IN VARCHAR2 := FND_API.g_false,
308: p_party_site_id IN NUMBER,
309: p_party_site_use_type IN VARCHAR2,
310: x_party_site_use_id OUT NOCOPY NUMBER,

Line 307: p_commit IN VARCHAR2 := FND_API.g_false,

303:
304: PROCEDURE Create_Party_Site_Use(
305: p_api_version IN NUMBER,
306: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
307: p_commit IN VARCHAR2 := FND_API.g_false,
308: p_party_site_id IN NUMBER,
309: p_party_site_use_type IN VARCHAR2,
310: x_party_site_use_id OUT NOCOPY NUMBER,
311: x_return_status OUT NOCOPY VARCHAR2,

Line 324: x_return_status := FND_API.G_RET_STS_SUCCESS;

320: BEGIN
321: SAVEPOINT CREATE_PARTY_SITE_USE;
322:
323: -- Initialize API return status to SUCCESS
324: x_return_status := FND_API.G_RET_STS_SUCCESS;
325:
326: IF FND_API.to_boolean(p_init_msg_list) THEN
327: FND_MSG_PUB.initialize;
328: END IF;

Line 326: IF FND_API.to_boolean(p_init_msg_list) THEN

322:
323: -- Initialize API return status to SUCCESS
324: x_return_status := FND_API.G_RET_STS_SUCCESS;
325:
326: IF FND_API.to_boolean(p_init_msg_list) THEN
327: FND_MSG_PUB.initialize;
328: END IF;
329:
330: IF NOT FND_API.compatible_api_call(

Line 330: IF NOT FND_API.compatible_api_call(

326: IF FND_API.to_boolean(p_init_msg_list) THEN
327: FND_MSG_PUB.initialize;
328: END IF;
329:
330: IF NOT FND_API.compatible_api_call(
331: l_api_version,
332: p_api_version,
333: l_api_name,
334: g_pkg_name

Line 336: RAISE FND_API.g_exc_unexpected_error;

332: p_api_version,
333: l_api_name,
334: g_pkg_name
335: ) THEN
336: RAISE FND_API.g_exc_unexpected_error;
337: END IF;
338:
339:
340: IF (PV_DEBUG_HIGH_ON) THEN

Line 351: p_init_msg_list => FND_API.G_FALSE,

347: l_party_site_use_rec.site_use_type := p_party_site_use_type;
348: l_party_site_use_rec.Created_by_Module := 'PV';
349:
350: HZ_PARTY_SITE_V2PUB.create_party_site_use (
351: p_init_msg_list => FND_API.G_FALSE,
352: p_party_site_use_rec => l_party_site_use_rec,
353: x_party_site_use_id => x_party_site_use_id,
354: x_return_status => x_return_status,
355: x_msg_count => x_msg_count,

Line 366: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

362: PVX_UTILITY_PVT.debug_message('create_pty_site_use: x_party_site_use_id ' || x_party_site_use_id);
363: PVX_UTILITY_PVT.debug_message('create_pty_site_use: x_return_status ' || x_return_status);
364: END IF;
365:
366: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
368: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
369: RAISE FND_API.G_EXC_ERROR;
370: END IF;

Line 367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

363: PVX_UTILITY_PVT.debug_message('create_pty_site_use: x_return_status ' || x_return_status);
364: END IF;
365:
366: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
368: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
369: RAISE FND_API.G_EXC_ERROR;
370: END IF;
371:

Line 368: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

364: END IF;
365:
366: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
368: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
369: RAISE FND_API.G_EXC_ERROR;
370: END IF;
371:
372: FND_MSG_PUB.Count_And_Get

Line 369: RAISE FND_API.G_EXC_ERROR;

365:
366: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
368: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
369: RAISE FND_API.G_EXC_ERROR;
370: END IF;
371:
372: FND_MSG_PUB.Count_And_Get
373: ( p_encoded => FND_API.G_FALSE,

Line 373: ( p_encoded => FND_API.G_FALSE,

369: RAISE FND_API.G_EXC_ERROR;
370: END IF;
371:
372: FND_MSG_PUB.Count_And_Get
373: ( p_encoded => FND_API.G_FALSE,
374: p_count => x_msg_count,
375: p_data => x_msg_data
376: );
377:

Line 379: IF FND_API.to_Boolean( p_commit ) THEN

375: p_data => x_msg_data
376: );
377:
378:
379: IF FND_API.to_Boolean( p_commit ) THEN
380: COMMIT WORK;
381: END IF;
382:
383:

Line 385: WHEN FND_API.G_EXC_ERROR THEN

381: END IF;
382:
383:
384: EXCEPTION
385: WHEN FND_API.G_EXC_ERROR THEN
386: ROLLBACK TO CREATE_PARTY_SITE_USE;
387: x_return_status := FND_API.G_RET_STS_ERROR;
388: -- Standard call to get message count and if count=1, get the message
389: FND_MSG_PUB.Count_And_Get (

Line 387: x_return_status := FND_API.G_RET_STS_ERROR;

383:
384: EXCEPTION
385: WHEN FND_API.G_EXC_ERROR THEN
386: ROLLBACK TO CREATE_PARTY_SITE_USE;
387: x_return_status := FND_API.G_RET_STS_ERROR;
388: -- Standard call to get message count and if count=1, get the message
389: FND_MSG_PUB.Count_And_Get (
390: p_encoded => FND_API.G_FALSE
391: ,p_count => x_msg_count

Line 390: p_encoded => FND_API.G_FALSE

386: ROLLBACK TO CREATE_PARTY_SITE_USE;
387: x_return_status := FND_API.G_RET_STS_ERROR;
388: -- Standard call to get message count and if count=1, get the message
389: FND_MSG_PUB.Count_And_Get (
390: p_encoded => FND_API.G_FALSE
391: ,p_count => x_msg_count
392: ,p_data => x_msg_data
393: );
394:

Line 395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

391: ,p_count => x_msg_count
392: ,p_data => x_msg_data
393: );
394:
395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
396: ROLLBACK TO CREATE_PARTY_SITE_USE;
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
398: -- Standard call to get message count and if count=1, get the message
399: FND_MSG_PUB.Count_And_Get (

Line 397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

393: );
394:
395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
396: ROLLBACK TO CREATE_PARTY_SITE_USE;
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
398: -- Standard call to get message count and if count=1, get the message
399: FND_MSG_PUB.Count_And_Get (
400: p_encoded => FND_API.G_FALSE
401: ,p_count => x_msg_count

Line 400: p_encoded => FND_API.G_FALSE

396: ROLLBACK TO CREATE_PARTY_SITE_USE;
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
398: -- Standard call to get message count and if count=1, get the message
399: FND_MSG_PUB.Count_And_Get (
400: p_encoded => FND_API.G_FALSE
401: ,p_count => x_msg_count
402: ,p_data => x_msg_data
403: );
404:

Line 407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

403: );
404:
405: WHEN OTHERS THEN
406: ROLLBACK TO CREATE_PARTY_SITE_USE;
407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
408: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
409: THEN
410: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
411: END IF;

Line 414: p_encoded => FND_API.G_FALSE

410: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
411: END IF;
412: -- Standard call to get message count and if count=1, get the message
413: FND_MSG_PUB.Count_And_Get (
414: p_encoded => FND_API.G_FALSE
415: ,p_count => x_msg_count
416: ,p_data => x_msg_data
417: );
418:

Line 428: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

424: * on passing this value around
425: */
426: PROCEDURE Create_ACCT_SITE_USES (
427: p_api_version IN NUMBER
428: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
429: ,p_commit IN VARCHAR2 := FND_API.g_false
430: ,P_Cust_Account_Id IN NUMBER
431: ,P_Party_Site_Id IN NUMBER
432: ,P_Acct_Site_type IN VARCHAR2

Line 429: ,p_commit IN VARCHAR2 := FND_API.g_false

425: */
426: PROCEDURE Create_ACCT_SITE_USES (
427: p_api_version IN NUMBER
428: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
429: ,p_commit IN VARCHAR2 := FND_API.g_false
430: ,P_Cust_Account_Id IN NUMBER
431: ,P_Party_Site_Id IN NUMBER
432: ,P_Acct_Site_type IN VARCHAR2
433: ,x_return_status OUT NOCOPY VARCHAR2

Line 477: x_return_status := FND_API.g_ret_sts_success;

473: ---- Initialize---------------------
474:
475: SAVEPOINT CREATE_ACCT_SITE_USES;
476:
477: x_return_status := FND_API.g_ret_sts_success;
478:
479: IF FND_API.to_boolean(p_init_msg_list) THEN
480: FND_MSG_PUB.initialize;
481: END IF;

Line 479: IF FND_API.to_boolean(p_init_msg_list) THEN

475: SAVEPOINT CREATE_ACCT_SITE_USES;
476:
477: x_return_status := FND_API.g_ret_sts_success;
478:
479: IF FND_API.to_boolean(p_init_msg_list) THEN
480: FND_MSG_PUB.initialize;
481: END IF;
482:
483: IF NOT FND_API.compatible_api_call(

Line 483: IF NOT FND_API.compatible_api_call(

479: IF FND_API.to_boolean(p_init_msg_list) THEN
480: FND_MSG_PUB.initialize;
481: END IF;
482:
483: IF NOT FND_API.compatible_api_call(
484: l_api_version,
485: p_api_version,
486: l_api_name,
487: g_pkg_name

Line 489: RAISE FND_API.g_exc_unexpected_error;

485: p_api_version,
486: l_api_name,
487: g_pkg_name
488: ) THEN
489: RAISE FND_API.g_exc_unexpected_error;
490: END IF;
491:
492:
493: -- Intializing created_by_module as required in version 2 api for the record structure

Line 520: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

516:
517:
518: END IF;
519:
520: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
522: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
523: RAISE FND_API.G_EXC_ERROR;
524: END IF;

Line 521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

517:
518: END IF;
519:
520: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
522: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
523: RAISE FND_API.G_EXC_ERROR;
524: END IF;
525:

Line 522: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

518: END IF;
519:
520: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
522: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
523: RAISE FND_API.G_EXC_ERROR;
524: END IF;
525:
526:

Line 523: RAISE FND_API.G_EXC_ERROR;

519:
520: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
522: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
523: RAISE FND_API.G_EXC_ERROR;
524: END IF;
525:
526:
527: Open C_site_use(x_cust_acct_site_id, p_acct_site_type);

Line 559: p_init_msg_list => FND_API.G_FALSE,

555: p_acct_site_uses_Rec.created_by_module := 'PV';
556: p_cust_profile_rec.created_by_module := 'PV';
557:
558: HZ_CUST_ACCOUNT_SITE_V2PUB.create_cust_site_use (
559: p_init_msg_list => FND_API.G_FALSE,
560: p_cust_site_use_rec => p_acct_site_uses_rec,
561: p_customer_profile_rec => p_cust_profile_rec,
562: p_create_profile => FND_API.G_TRUE,
563: p_create_profile_amt => FND_API.G_TRUE,

Line 562: p_create_profile => FND_API.G_TRUE,

558: HZ_CUST_ACCOUNT_SITE_V2PUB.create_cust_site_use (
559: p_init_msg_list => FND_API.G_FALSE,
560: p_cust_site_use_rec => p_acct_site_uses_rec,
561: p_customer_profile_rec => p_cust_profile_rec,
562: p_create_profile => FND_API.G_TRUE,
563: p_create_profile_amt => FND_API.G_TRUE,
564: x_site_use_id => x_site_use_id,
565: x_return_status => x_return_status,
566: x_msg_count => x_msg_count,

Line 563: p_create_profile_amt => FND_API.G_TRUE,

559: p_init_msg_list => FND_API.G_FALSE,
560: p_cust_site_use_rec => p_acct_site_uses_rec,
561: p_customer_profile_rec => p_cust_profile_rec,
562: p_create_profile => FND_API.G_TRUE,
563: p_create_profile_amt => FND_API.G_TRUE,
564: x_site_use_id => x_site_use_id,
565: x_return_status => x_return_status,
566: x_msg_count => x_msg_count,
567: x_msg_data => x_msg_data );

Line 576: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

572:
573: PVX_UTILITY_PVT.debug_message('create acct_site_use:create_acct_site_use:x_site_use_id '||x_site_use_id);
574: END IF;
575:
576: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
578: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
579: RAISE FND_API.G_EXC_ERROR;
580: END IF;

Line 577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

573: PVX_UTILITY_PVT.debug_message('create acct_site_use:create_acct_site_use:x_site_use_id '||x_site_use_id);
574: END IF;
575:
576: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
578: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
579: RAISE FND_API.G_EXC_ERROR;
580: END IF;
581:

Line 578: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

574: END IF;
575:
576: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
578: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
579: RAISE FND_API.G_EXC_ERROR;
580: END IF;
581:
582: END IF; -- x_site_use not null

Line 579: RAISE FND_API.G_EXC_ERROR;

575:
576: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
578: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
579: RAISE FND_API.G_EXC_ERROR;
580: END IF;
581:
582: END IF; -- x_site_use not null
583:

Line 593: IF (p_party_site_id IS NOT NULL AND p_party_site_id <> FND_API.G_MISS_NUM) AND

589: END IF;
590:
591:
592:
593: IF (p_party_site_id IS NOT NULL AND p_party_site_id <> FND_API.G_MISS_NUM) AND
594: (p_acct_site_type IS NOT NULL AND p_acct_site_type <> FND_API.G_MISS_CHAR) THEN
595:
596: OPEN party_site_use(p_party_site_id,p_acct_site_type);
597: FETCH party_site_use into l_party_site_use_id;

Line 594: (p_acct_site_type IS NOT NULL AND p_acct_site_type <> FND_API.G_MISS_CHAR) THEN

590:
591:
592:
593: IF (p_party_site_id IS NOT NULL AND p_party_site_id <> FND_API.G_MISS_NUM) AND
594: (p_acct_site_type IS NOT NULL AND p_acct_site_type <> FND_API.G_MISS_CHAR) THEN
595:
596: OPEN party_site_use(p_party_site_id,p_acct_site_type);
597: FETCH party_site_use into l_party_site_use_id;
598: CLOSE party_site_use;

Line 620: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

616: PVX_UTILITY_PVT.debug_message('create acct_site_use: create_party_site_use: x_return_status '|| x_return_status);
617: END IF;
618: END IF;
619:
620: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
622: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
623: RAISE FND_API.G_EXC_ERROR;
624: END IF;

Line 621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

617: END IF;
618: END IF;
619:
620: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
622: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
623: RAISE FND_API.G_EXC_ERROR;
624: END IF;
625:

Line 622: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

618: END IF;
619:
620: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
622: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
623: RAISE FND_API.G_EXC_ERROR;
624: END IF;
625:
626: END IF;---End of Party Site conditions

Line 623: RAISE FND_API.G_EXC_ERROR;

619:
620: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
622: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
623: RAISE FND_API.G_EXC_ERROR;
624: END IF;
625:
626: END IF;---End of Party Site conditions
627:

Line 631: ( p_encoded => FND_API.G_FALSE,

627:
628:
629:
630: FND_MSG_PUB.Count_And_Get
631: ( p_encoded => FND_API.G_FALSE,
632: p_count => x_msg_count,
633: p_data => x_msg_data
634: );
635:

Line 636: IF FND_API.to_Boolean( p_commit ) THEN

632: p_count => x_msg_count,
633: p_data => x_msg_data
634: );
635:
636: IF FND_API.to_Boolean( p_commit ) THEN
637: COMMIT WORK;
638: END IF;
639:
640: EXCEPTION

Line 641: WHEN FND_API.G_EXC_ERROR THEN

637: COMMIT WORK;
638: END IF;
639:
640: EXCEPTION
641: WHEN FND_API.G_EXC_ERROR THEN
642: ROLLBACK TO CREATE_ACCT_SITE_USES;
643: x_return_status := FND_API.G_RET_STS_ERROR;
644: -- Standard call to get message count and if count=1, get the message
645: FND_MSG_PUB.Count_And_Get (

Line 643: x_return_status := FND_API.G_RET_STS_ERROR;

639:
640: EXCEPTION
641: WHEN FND_API.G_EXC_ERROR THEN
642: ROLLBACK TO CREATE_ACCT_SITE_USES;
643: x_return_status := FND_API.G_RET_STS_ERROR;
644: -- Standard call to get message count and if count=1, get the message
645: FND_MSG_PUB.Count_And_Get (
646: p_encoded => FND_API.G_FALSE
647: ,p_count => x_msg_count

Line 646: p_encoded => FND_API.G_FALSE

642: ROLLBACK TO CREATE_ACCT_SITE_USES;
643: x_return_status := FND_API.G_RET_STS_ERROR;
644: -- Standard call to get message count and if count=1, get the message
645: FND_MSG_PUB.Count_And_Get (
646: p_encoded => FND_API.G_FALSE
647: ,p_count => x_msg_count
648: ,p_data => x_msg_data
649: );
650:

Line 651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

647: ,p_count => x_msg_count
648: ,p_data => x_msg_data
649: );
650:
651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
652: ROLLBACK TO CREATE_ACCT_SITE_USES;
653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
654: -- Standard call to get message count and if count=1, get the message
655: FND_MSG_PUB.Count_And_Get (

Line 653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

649: );
650:
651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
652: ROLLBACK TO CREATE_ACCT_SITE_USES;
653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
654: -- Standard call to get message count and if count=1, get the message
655: FND_MSG_PUB.Count_And_Get (
656: p_encoded => FND_API.G_FALSE
657: ,p_count => x_msg_count

Line 656: p_encoded => FND_API.G_FALSE

652: ROLLBACK TO CREATE_ACCT_SITE_USES;
653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
654: -- Standard call to get message count and if count=1, get the message
655: FND_MSG_PUB.Count_And_Get (
656: p_encoded => FND_API.G_FALSE
657: ,p_count => x_msg_count
658: ,p_data => x_msg_data
659: );
660:

Line 663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

659: );
660:
661: WHEN OTHERS THEN
662: ROLLBACK TO CREATE_ACCT_SITE_USES;
663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
664: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
665: THEN
666: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
667: END IF;

Line 670: p_encoded => FND_API.G_FALSE

666: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
667: END IF;
668: -- Standard call to get message count and if count=1, get the message
669: FND_MSG_PUB.Count_And_Get (
670: p_encoded => FND_API.G_FALSE
671: ,p_count => x_msg_count
672: ,p_data => x_msg_data
673: );
674:

Line 680: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

676:
677:
678:
679: PROCEDURE Create_Contact_Role ( p_api_version IN NUMBER
680: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
681: ,p_commit IN VARCHAR2 := FND_API.g_false
682: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
683: ,p_Cust_account_id IN NUMBER
684: ,p_cust_account_site_id IN NUMBER := FND_API.G_MISS_NUM

Line 681: ,p_commit IN VARCHAR2 := FND_API.g_false

677:
678:
679: PROCEDURE Create_Contact_Role ( p_api_version IN NUMBER
680: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
681: ,p_commit IN VARCHAR2 := FND_API.g_false
682: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
683: ,p_Cust_account_id IN NUMBER
684: ,p_cust_account_site_id IN NUMBER := FND_API.G_MISS_NUM
685: ,p_Role_type IN VARCHAR2 := 'CONTACT'

Line 682: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM

678:
679: PROCEDURE Create_Contact_Role ( p_api_version IN NUMBER
680: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
681: ,p_commit IN VARCHAR2 := FND_API.g_false
682: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
683: ,p_Cust_account_id IN NUMBER
684: ,p_cust_account_site_id IN NUMBER := FND_API.G_MISS_NUM
685: ,p_Role_type IN VARCHAR2 := 'CONTACT'
686: ,p_responsibility_type IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 684: ,p_cust_account_site_id IN NUMBER := FND_API.G_MISS_NUM

680: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
681: ,p_commit IN VARCHAR2 := FND_API.g_false
682: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
683: ,p_Cust_account_id IN NUMBER
684: ,p_cust_account_site_id IN NUMBER := FND_API.G_MISS_NUM
685: ,p_Role_type IN VARCHAR2 := 'CONTACT'
686: ,p_responsibility_type IN VARCHAR2 := FND_API.G_MISS_CHAR
687: ,x_return_status OUT NOCOPY VARCHAR2
688: ,x_msg_count OUT NOCOPY NUMBER

Line 686: ,p_responsibility_type IN VARCHAR2 := FND_API.G_MISS_CHAR

682: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
683: ,p_Cust_account_id IN NUMBER
684: ,p_cust_account_site_id IN NUMBER := FND_API.G_MISS_NUM
685: ,p_Role_type IN VARCHAR2 := 'CONTACT'
686: ,p_responsibility_type IN VARCHAR2 := FND_API.G_MISS_CHAR
687: ,x_return_status OUT NOCOPY VARCHAR2
688: ,x_msg_count OUT NOCOPY NUMBER
689: ,x_msg_data OUT NOCOPY VARCHAR2
690: ,x_cust_account_role_id OUT NOCOPY NUMBER

Line 709: x_return_status := FND_API.g_ret_sts_success;

705:
706: BEGIN
707: SAVEPOINT CREATE_CONTACT_ROLE;
708:
709: x_return_status := FND_API.g_ret_sts_success;
710:
711: IF FND_API.to_boolean(p_init_msg_list) THEN
712: FND_MSG_PUB.initialize;
713: END IF;

Line 711: IF FND_API.to_boolean(p_init_msg_list) THEN

707: SAVEPOINT CREATE_CONTACT_ROLE;
708:
709: x_return_status := FND_API.g_ret_sts_success;
710:
711: IF FND_API.to_boolean(p_init_msg_list) THEN
712: FND_MSG_PUB.initialize;
713: END IF;
714:
715: IF NOT FND_API.compatible_api_call(

Line 715: IF NOT FND_API.compatible_api_call(

711: IF FND_API.to_boolean(p_init_msg_list) THEN
712: FND_MSG_PUB.initialize;
713: END IF;
714:
715: IF NOT FND_API.compatible_api_call(
716: l_api_version,
717: p_api_version,
718: l_api_name,
719: g_pkg_name

Line 721: RAISE FND_API.g_exc_unexpected_error;

717: p_api_version,
718: l_api_name,
719: g_pkg_name
720: ) THEN
721: RAISE FND_API.g_exc_unexpected_error;
722: END IF;
723:
724:
725:

Line 746: p_init_msg_list => FND_API.G_FALSE,

742: PVX_UTILITY_PVT.debug_message('before create cust acct roles');
743: END IF;
744:
745: HZ_CUST_ACCOUNT_ROLE_V2PUB.create_cust_account_role (
746: p_init_msg_list => FND_API.G_FALSE,
747: p_cust_account_role_rec => p_cust_acct_roles_rec,
748: x_cust_account_role_id => x_cust_account_role_id,
749: x_return_status => x_return_status,
750: x_msg_count => x_msg_count,

Line 759: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

755: PVX_UTILITY_PVT.debug_message('create_contact_role:after create_cust_acct_role: x_return_status: '||x_return_status);
756:
757: END IF;
758:
759: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
761: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
762: RAISE FND_API.G_EXC_ERROR;
763: END IF;

Line 760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

756:
757: END IF;
758:
759: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
761: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
762: RAISE FND_API.G_EXC_ERROR;
763: END IF;
764:

Line 761: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

757: END IF;
758:
759: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
761: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
762: RAISE FND_API.G_EXC_ERROR;
763: END IF;
764:
765: IF(p_responsibility_type IS NOT NULL and p_responsibility_type <> FND_API.G_MISS_CHAR) THEN

Line 762: RAISE FND_API.G_EXC_ERROR;

758:
759: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
761: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
762: RAISE FND_API.G_EXC_ERROR;
763: END IF;
764:
765: IF(p_responsibility_type IS NOT NULL and p_responsibility_type <> FND_API.G_MISS_CHAR) THEN
766: OPEN C_Get_Resp(x_cust_account_role_id, p_responsibility_type);

Line 765: IF(p_responsibility_type IS NOT NULL and p_responsibility_type <> FND_API.G_MISS_CHAR) THEN

761: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
762: RAISE FND_API.G_EXC_ERROR;
763: END IF;
764:
765: IF(p_responsibility_type IS NOT NULL and p_responsibility_type <> FND_API.G_MISS_CHAR) THEN
766: OPEN C_Get_Resp(x_cust_account_role_id, p_responsibility_type);
767: FETCH C_Get_Resp INTO l_responsibility_id;
768:
769: IF C_Get_Resp%NOTFOUND THEN

Line 772: p_cust_account_site_id <> FND_API.G_MISS_NUM THEN

768:
769: IF C_Get_Resp%NOTFOUND THEN
770:
771: IF p_cust_account_site_id is not NULL AND
772: p_cust_account_site_id <> FND_API.G_MISS_NUM THEN
773: p_role_resp_rec.cust_account_role_id := x_cust_account_role_id;
774: p_role_resp_rec.responsibility_type := p_responsibility_type;
775:
776: HZ_CUST_ACCOUNT_ROLE_V2PUB.create_role_responsibility (

Line 777: p_init_msg_list => FND_API.G_FALSE,

773: p_role_resp_rec.cust_account_role_id := x_cust_account_role_id;
774: p_role_resp_rec.responsibility_type := p_responsibility_type;
775:
776: HZ_CUST_ACCOUNT_ROLE_V2PUB.create_role_responsibility (
777: p_init_msg_list => FND_API.G_FALSE,
778: p_role_responsibility_rec => p_role_resp_rec,
779: x_responsibility_id => l_responsibility_id,
780: x_return_status => x_return_status,
781: x_msg_count => x_msg_count,

Line 789: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

785: IF (PV_DEBUG_HIGH_ON) THEN
786: PVX_UTILITY_PVT.debug_message('create_contact_role:after create_role_resp: x_return_status: '||x_return_status);
787: END IF;
788:
789: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
791: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
792: RAISE FND_API.G_EXC_ERROR;
793: END IF;

Line 790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

786: PVX_UTILITY_PVT.debug_message('create_contact_role:after create_role_resp: x_return_status: '||x_return_status);
787: END IF;
788:
789: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
791: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
792: RAISE FND_API.G_EXC_ERROR;
793: END IF;
794:

Line 791: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

787: END IF;
788:
789: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
791: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
792: RAISE FND_API.G_EXC_ERROR;
793: END IF;
794:
795: END IF; --Cust_account_site_id is not null

Line 792: RAISE FND_API.G_EXC_ERROR;

788:
789: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
791: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
792: RAISE FND_API.G_EXC_ERROR;
793: END IF;
794:
795: END IF; --Cust_account_site_id is not null
796: END IF;--C_Get_Resp%NOTFOUND

Line 801: ( p_encoded => FND_API.G_FALSE ,

797: CLOSE C_Get_Resp;
798: END IF; --p_responsibility_type is not null
799:
800: FND_MSG_PUB.Count_And_Get
801: ( p_encoded => FND_API.G_FALSE ,
802: p_count => x_msg_count,
803: p_data => x_msg_data
804: );
805:

Line 806: IF FND_API.to_Boolean( p_commit ) THEN

802: p_count => x_msg_count,
803: p_data => x_msg_data
804: );
805:
806: IF FND_API.to_Boolean( p_commit ) THEN
807: COMMIT WORK;
808: END IF;
809:
810: EXCEPTION

Line 811: WHEN FND_API.G_EXC_ERROR THEN

807: COMMIT WORK;
808: END IF;
809:
810: EXCEPTION
811: WHEN FND_API.G_EXC_ERROR THEN
812: ROLLBACK TO CREATE_CONTACT_ROLE;
813: x_return_status := FND_API.G_RET_STS_ERROR;
814: -- Standard call to get message count and if count=1, get the message
815: FND_MSG_PUB.Count_And_Get (

Line 813: x_return_status := FND_API.G_RET_STS_ERROR;

809:
810: EXCEPTION
811: WHEN FND_API.G_EXC_ERROR THEN
812: ROLLBACK TO CREATE_CONTACT_ROLE;
813: x_return_status := FND_API.G_RET_STS_ERROR;
814: -- Standard call to get message count and if count=1, get the message
815: FND_MSG_PUB.Count_And_Get (
816: p_encoded => FND_API.G_FALSE
817: ,p_count => x_msg_count

Line 816: p_encoded => FND_API.G_FALSE

812: ROLLBACK TO CREATE_CONTACT_ROLE;
813: x_return_status := FND_API.G_RET_STS_ERROR;
814: -- Standard call to get message count and if count=1, get the message
815: FND_MSG_PUB.Count_And_Get (
816: p_encoded => FND_API.G_FALSE
817: ,p_count => x_msg_count
818: ,p_data => x_msg_data
819: );
820:

Line 821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

817: ,p_count => x_msg_count
818: ,p_data => x_msg_data
819: );
820:
821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
822: ROLLBACK TO CREATE_CONTACT_ROLE;
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
824: -- Standard call to get message count and if count=1, get the message
825: FND_MSG_PUB.Count_And_Get (

Line 823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

819: );
820:
821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
822: ROLLBACK TO CREATE_CONTACT_ROLE;
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
824: -- Standard call to get message count and if count=1, get the message
825: FND_MSG_PUB.Count_And_Get (
826: p_encoded => FND_API.G_FALSE
827: ,p_count => x_msg_count

Line 826: p_encoded => FND_API.G_FALSE

822: ROLLBACK TO CREATE_CONTACT_ROLE;
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
824: -- Standard call to get message count and if count=1, get the message
825: FND_MSG_PUB.Count_And_Get (
826: p_encoded => FND_API.G_FALSE
827: ,p_count => x_msg_count
828: ,p_data => x_msg_data
829: );
830:

Line 833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

829: );
830:
831: WHEN OTHERS THEN
832: ROLLBACK TO CREATE_CONTACT_ROLE;
833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
834: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
835: THEN
836: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
837: END IF;

Line 840: p_encoded => FND_API.G_FALSE

836: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
837: END IF;
838: -- Standard call to get message count and if count=1, get the message
839: FND_MSG_PUB.Count_And_Get (
840: p_encoded => FND_API.G_FALSE
841: ,p_count => x_msg_count
842: ,p_data => x_msg_data
843: );
844:

Line 868: x_return_status := FND_API.G_RET_STS_SUCCESS;

864: l_msg_data varchar2(200);
865:
866: BEGIN
867:
868: x_return_status := FND_API.G_RET_STS_SUCCESS;
869:
870:
871: IF (p_partner_party_id = FND_API.G_MISS_NUM or p_partner_party_id IS NULL) THEN
872: FND_MESSAGE.set_name('PV', 'PV_API_NO_PARTNER_PARTY_ID');

Line 871: IF (p_partner_party_id = FND_API.G_MISS_NUM or p_partner_party_id IS NULL) THEN

867:
868: x_return_status := FND_API.G_RET_STS_SUCCESS;
869:
870:
871: IF (p_partner_party_id = FND_API.G_MISS_NUM or p_partner_party_id IS NULL) THEN
872: FND_MESSAGE.set_name('PV', 'PV_API_NO_PARTNER_PARTY_ID');
873: FND_MSG_PUB.add;
874: RAISE FND_API.G_EXC_ERROR;
875: END IF;

Line 874: RAISE FND_API.G_EXC_ERROR;

870:
871: IF (p_partner_party_id = FND_API.G_MISS_NUM or p_partner_party_id IS NULL) THEN
872: FND_MESSAGE.set_name('PV', 'PV_API_NO_PARTNER_PARTY_ID');
873: FND_MSG_PUB.add;
874: RAISE FND_API.G_EXC_ERROR;
875: END IF;
876:
877:
878: OPEN C_get_partner_accnt_id(p_partner_Party_Id);

Line 881: IF x_Cust_Acct_Id IS NOT NULL and x_Cust_Acct_Id <> FND_API.G_MISS_NUM THEN

877:
878: OPEN C_get_partner_accnt_id(p_partner_Party_Id);
879: LOOP
880: FETCH C_get_partner_accnt_id INTO x_Cust_Acct_Id;
881: IF x_Cust_Acct_Id IS NOT NULL and x_Cust_Acct_Id <> FND_API.G_MISS_NUM THEN
882: exit;
883: END IF;
884: EXIT WHEN C_get_partner_accnt_id%NOTFOUND;
885: END LOOP;

Line 888: IF x_Cust_Acct_Id IS NULL OR x_Cust_Acct_Id = FND_API.G_MISS_NUM THEN

884: EXIT WHEN C_get_partner_accnt_id%NOTFOUND;
885: END LOOP;
886: CLOSE C_get_partner_accnt_id;
887:
888: IF x_Cust_Acct_Id IS NULL OR x_Cust_Acct_Id = FND_API.G_MISS_NUM THEN
889: Create_Customer_Account(
890: p_api_version => 1.0
891: ,P_partner_party_id => p_partner_party_id
892: ,x_return_status => x_return_status

Line 902: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

898: IF (PV_DEBUG_HIGH_ON) THEN
899: PVX_UTILITY_PVT.debug_message('x_return_status from Create_customer_account : ' || x_return_status);
900: END IF;
901:
902: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
904: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
905: RAISE FND_API.G_EXC_ERROR;
906: END IF;

Line 903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

899: PVX_UTILITY_PVT.debug_message('x_return_status from Create_customer_account : ' || x_return_status);
900: END IF;
901:
902: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
904: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
905: RAISE FND_API.G_EXC_ERROR;
906: END IF;
907: END IF;

Line 904: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

900: END IF;
901:
902: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
904: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
905: RAISE FND_API.G_EXC_ERROR;
906: END IF;
907: END IF;
908:

Line 905: RAISE FND_API.G_EXC_ERROR;

901:
902: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
904: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
905: RAISE FND_API.G_EXC_ERROR;
906: END IF;
907: END IF;
908:
909: END Get_Partner_Accnt_Id;

Line 949: x_return_status := FND_API.G_RET_STS_SUCCESS;

945: l_msg_count number;
946: l_msg_data varchar2(200);
947:
948: begin
949: x_return_status := FND_API.G_RET_STS_SUCCESS;
950:
951: IF (PV_DEBUG_HIGH_ON) THEN
952:
953: PVX_UTILITY_PVT.debug_message('site use in get_acct_site_uses = ' || p_acct_site_type);

Line 978: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

974: IF (PV_DEBUG_HIGH_ON) THEN
975: PVX_UTILITY_PVT.debug_message('x_return_status from Create_ACCT_SITE_USES : ' || x_return_status);
976: END IF;
977:
978: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
980: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
981: RAISE FND_API.G_EXC_ERROR;
982: END IF;

Line 979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

975: PVX_UTILITY_PVT.debug_message('x_return_status from Create_ACCT_SITE_USES : ' || x_return_status);
976: END IF;
977:
978: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
980: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
981: RAISE FND_API.G_EXC_ERROR;
982: END IF;
983:

Line 980: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

976: END IF;
977:
978: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
980: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
981: RAISE FND_API.G_EXC_ERROR;
982: END IF;
983:
984: END IF;

Line 981: RAISE FND_API.G_EXC_ERROR;

977:
978: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
980: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
981: RAISE FND_API.G_EXC_ERROR;
982: END IF;
983:
984: END IF;
985: close site_use_cur;

Line 1028: x_return_status := FND_API.G_RET_STS_SUCCESS;

1024:
1025:
1026: begin
1027:
1028: x_return_status := FND_API.G_RET_STS_SUCCESS;
1029:
1030: IF (PV_DEBUG_HIGH_ON) THEN
1031:
1032: PVX_UTILITY_PVT.debug_message('p_contact_party_id = ' || p_contact_party_id);

Line 1036: IF (p_cust_account_site_id IS NULL and p_cust_account_site_id <> FND_API.G_MISS_NUM) THEN

1032: PVX_UTILITY_PVT.debug_message('p_contact_party_id = ' || p_contact_party_id);
1033: END IF;
1034:
1035:
1036: IF (p_cust_account_site_id IS NULL and p_cust_account_site_id <> FND_API.G_MISS_NUM) THEN
1037: FND_MESSAGE.Set_Name('PV', 'PV_CUST_ACCOUNT_ROLE_ERROR');
1038: FND_MESSAGE.Set_Token('ID', to_char( p_contact_party_id), FALSE);
1039: FND_MSG_PUB.ADD;
1040: RAISE FND_API.G_EXC_ERROR;

Line 1040: RAISE FND_API.G_EXC_ERROR;

1036: IF (p_cust_account_site_id IS NULL and p_cust_account_site_id <> FND_API.G_MISS_NUM) THEN
1037: FND_MESSAGE.Set_Name('PV', 'PV_CUST_ACCOUNT_ROLE_ERROR');
1038: FND_MESSAGE.Set_Token('ID', to_char( p_contact_party_id), FALSE);
1039: FND_MSG_PUB.ADD;
1040: RAISE FND_API.G_EXC_ERROR;
1041: END IF;
1042:
1043: OPEN cust_role;
1044: FETCH cust_role INTO x_cust_account_role_id;

Line 1067: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1063: PVX_UTILITY_PVT.debug_message('x_return_status from get_cust_acct_roles = '|| x_return_status);
1064:
1065: END IF;
1066:
1067: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1069: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1070: RAISE FND_API.G_EXC_ERROR;
1071: END IF;

Line 1068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1064:
1065: END IF;
1066:
1067: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1069: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1070: RAISE FND_API.G_EXC_ERROR;
1071: END IF;
1072:

Line 1069: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

1065: END IF;
1066:
1067: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1069: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1070: RAISE FND_API.G_EXC_ERROR;
1071: END IF;
1072:
1073: END IF;

Line 1070: RAISE FND_API.G_EXC_ERROR;

1066:
1067: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1069: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1070: RAISE FND_API.G_EXC_ERROR;
1071: END IF;
1072:
1073: END IF;
1074: CLOSE cust_role;

Line 1087: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

1083:
1084:
1085: PROCEDURE Create_Party_Site(
1086: p_api_version IN NUMBER,
1087: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1088: p_commit IN VARCHAR2 := FND_API.g_false,
1089: p_party_site_rec IN PARTY_SITE_REC_TYPE,
1090: x_return_status OUT NOCOPY VARCHAR2,
1091: x_party_site_id OUT NOCOPY NUMBER,

Line 1088: p_commit IN VARCHAR2 := FND_API.g_false,

1084:
1085: PROCEDURE Create_Party_Site(
1086: p_api_version IN NUMBER,
1087: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1088: p_commit IN VARCHAR2 := FND_API.g_false,
1089: p_party_site_rec IN PARTY_SITE_REC_TYPE,
1090: x_return_status OUT NOCOPY VARCHAR2,
1091: x_party_site_id OUT NOCOPY NUMBER,
1092: x_msg_count OUT NOCOPY NUMBER,

Line 1114: IF FND_API.to_boolean(p_init_msg_list) THEN

1110:
1111: BEGIN
1112: SAVEPOINT CREATE_PARTY_SITE;
1113:
1114: IF FND_API.to_boolean(p_init_msg_list) THEN
1115: FND_MSG_PUB.initialize;
1116: END IF;
1117:
1118: IF NOT FND_API.compatible_api_call(

Line 1118: IF NOT FND_API.compatible_api_call(

1114: IF FND_API.to_boolean(p_init_msg_list) THEN
1115: FND_MSG_PUB.initialize;
1116: END IF;
1117:
1118: IF NOT FND_API.compatible_api_call(
1119: l_api_version,
1120: p_api_version,
1121: l_api_name,
1122: g_pkg_name

Line 1124: RAISE FND_API.g_exc_unexpected_error;

1120: p_api_version,
1121: l_api_name,
1122: g_pkg_name
1123: ) THEN
1124: RAISE FND_API.g_exc_unexpected_error;
1125: END IF;
1126:
1127: -- Initialize API return status to SUCCESS
1128: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1128: x_return_status := FND_API.G_RET_STS_SUCCESS;

1124: RAISE FND_API.g_exc_unexpected_error;
1125: END IF;
1126:
1127: -- Initialize API return status to SUCCESS
1128: x_return_status := FND_API.G_RET_STS_SUCCESS;
1129:
1130:
1131: l_party_site_rec.Created_by_Module := 'PV';
1132: l_party_site_use_rec.Created_by_Module := 'PV';

Line 1152: p_init_msg_list => FND_API.G_FALSE,

1148: l_location_rec.ORIG_SYSTEM_REFERENCE := -1;
1149: l_location_rec.CONTENT_SOURCE_TYPE := 'USER_ENTERED';
1150:
1151: HZ_LOCATION_V2PUB.create_location (
1152: p_init_msg_list => FND_API.G_FALSE,
1153: p_location_rec => l_location_rec,
1154: x_location_id => l_location_id,
1155: x_return_status => x_return_status,
1156: x_msg_count => x_msg_count ,

Line 1165: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1161: PVX_UTILITY_PVT.debug_message('create_party_site:after create_loc:l_location_id '||l_location_id);
1162: PVX_UTILITY_PVT.debug_message('create_party_site:after create_loc:x_return_status '||x_return_status);
1163: END IF;
1164:
1165: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1167: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1168: RAISE FND_API.G_EXC_ERROR;
1169: END IF;

Line 1166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1162: PVX_UTILITY_PVT.debug_message('create_party_site:after create_loc:x_return_status '||x_return_status);
1163: END IF;
1164:
1165: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1167: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1168: RAISE FND_API.G_EXC_ERROR;
1169: END IF;
1170:

Line 1167: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

1163: END IF;
1164:
1165: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1167: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1168: RAISE FND_API.G_EXC_ERROR;
1169: END IF;
1170:
1171: l_party_site_rec.party_id := p_party_site_rec.party_id;

Line 1168: RAISE FND_API.G_EXC_ERROR;

1164:
1165: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1167: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1168: RAISE FND_API.G_EXC_ERROR;
1169: END IF;
1170:
1171: l_party_site_rec.party_id := p_party_site_rec.party_id;
1172: l_party_site_rec.location_id := l_location_id;

Line 1176: p_init_msg_list => FND_API.G_FALSE,

1172: l_party_site_rec.location_id := l_location_id;
1173: l_party_site_rec.identifying_address_flag := p_party_site_rec.primary_flag;
1174:
1175: HZ_PARTY_SITE_V2PUB.create_party_site (
1176: p_init_msg_list => FND_API.G_FALSE,
1177: p_party_site_rec => l_party_site_rec,
1178: x_party_site_id => x_party_site_id,
1179: x_party_site_number => l_party_site_number,
1180: x_return_status => x_return_status,

Line 1191: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1187:
1188: PVX_UTILITY_PVT.debug_message('create_party_site:after create_site:x_return_status '||x_return_status);
1189: END IF;
1190:
1191: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1193: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1194: RAISE FND_API.G_EXC_ERROR;
1195: END IF;

Line 1192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1188: PVX_UTILITY_PVT.debug_message('create_party_site:after create_site:x_return_status '||x_return_status);
1189: END IF;
1190:
1191: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1193: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1194: RAISE FND_API.G_EXC_ERROR;
1195: END IF;
1196:

Line 1193: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

1189: END IF;
1190:
1191: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1193: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1194: RAISE FND_API.G_EXC_ERROR;
1195: END IF;
1196:
1197: l_party_site_use_rec.party_site_id := x_party_site_id;

Line 1194: RAISE FND_API.G_EXC_ERROR;

1190:
1191: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1193: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1194: RAISE FND_API.G_EXC_ERROR;
1195: END IF;
1196:
1197: l_party_site_use_rec.party_site_id := x_party_site_id;
1198: l_party_site_use_rec.site_use_type := p_party_site_rec.party_site_use_type;

Line 1202: p_init_msg_list => FND_API.G_FALSE,

1198: l_party_site_use_rec.site_use_type := p_party_site_rec.party_site_use_type;
1199:
1200:
1201: HZ_PARTY_SITE_V2PUB.create_party_site_use (
1202: p_init_msg_list => FND_API.G_FALSE,
1203: p_party_site_use_rec => l_party_site_use_rec,
1204: x_party_site_use_id => l_party_site_use_id,
1205: x_return_status => x_return_status,
1206: x_msg_count => x_msg_count,

Line 1218: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1214:
1215: PVX_UTILITY_PVT.debug_message('create_party_site:after create_site_use:l_party_site_use_id '||l_party_site_use_id);
1216: END IF;
1217:
1218: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1220: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1221: RAISE FND_API.G_EXC_ERROR;
1222: END IF;

Line 1219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1215: PVX_UTILITY_PVT.debug_message('create_party_site:after create_site_use:l_party_site_use_id '||l_party_site_use_id);
1216: END IF;
1217:
1218: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1220: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1221: RAISE FND_API.G_EXC_ERROR;
1222: END IF;
1223:

Line 1220: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

1216: END IF;
1217:
1218: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1220: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1221: RAISE FND_API.G_EXC_ERROR;
1222: END IF;
1223:
1224: FND_MSG_PUB.Count_And_Get

Line 1221: RAISE FND_API.G_EXC_ERROR;

1217:
1218: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1220: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1221: RAISE FND_API.G_EXC_ERROR;
1222: END IF;
1223:
1224: FND_MSG_PUB.Count_And_Get
1225: ( p_encoded => FND_API.G_FALSE,

Line 1225: ( p_encoded => FND_API.G_FALSE,

1221: RAISE FND_API.G_EXC_ERROR;
1222: END IF;
1223:
1224: FND_MSG_PUB.Count_And_Get
1225: ( p_encoded => FND_API.G_FALSE,
1226: p_count => x_msg_count,
1227: p_data => x_msg_data
1228: );
1229:

Line 1230: IF FND_API.to_Boolean( p_commit ) THEN

1226: p_count => x_msg_count,
1227: p_data => x_msg_data
1228: );
1229:
1230: IF FND_API.to_Boolean( p_commit ) THEN
1231: COMMIT WORK;
1232: END IF;
1233:
1234: EXCEPTION

Line 1235: WHEN FND_API.G_EXC_ERROR THEN

1231: COMMIT WORK;
1232: END IF;
1233:
1234: EXCEPTION
1235: WHEN FND_API.G_EXC_ERROR THEN
1236: ROLLBACK TO CREATE_PARTY_SITE;
1237: x_return_status := FND_API.G_RET_STS_ERROR;
1238: -- Standard call to get message count and if count=1, get the message
1239: FND_MSG_PUB.Count_And_Get (

Line 1237: x_return_status := FND_API.G_RET_STS_ERROR;

1233:
1234: EXCEPTION
1235: WHEN FND_API.G_EXC_ERROR THEN
1236: ROLLBACK TO CREATE_PARTY_SITE;
1237: x_return_status := FND_API.G_RET_STS_ERROR;
1238: -- Standard call to get message count and if count=1, get the message
1239: FND_MSG_PUB.Count_And_Get (
1240: p_encoded => FND_API.G_FALSE
1241: ,p_count => x_msg_count

Line 1240: p_encoded => FND_API.G_FALSE

1236: ROLLBACK TO CREATE_PARTY_SITE;
1237: x_return_status := FND_API.G_RET_STS_ERROR;
1238: -- Standard call to get message count and if count=1, get the message
1239: FND_MSG_PUB.Count_And_Get (
1240: p_encoded => FND_API.G_FALSE
1241: ,p_count => x_msg_count
1242: ,p_data => x_msg_data
1243: );
1244:

Line 1245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1241: ,p_count => x_msg_count
1242: ,p_data => x_msg_data
1243: );
1244:
1245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1246: ROLLBACK TO CREATE_PARTY_SITE;
1247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1248: -- Standard call to get message count and if count=1, get the message
1249: FND_MSG_PUB.Count_And_Get (

Line 1247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1243: );
1244:
1245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1246: ROLLBACK TO CREATE_PARTY_SITE;
1247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1248: -- Standard call to get message count and if count=1, get the message
1249: FND_MSG_PUB.Count_And_Get (
1250: p_encoded => FND_API.G_FALSE
1251: ,p_count => x_msg_count

Line 1250: p_encoded => FND_API.G_FALSE

1246: ROLLBACK TO CREATE_PARTY_SITE;
1247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1248: -- Standard call to get message count and if count=1, get the message
1249: FND_MSG_PUB.Count_And_Get (
1250: p_encoded => FND_API.G_FALSE
1251: ,p_count => x_msg_count
1252: ,p_data => x_msg_data
1253: );
1254:

Line 1257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1253: );
1254:
1255: WHEN OTHERS THEN
1256: ROLLBACK TO CREATE_PARTY_SITE;
1257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1258: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1259: THEN
1260: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1261: END IF;

Line 1264: p_encoded => FND_API.G_FALSE

1260: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1261: END IF;
1262: -- Standard call to get message count and if count=1, get the message
1263: FND_MSG_PUB.Count_And_Get (
1264: p_encoded => FND_API.G_FALSE
1265: ,p_count => x_msg_count
1266: ,p_data => x_msg_data
1267: );
1268: