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.IBE_CUSTOMER_PVT dependencies on FND_API

Line 4: l_true VARCHAR2(1) := FND_API.G_TRUE;

1: package body ibe_customer_pvt AS
2: /* $Header: IBEVACTB.pls 120.6.12010000.2 2009/06/03 10:02:51 scnagara ship $ */
3:
4: l_true VARCHAR2(1) := FND_API.G_TRUE;
5:
6:
7: --PROCEDURE Set_Bank_Acct_End_Date : This API has been removed: mannamra:10/07/2005
8:

Line 21: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

17: */
18: PROCEDURE setOptInOutPreference(
19: p_party_id IN NUMBER,
20: p_preference IN VARCHAR2,
21: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
22: p_commit IN VARCHAR2 := FND_API.G_FALSE,
23: p_api IN NUMBER,
24: x_return_status OUT NOCOPY VARCHAR2,
25: x_msg_count OUT NOCOPY NUMBER,

Line 22: p_commit IN VARCHAR2 := FND_API.G_FALSE,

18: PROCEDURE setOptInOutPreference(
19: p_party_id IN NUMBER,
20: p_preference IN VARCHAR2,
21: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
22: p_commit IN VARCHAR2 := FND_API.G_FALSE,
23: p_api IN NUMBER,
24: x_return_status OUT NOCOPY VARCHAR2,
25: x_msg_count OUT NOCOPY NUMBER,
26: x_msg_data OUT NOCOPY VARCHAR2

Line 44: IF NOT FND_API.compatible_api_call(1.0,

40: -- standard start of API savepoint
41: SAVEPOINT setOptInOutPreference;
42:
43: -- standard call to check for call compatibility
44: IF NOT FND_API.compatible_api_call(1.0,
45: p_api,
46: 'getOptInOutPreference',
47: G_PKG_NAME)
48: THEN

Line 49: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

45: p_api,
46: 'getOptInOutPreference',
47: G_PKG_NAME)
48: THEN
49: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
50: END IF;
51:
52: -- initialize message list if p_init_msg_list is set to TRUE.
53: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 53: IF FND_API.to_boolean(p_init_msg_list) THEN

49: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
50: END IF;
51:
52: -- initialize message list if p_init_msg_list is set to TRUE.
53: IF FND_API.to_boolean(p_init_msg_list) THEN
54: FND_MSG_PUB.initialize;
55: END IF;
56:
57: --begin set/create contact preferences

Line 69: FND_API.G_FALSE,

65: l_contact_preference_rec.contact_preference_id := l_id;
66: l_contact_preference_rec.preference_code := p_preference;
67: l_object_version_number := l_obj_ver;
68: HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference(
69: FND_API.G_FALSE,
70: l_contact_preference_rec,
71: l_object_version_number,
72: x_return_status,
73: x_msg_count,

Line 87: FND_API.G_FALSE,

83: l_contact_preference_rec2.requested_by := 'INTERNAL';
84: l_contact_preference_rec2.status := 'A';
85: l_contact_preference_rec2.created_by_module := 'TCA_V1_API';
86: HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference(
87: FND_API.G_FALSE,
88: l_contact_preference_rec2,
89: l_contact_preference_id,
90: x_return_status,
91: x_msg_count,

Line 99: IF FND_API.to_boolean(p_commit) THEN

95: --end set/create contact preferences
96:
97:
98: -- standard check of p_commit
99: IF FND_API.to_boolean(p_commit) THEN
100: commit;
101: END IF;
102: -- standard call to get message count and if count is 1, get message info
103: FND_MSG_PUB.count_and_get(

Line 104: p_encoded => FND_API.G_FALSE,

100: commit;
101: END IF;
102: -- standard call to get message count and if count is 1, get message info
103: FND_MSG_PUB.count_and_get(
104: p_encoded => FND_API.G_FALSE,
105: p_count => x_msg_count,
106: p_data => x_msg_data
107: );
108: --IBE_UTIL.disable_debug();

Line 112: WHEN FND_API.G_EXC_ERROR THEN

108: --IBE_UTIL.disable_debug();
109:
110: --standard exception catching for main body
111: EXCEPTION
112: WHEN FND_API.G_EXC_ERROR THEN
113: --IBE_UTIL.enable_debug();
114:
115: ROLLBACK TO setOptInOutPreference;
116: x_return_status := FND_API.G_RET_STS_ERROR;

Line 116: x_return_status := FND_API.G_RET_STS_ERROR;

112: WHEN FND_API.G_EXC_ERROR THEN
113: --IBE_UTIL.enable_debug();
114:
115: ROLLBACK TO setOptInOutPreference;
116: x_return_status := FND_API.G_RET_STS_ERROR;
117: FND_MSG_PUB.count_and_get(
118: p_encoded => FND_API.G_FALSE,
119: p_count => x_msg_count,
120: p_data => x_msg_data

Line 118: p_encoded => FND_API.G_FALSE,

114:
115: ROLLBACK TO setOptInOutPreference;
116: x_return_status := FND_API.G_RET_STS_ERROR;
117: FND_MSG_PUB.count_and_get(
118: p_encoded => FND_API.G_FALSE,
119: p_count => x_msg_count,
120: p_data => x_msg_data
121: );
122: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

128: END IF;
129:
130: --IBE_UTIL.disable_debug();
131:
132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
133: --IBE_UTIL.enable_debug();
134:
135: ROLLBACK TO setOptInOutPreference;
136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
133: --IBE_UTIL.enable_debug();
134:
135: ROLLBACK TO setOptInOutPreference;
136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
137: FND_MSG_PUB.count_and_get(
138: p_encoded => FND_API.G_FALSE,
139: p_count => x_msg_count,
140: p_data => x_msg_data

Line 138: p_encoded => FND_API.G_FALSE,

134:
135: ROLLBACK TO setOptInOutPreference;
136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
137: FND_MSG_PUB.count_and_get(
138: p_encoded => FND_API.G_FALSE,
139: p_count => x_msg_count,
140: p_data => x_msg_data
141: );
142: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

152: WHEN OTHERS THEN
153: --IBE_UTIL.enable_debug();
154:
155: ROLLBACK TO setOptInOutPreference;
156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
157: FND_MSG_PUB.count_and_get(
158: p_encoded => FND_API.G_FALSE,
159: p_count => x_msg_count,
160: p_data => x_msg_data

Line 158: p_encoded => FND_API.G_FALSE,

154:
155: ROLLBACK TO setOptInOutPreference;
156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
157: FND_MSG_PUB.count_and_get(
158: p_encoded => FND_API.G_FALSE,
159: p_count => x_msg_count,
160: p_data => x_msg_data
161: );
162: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 221: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

217: -- This procedure will return a valid credit card information
218: -- if it can find a default credit card.
219: procedure get_default_credit_card_info(
220: p_api_version IN NUMBER,
221: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
222: p_commit IN VARCHAR2 := FND_API.G_FALSE,
223: p_cust_account_id IN NUMBER,
224: p_party_id IN NUMBER,
225: p_mini_site_id IN NUMBER,

Line 222: p_commit IN VARCHAR2 := FND_API.G_FALSE,

218: -- if it can find a default credit card.
219: procedure get_default_credit_card_info(
220: p_api_version IN NUMBER,
221: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
222: p_commit IN VARCHAR2 := FND_API.G_FALSE,
223: p_cust_account_id IN NUMBER,
224: p_party_id IN NUMBER,
225: p_mini_site_id IN NUMBER,
226: x_return_status OUT NOCOPY VARCHAR2,

Line 311: IF NOT FND_API.compatible_api_call(l_api_version,

307: IBE_UTIL.debug('enter ibe_customer_pvt.get_default_credit_card_info');
308: END IF;
309:
310:
311: IF NOT FND_API.compatible_api_call(l_api_version,
312: p_api_version,
313: l_api_name,
314: G_PKG_NAME)
315: THEN

Line 316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

312: p_api_version,
313: l_api_name,
314: G_PKG_NAME)
315: THEN
316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
317: END IF;
318:
319: -- initialize message list if p_init_msg_list is set to TRUE.
320: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 320: IF FND_API.to_boolean(p_init_msg_list) THEN

316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
317: END IF;
318:
319: -- initialize message list if p_init_msg_list is set to TRUE.
320: IF FND_API.to_boolean(p_init_msg_list) THEN
321: FND_MSG_PUB.initialize;
322: END IF;
323:
324: -- Initialize API return status to success

Line 325: x_return_status := FND_API.G_RET_STS_SUCCESS;

321: FND_MSG_PUB.initialize;
322: END IF;
323:
324: -- Initialize API return status to success
325: x_return_status := FND_API.G_RET_STS_SUCCESS;
326:
327:
328: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
329: IBE_UTIL.debug('call cursor c_getPrimaryCCInfo()');

Line 390: x_return_status := FND_API.G_RET_STS_SUCCESS;

386: END IF;
387: */
388:
389:
390: x_return_status := FND_API.G_RET_STS_SUCCESS;
391: -- standard check of p_commit
392: IF FND_API.to_boolean(p_commit) THEN
393: commit;
394: END IF;

Line 392: IF FND_API.to_boolean(p_commit) THEN

388:
389:
390: x_return_status := FND_API.G_RET_STS_SUCCESS;
391: -- standard check of p_commit
392: IF FND_API.to_boolean(p_commit) THEN
393: commit;
394: END IF;
395:
396: -- standard call to get message count and if count is 1, get message info

Line 398: p_encoded => FND_API.G_FALSE,

394: END IF;
395:
396: -- standard call to get message count and if count is 1, get message info
397: FND_MSG_PUB.count_and_get(
398: p_encoded => FND_API.G_FALSE,
399: p_count => x_msg_count,
400: p_data => x_msg_data
401: );
402:

Line 412: WHEN FND_API.G_EXC_ERROR THEN

408: --IBE_UTIL.disable_debug();
409:
410: EXCEPTION
411:
412: WHEN FND_API.G_EXC_ERROR THEN
413: --IBE_UTIL.enable_debug();
414:
415: --ROLLBACK TO create_credit_card;
416:

Line 417: x_return_status := FND_API.G_RET_STS_ERROR;

413: --IBE_UTIL.enable_debug();
414:
415: --ROLLBACK TO create_credit_card;
416:
417: x_return_status := FND_API.G_RET_STS_ERROR;
418: FND_MSG_PUB.ADD;
419: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
420: p_data => x_msg_data,
421: p_encoded => 'F');

Line 437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

433:
434:
435:
436:
437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
438: --IBE_UTIL.enable_debug();
439:
440: --ROLLBACK TO create_credit_card;
441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
438: --IBE_UTIL.enable_debug();
439:
440: --ROLLBACK TO create_credit_card;
441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
442: FND_MSG_PUB.ADD;
443: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
444: p_data => x_msg_data,
445: p_encoded => 'F');

Line 469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

465: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
466: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
467: FND_MESSAGE.Set_Token('REASON', SQLERRM);
468: FND_MSG_PUB.Add;
469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
470: FND_MSG_PUB.Add;
471: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
472: p_data => x_msg_data,
473: p_encoded => 'F');