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 2005/11/18 18:21:58 mannamra 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 309: IF NOT FND_API.compatible_api_call(l_api_version,

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

Line 314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 318: IF FND_API.to_boolean(p_init_msg_list) THEN

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

Line 323: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 388: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 390: IF FND_API.to_boolean(p_commit) THEN

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

Line 396: p_encoded => FND_API.G_FALSE,

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

Line 410: WHEN FND_API.G_EXC_ERROR THEN

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

Line 415: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 435: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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