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

Line 94: x_return_status := fnd_api.g_ret_sts_success;

90: l_api_version := 1;
91: l_sysdate := sysdate;
92: i := 0;
93: k := 0;
94: x_return_status := fnd_api.g_ret_sts_success;
95: l_party_id := p_party_id;
96:
97: /* requested_by is validated against lookup_code for lookup_type = 'REQUESTED_BY'. valid values are INTERNAL/PARTY */
98: l_requested_by := 'INTERNAL';

Line 102: IF NOT fnd_api.compatible_api_call (l_api_version,

98: l_requested_by := 'INTERNAL';
99:
100: /* Standard call to check for call compatibility */
101: /*
102: IF NOT fnd_api.compatible_api_call (l_api_version,
103: p_api_version,
104: l_api_name,
105: g_pkg_name) THEN
106: RAISE fnd_api.g_exc_unexpected_error;

Line 106: RAISE fnd_api.g_exc_unexpected_error;

102: IF NOT fnd_api.compatible_api_call (l_api_version,
103: p_api_version,
104: l_api_name,
105: g_pkg_name) THEN
106: RAISE fnd_api.g_exc_unexpected_error;
107: END IF;
108: */
109:
110: /* Initialize message list if p_init_msg_list is set to TRUE */

Line 112: IF fnd_api.to_boolean (p_init_msg_list) THEN

108: */
109:
110: /* Initialize message list if p_init_msg_list is set to TRUE */
111:
112: IF fnd_api.to_boolean (p_init_msg_list) THEN
113: fnd_msg_pub.initialize;
114: END IF;
115:
116: /*If party id has not been passed then get the party id from fnd_user */

Line 162: p_init_msg_list => FND_API.G_FALSE,

158: -- it is properly caught
159: l_api_name := l_api_name||'-CREATE_CONTACT_PREFERENCE';
160:
161: hz_contact_preference_v2pub.create_contact_preference (
162: p_init_msg_list => FND_API.G_FALSE,
163: p_contact_preference_rec => l_contact_preference_record,
164: x_contact_preference_id => l_contact_preference_id,
165: x_return_status => l_return_status,
166: x_msg_count => l_msg_count,

Line 173: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN

169:
170: -- set back the API name to original name
171: l_api_name := l_api_name_1;
172:
173: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
174: -- Unexpected Execution Error from call to Get_contracts_resources
175: fnd_message.set_name('FND', 'FND_PII_GENERIC_API_ERROR');
176: fnd_message.set_token('P_PROC_NAME','CREATE_CONTACT_PREFERENCE');
177: fnd_message.set_token('P_API_NAME', l_api_name);

Line 179: RAISE fnd_api.g_exc_error;

175: fnd_message.set_name('FND', 'FND_PII_GENERIC_API_ERROR');
176: fnd_message.set_token('P_PROC_NAME','CREATE_CONTACT_PREFERENCE');
177: fnd_message.set_token('P_API_NAME', l_api_name);
178: fnd_msg_pub.add;
179: RAISE fnd_api.g_exc_error;
180: END IF; -- end of x_return_status check
181:
182: END IF; -- end of DO check
183:

Line 242: p_init_msg_list => FND_API.G_FALSE,

238: -- it is properly caught
239: l_api_name := l_api_name||'-CREATE_CONTACT_PREFERENCE';
240:
241: hz_contact_preference_v2pub.create_contact_preference (
242: p_init_msg_list => FND_API.G_FALSE,
243: p_contact_preference_rec => l_contact_preference_record,
244: x_contact_preference_id => l_contact_preference_id,
245: x_return_status => l_return_status,
246: x_msg_count => l_msg_count,

Line 253: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN

249:
250: -- set back the API name to original name
251: l_api_name := l_api_name_1;
252:
253: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
254: -- Unexpected Execution Error from call to Get_contracts_resources
255: fnd_message.set_name('FND', 'FND_PII_GENERIC_API_ERROR');
256: fnd_message.set_token('P_PROC_NAME','CREATE_CONTACT_PREFERENCE');
257: fnd_message.set_token('P_API_NAME', l_api_name);

Line 259: RAISE fnd_api.g_exc_error;

255: fnd_message.set_name('FND', 'FND_PII_GENERIC_API_ERROR');
256: fnd_message.set_token('P_PROC_NAME','CREATE_CONTACT_PREFERENCE');
257: fnd_message.set_token('P_API_NAME', l_api_name);
258: fnd_msg_pub.add;
259: RAISE fnd_api.g_exc_error;
260: END IF; -- end of x_return_status check
261:
262: END IF; -- end of DO check
263:

Line 271: IF (p_commit = FND_API.G_TRUE)

267:
268:
269: END IF; -- end of p_user_id check
270:
271: IF (p_commit = FND_API.G_TRUE)
272: THEN
273: COMMIT;
274: END IF;
275:

Line 286: WHEN FND_API.G_EXC_ERROR THEN

282: p_data => x_msg_data
283: );
284:
285: EXCEPTION
286: WHEN FND_API.G_EXC_ERROR THEN
287: x_return_status := FND_API.G_RET_STS_ERROR ;
288: FND_MSG_PUB.Count_And_Get
289: (
290: p_count => x_msg_count,

Line 287: x_return_status := FND_API.G_RET_STS_ERROR ;

283: );
284:
285: EXCEPTION
286: WHEN FND_API.G_EXC_ERROR THEN
287: x_return_status := FND_API.G_RET_STS_ERROR ;
288: FND_MSG_PUB.Count_And_Get
289: (
290: p_count => x_msg_count,
291: p_data => x_msg_data

Line 294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

290: p_count => x_msg_count,
291: p_data => x_msg_data
292: );
293:
294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
296: FND_MSG_PUB.Count_And_Get
297: (
298: p_count => x_msg_count,

Line 295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

291: p_data => x_msg_data
292: );
293:
294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
296: FND_MSG_PUB.Count_And_Get
297: (
298: p_count => x_msg_count,
299: p_data => x_msg_data

Line 309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

305: fnd_message.set_token('P_SQLERRM',SQLERRM);
306: fnd_message.set_token('P_API_NAME',l_api_name);
307: FND_MSG_PUB.add;
308:
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
310: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
311: FND_MSG_PUB.Add_Exc_Msg
312: (
313: G_PKG_NAME,

Line 377: x_return_status := fnd_api.g_ret_sts_success;

373: l_api_name := 'SET_DEFAULT_PREFERENCE';
374: l_api_name_1 := 'SET_DEFAULT_PREFERENCE';
375: l_api_version := 1;
376: l_sysdate := sysdate;
377: x_return_status := fnd_api.g_ret_sts_success;
378:
379: l_party_id := p_party_id;
380: l_requested_by := 'INTERNAL';
381: l_party_id := p_party_id;

Line 384: IF fnd_api.to_boolean (p_init_msg_list) THEN

380: l_requested_by := 'INTERNAL';
381: l_party_id := p_party_id;
382:
383:
384: IF fnd_api.to_boolean (p_init_msg_list) THEN
385: fnd_msg_pub.initialize;
386: END IF;
387:
388: /*If party id has not been passed then get the party id from fnd_user */

Line 418: WHEN FND_API.G_EXC_ERROR THEN

414: p_data => x_msg_data
415: );
416:
417: EXCEPTION
418: WHEN FND_API.G_EXC_ERROR THEN
419: x_return_status := FND_API.G_RET_STS_ERROR ;
420: FND_MSG_PUB.Count_And_Get
421: (
422: p_count => x_msg_count,

Line 419: x_return_status := FND_API.G_RET_STS_ERROR ;

415: );
416:
417: EXCEPTION
418: WHEN FND_API.G_EXC_ERROR THEN
419: x_return_status := FND_API.G_RET_STS_ERROR ;
420: FND_MSG_PUB.Count_And_Get
421: (
422: p_count => x_msg_count,
423: p_data => x_msg_data

Line 426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

422: p_count => x_msg_count,
423: p_data => x_msg_data
424: );
425:
426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
428: FND_MSG_PUB.Count_And_Get
429: (
430: p_count => x_msg_count,

Line 427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

423: p_data => x_msg_data
424: );
425:
426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
428: FND_MSG_PUB.Count_And_Get
429: (
430: p_count => x_msg_count,
431: p_data => x_msg_data

Line 441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

437: fnd_message.set_token('P_SQLERRM',SQLERRM);
438: fnd_message.set_token('P_API_NAME',l_api_name);
439: FND_MSG_PUB.add;
440:
441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
442: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
443: FND_MSG_PUB.Add_Exc_Msg
444: (
445: G_PKG_NAME,

Line 531: x_return_status := fnd_api.g_ret_sts_success;

527: l_api_version := 1;
528: l_sysdate := sysdate;
529: i := 0;
530: k := 0;
531: x_return_status := fnd_api.g_ret_sts_success;
532:
533: l_party_id := p_party_id;
534: l_requested_by := 'INTERNAL';
535: l_all_flag := 'N';

Line 538: IF fnd_api.to_boolean (p_init_msg_list) THEN

534: l_requested_by := 'INTERNAL';
535: l_all_flag := 'N';
536:
537:
538: IF fnd_api.to_boolean (p_init_msg_list) THEN
539: fnd_msg_pub.initialize;
540: END IF;
541:
542: IF fnd_api.to_boolean (p_init_msg_list) THEN

Line 542: IF fnd_api.to_boolean (p_init_msg_list) THEN

538: IF fnd_api.to_boolean (p_init_msg_list) THEN
539: fnd_msg_pub.initialize;
540: END IF;
541:
542: IF fnd_api.to_boolean (p_init_msg_list) THEN
543: fnd_msg_pub.initialize;
544: END IF;
545:
546: /*If party id has not been passed then get the party id from fnd_user */

Line 630: p_init_msg_list => FND_API.G_FALSE,

626: -- it is properly caught
627: l_api_name := l_api_name||'-CREATE_CONTACT_PREFERENCE';
628:
629: hz_contact_preference_v2pub.create_contact_preference (
630: p_init_msg_list => FND_API.G_FALSE,
631: p_contact_preference_rec => l_contact_preference_record,
632: x_contact_preference_id => l_contact_preference_id,
633: x_return_status => l_return_status,
634: x_msg_count => l_msg_count,

Line 641: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN

637:
638: -- set back the API name to original name
639: l_api_name := l_api_name_1;
640:
641: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
642: -- Unexpected Execution Error from call to Get_contracts_resources
643: fnd_message.set_name('FND', 'FND_PII_GENERIC_API_ERROR');
644: fnd_message.set_token('P_PROC_NAME','CREATE_CONTACT_PREFERENCE');
645: fnd_message.set_token('P_API_NAME', l_api_name);

Line 647: RAISE fnd_api.g_exc_error;

643: fnd_message.set_name('FND', 'FND_PII_GENERIC_API_ERROR');
644: fnd_message.set_token('P_PROC_NAME','CREATE_CONTACT_PREFERENCE');
645: fnd_message.set_token('P_API_NAME', l_api_name);
646: fnd_msg_pub.add;
647: RAISE fnd_api.g_exc_error;
648: END IF; -- end of x_return_status check
649: END IF; -- end of check of r_cont_pref record
650:
651: ELSIF(p_option(i).user_option = 'O')

Line 693: p_init_msg_list => FND_API.G_FALSE,

689: -- it is properly caught
690: l_api_name := l_api_name||'-CREATE_CONTACT_PREFERENCE';
691:
692: hz_contact_preference_v2pub.create_contact_preference (
693: p_init_msg_list => FND_API.G_FALSE,
694: p_contact_preference_rec => l_contact_preference_record,
695: x_contact_preference_id => l_contact_preference_id,
696: x_return_status => l_return_status,
697: x_msg_count => l_msg_count,

Line 704: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN

700:
701: -- set back the API name to original name
702: l_api_name := l_api_name_1;
703:
704: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
705: -- Unexpected Execution Error from call to Get_contracts_resources
706: fnd_message.set_name('FND', 'FND_PII_GENERIC_API_ERROR');
707: fnd_message.set_token('P_PROC_NAME','CREATE_CONTACT_PREFERENCE');
708: fnd_message.set_token('P_API_NAME', l_api_name);

Line 710: RAISE fnd_api.g_exc_error;

706: fnd_message.set_name('FND', 'FND_PII_GENERIC_API_ERROR');
707: fnd_message.set_token('P_PROC_NAME','CREATE_CONTACT_PREFERENCE');
708: fnd_message.set_token('P_API_NAME', l_api_name);
709: fnd_msg_pub.add;
710: RAISE fnd_api.g_exc_error;
711: END IF; -- end of x_return_status check
712: END IF; -- end of check of r_cont_pref record
713:
714: END IF; -- end of p_option.user_option check

Line 744: WHEN FND_API.G_EXC_ERROR THEN

740: p_data => x_msg_data
741: );
742:
743: EXCEPTION
744: WHEN FND_API.G_EXC_ERROR THEN
745: x_return_status := FND_API.G_RET_STS_ERROR ;
746: FND_MSG_PUB.Count_And_Get
747: (
748: p_count => x_msg_count,

Line 745: x_return_status := FND_API.G_RET_STS_ERROR ;

741: );
742:
743: EXCEPTION
744: WHEN FND_API.G_EXC_ERROR THEN
745: x_return_status := FND_API.G_RET_STS_ERROR ;
746: FND_MSG_PUB.Count_And_Get
747: (
748: p_count => x_msg_count,
749: p_data => x_msg_data

Line 752: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

748: p_count => x_msg_count,
749: p_data => x_msg_data
750: );
751:
752: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
754: FND_MSG_PUB.Count_And_Get
755: (
756: p_count => x_msg_count,

Line 753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

749: p_data => x_msg_data
750: );
751:
752: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
754: FND_MSG_PUB.Count_And_Get
755: (
756: p_count => x_msg_count,
757: p_data => x_msg_data

Line 767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

763: fnd_message.set_token('P_SQLERRM',SQLERRM);
764: fnd_message.set_token('P_API_NAME',l_api_name);
765: FND_MSG_PUB.add;
766:
767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
768: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
769: FND_MSG_PUB.Add_Exc_Msg
770: (
771: G_PKG_NAME,