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

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

38:
39: PROCEDURE create_act_partner
40: (
41: p_api_version IN NUMBER,
42: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
43: p_commit IN VARCHAR2 := FND_API.g_false,
44: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
45: x_return_status OUT NOCOPY VARCHAR2,
46: x_msg_count OUT NOCOPY NUMBER,

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

39: PROCEDURE create_act_partner
40: (
41: p_api_version IN NUMBER,
42: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
43: p_commit IN VARCHAR2 := FND_API.g_false,
44: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
45: x_return_status OUT NOCOPY VARCHAR2,
46: x_msg_count OUT NOCOPY NUMBER,
47: x_msg_data OUT NOCOPY VARCHAR2,

Line 44: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

40: (
41: p_api_version IN NUMBER,
42: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
43: p_commit IN VARCHAR2 := FND_API.g_false,
44: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
45: x_return_status OUT NOCOPY VARCHAR2,
46: x_msg_count OUT NOCOPY NUMBER,
47: x_msg_data OUT NOCOPY VARCHAR2,
48: p_act_partner_rec IN act_partner_rec_type,

Line 76: IF FND_API.to_boolean(p_init_msg_list) THEN

72: --------------------- initialize -----------------------
73: SAVEPOINT create_act_partner;
74:
75:
76: IF FND_API.to_boolean(p_init_msg_list) THEN
77: FND_MSG_PUB.initialize;
78: END IF;
79:
80: IF NOT FND_API.compatible_api_call

Line 80: IF NOT FND_API.compatible_api_call

76: IF FND_API.to_boolean(p_init_msg_list) THEN
77: FND_MSG_PUB.initialize;
78: END IF;
79:
80: IF NOT FND_API.compatible_api_call
81: (
82: l_api_version,
83: p_api_version,
84: l_api_name,

Line 87: RAISE FND_API.g_exc_unexpected_error;

83: p_api_version,
84: l_api_name,
85: g_pkg_name
86: ) THEN
87: RAISE FND_API.g_exc_unexpected_error;
88: END IF;
89:
90: x_return_status := FND_API.g_ret_sts_success;
91:

Line 90: x_return_status := FND_API.g_ret_sts_success;

86: ) THEN
87: RAISE FND_API.g_exc_unexpected_error;
88: END IF;
89:
90: x_return_status := FND_API.g_ret_sts_success;
91:
92: ----------------------- validate -----------------------
93: IF (AMS_DEBUG_HIGH_ON) THEN
94:

Line 109: IF l_return_status = FND_API.g_ret_sts_error THEN

105: x_msg_data => x_msg_data,
106: p_act_partner_rec => l_act_partner_rec
107: );
108:
109: IF l_return_status = FND_API.g_ret_sts_error THEN
110: RAISE FND_API.g_exc_error;
111: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
112: RAISE FND_API.g_exc_unexpected_error;
113: END IF;

Line 110: RAISE FND_API.g_exc_error;

106: p_act_partner_rec => l_act_partner_rec
107: );
108:
109: IF l_return_status = FND_API.g_ret_sts_error THEN
110: RAISE FND_API.g_exc_error;
111: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
112: RAISE FND_API.g_exc_unexpected_error;
113: END IF;
114:

Line 111: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

107: );
108:
109: IF l_return_status = FND_API.g_ret_sts_error THEN
110: RAISE FND_API.g_exc_error;
111: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
112: RAISE FND_API.g_exc_unexpected_error;
113: END IF;
114:
115: -------------------------- insert --------------------------

Line 112: RAISE FND_API.g_exc_unexpected_error;

108:
109: IF l_return_status = FND_API.g_ret_sts_error THEN
110: RAISE FND_API.g_exc_error;
111: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
112: RAISE FND_API.g_exc_unexpected_error;
113: END IF;
114:
115: -------------------------- insert --------------------------
116: IF (AMS_DEBUG_HIGH_ON) THEN

Line 219: IF l_return_status = FND_API.g_ret_sts_error THEN

215: AMS_Utility_PVT.debug_message(l_full_name ||': call modify_object_attribute');
216:
217: END IF;
218:
219: IF l_return_status = FND_API.g_ret_sts_error THEN
220: RAISE FND_API.g_exc_error;
221: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
222: RAISE FND_API.g_exc_unexpected_error;
223: END IF;

Line 220: RAISE FND_API.g_exc_error;

216:
217: END IF;
218:
219: IF l_return_status = FND_API.g_ret_sts_error THEN
220: RAISE FND_API.g_exc_error;
221: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
222: RAISE FND_API.g_exc_unexpected_error;
223: END IF;
224:

Line 221: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

217: END IF;
218:
219: IF l_return_status = FND_API.g_ret_sts_error THEN
220: RAISE FND_API.g_exc_error;
221: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
222: RAISE FND_API.g_exc_unexpected_error;
223: END IF;
224:
225: ------------------------- finish -------------------------------

Line 222: RAISE FND_API.g_exc_unexpected_error;

218:
219: IF l_return_status = FND_API.g_ret_sts_error THEN
220: RAISE FND_API.g_exc_error;
221: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
222: RAISE FND_API.g_exc_unexpected_error;
223: END IF;
224:
225: ------------------------- finish -------------------------------
226: x_act_partner_id := l_act_partner_rec.activity_partner_id;

Line 228: IF FND_API.to_boolean(p_commit) THEN

224:
225: ------------------------- finish -------------------------------
226: x_act_partner_id := l_act_partner_rec.activity_partner_id;
227:
228: IF FND_API.to_boolean(p_commit) THEN
229: COMMIT;
230: END IF;
231:
232: FND_MSG_PUB.count_and_get(

Line 233: p_encoded => FND_API.g_false,

229: COMMIT;
230: END IF;
231:
232: FND_MSG_PUB.count_and_get(
233: p_encoded => FND_API.g_false,
234: p_count => x_msg_count,
235: p_data => x_msg_data
236: );
237:

Line 248: WHEN FND_API.g_exc_error THEN

244: END IF;
245:
246: EXCEPTION
247:
248: WHEN FND_API.g_exc_error THEN
249: ROLLBACK TO create_act_partner;
250: x_return_status := FND_API.g_ret_sts_error;
251: FND_MSG_PUB.count_and_get(
252: p_encoded => FND_API.g_false,

Line 250: x_return_status := FND_API.g_ret_sts_error;

246: EXCEPTION
247:
248: WHEN FND_API.g_exc_error THEN
249: ROLLBACK TO create_act_partner;
250: x_return_status := FND_API.g_ret_sts_error;
251: FND_MSG_PUB.count_and_get(
252: p_encoded => FND_API.g_false,
253: p_count => x_msg_count,
254: p_data => x_msg_data

Line 252: p_encoded => FND_API.g_false,

248: WHEN FND_API.g_exc_error THEN
249: ROLLBACK TO create_act_partner;
250: x_return_status := FND_API.g_ret_sts_error;
251: FND_MSG_PUB.count_and_get(
252: p_encoded => FND_API.g_false,
253: p_count => x_msg_count,
254: p_data => x_msg_data
255: );
256:

Line 257: WHEN FND_API.g_exc_unexpected_error THEN

253: p_count => x_msg_count,
254: p_data => x_msg_data
255: );
256:
257: WHEN FND_API.g_exc_unexpected_error THEN
258: ROLLBACK TO create_act_partner;
259: x_return_status := FND_API.g_ret_sts_unexp_error ;
260: FND_MSG_PUB.count_and_get(
261: p_encoded => FND_API.g_false,

Line 259: x_return_status := FND_API.g_ret_sts_unexp_error ;

255: );
256:
257: WHEN FND_API.g_exc_unexpected_error THEN
258: ROLLBACK TO create_act_partner;
259: x_return_status := FND_API.g_ret_sts_unexp_error ;
260: FND_MSG_PUB.count_and_get(
261: p_encoded => FND_API.g_false,
262: p_count => x_msg_count,
263: p_data => x_msg_data

Line 261: p_encoded => FND_API.g_false,

257: WHEN FND_API.g_exc_unexpected_error THEN
258: ROLLBACK TO create_act_partner;
259: x_return_status := FND_API.g_ret_sts_unexp_error ;
260: FND_MSG_PUB.count_and_get(
261: p_encoded => FND_API.g_false,
262: p_count => x_msg_count,
263: p_data => x_msg_data
264: );
265:

Line 269: x_return_status := FND_API.g_ret_sts_unexp_error ;

265:
266:
267: WHEN OTHERS THEN
268: ROLLBACK TO create_act_partner;
269: x_return_status := FND_API.g_ret_sts_unexp_error ;
270:
271: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
272: THEN
273: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 277: p_encoded => FND_API.g_false,

273: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
274: END IF;
275:
276: FND_MSG_PUB.count_and_get(
277: p_encoded => FND_API.g_false,
278: p_count => x_msg_count,
279: p_data => x_msg_data
280: );
281:

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

291:
292: PROCEDURE update_act_partner
293: (
294: p_api_version IN NUMBER,
295: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
296: p_commit IN VARCHAR2 := FND_API.g_false,
297: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
298: --p_object_version_number IN NUMBER,
299:

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

292: PROCEDURE update_act_partner
293: (
294: p_api_version IN NUMBER,
295: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
296: p_commit IN VARCHAR2 := FND_API.g_false,
297: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
298: --p_object_version_number IN NUMBER,
299:
300: x_return_status OUT NOCOPY VARCHAR2,

Line 297: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

293: (
294: p_api_version IN NUMBER,
295: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
296: p_commit IN VARCHAR2 := FND_API.g_false,
297: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
298: --p_object_version_number IN NUMBER,
299:
300: x_return_status OUT NOCOPY VARCHAR2,
301: x_msg_count OUT NOCOPY NUMBER,

Line 322: IF FND_API.to_boolean(p_init_msg_list) THEN

318:
319:
320: SAVEPOINT update_act_partner;
321: l_act_partner_rec := p_act_partner_rec;
322: IF FND_API.to_boolean(p_init_msg_list) THEN
323: FND_MSG_PUB.initialize;
324: END IF;
325:
326: IF NOT FND_API.compatible_api_call(

Line 326: IF NOT FND_API.compatible_api_call(

322: IF FND_API.to_boolean(p_init_msg_list) THEN
323: FND_MSG_PUB.initialize;
324: END IF;
325:
326: IF NOT FND_API.compatible_api_call(
327: l_api_version,
328: p_api_version,
329: l_api_name,
330: g_pkg_name

Line 333: RAISE FND_API.g_exc_unexpected_error;

329: l_api_name,
330: g_pkg_name
331: ) THEN
332:
333: RAISE FND_API.g_exc_unexpected_error;
334: END IF;
335:
336: x_return_status := FND_API.G_RET_STS_SUCCESS;
337:

Line 336: x_return_status := FND_API.G_RET_STS_SUCCESS;

332:
333: RAISE FND_API.g_exc_unexpected_error;
334: END IF;
335:
336: x_return_status := FND_API.G_RET_STS_SUCCESS;
337:
338: ----------------------- validate ----------------------
339:
340: -- replace g_miss_char/num/date with current column values

Line 360: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

356: p_validation_mode => JTF_PLSQL_API.g_update,
357: x_return_status => l_return_status
358: );
359:
360: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
361: RAISE FND_API.g_exc_unexpected_error;
362: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
363: RAISE FND_API.g_exc_error;
364: END IF;

Line 361: RAISE FND_API.g_exc_unexpected_error;

357: x_return_status => l_return_status
358: );
359:
360: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
361: RAISE FND_API.g_exc_unexpected_error;
362: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
363: RAISE FND_API.g_exc_error;
364: END IF;
365: END IF;

Line 362: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

358: );
359:
360: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
361: RAISE FND_API.g_exc_unexpected_error;
362: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
363: RAISE FND_API.g_exc_error;
364: END IF;
365: END IF;
366:

Line 363: RAISE FND_API.g_exc_error;

359:
360: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
361: RAISE FND_API.g_exc_unexpected_error;
362: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
363: RAISE FND_API.g_exc_error;
364: END IF;
365: END IF;
366:
367:

Line 384: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

380: p_complete_rec => l_act_partner_rec,
381: x_return_status => l_return_status
382: );
383:
384: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
385: RAISE FND_API.g_exc_unexpected_error;
386: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
387: RAISE FND_API.g_exc_error;
388: END IF;

Line 385: RAISE FND_API.g_exc_unexpected_error;

381: x_return_status => l_return_status
382: );
383:
384: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
385: RAISE FND_API.g_exc_unexpected_error;
386: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
387: RAISE FND_API.g_exc_error;
388: END IF;
389: END IF;

Line 386: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

382: );
383:
384: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
385: RAISE FND_API.g_exc_unexpected_error;
386: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
387: RAISE FND_API.g_exc_error;
388: END IF;
389: END IF;
390:

Line 387: RAISE FND_API.g_exc_error;

383:
384: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
385: RAISE FND_API.g_exc_unexpected_error;
386: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
387: RAISE FND_API.g_exc_error;
388: END IF;
389: END IF;
390:
391:

Line 432: RAISE FND_API.g_exc_error;

428: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
429: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
430: FND_MSG_PUB.add;
431: END IF;
432: RAISE FND_API.g_exc_error;
433: END IF;
434:
435: -------------------- finish --------------------------
436: IF FND_API.to_boolean(p_commit) THEN

Line 436: IF FND_API.to_boolean(p_commit) THEN

432: RAISE FND_API.g_exc_error;
433: END IF;
434:
435: -------------------- finish --------------------------
436: IF FND_API.to_boolean(p_commit) THEN
437: COMMIT;
438: END IF;
439:
440: FND_MSG_PUB.count_and_get(

Line 441: p_encoded => FND_API.g_false,

437: COMMIT;
438: END IF;
439:
440: FND_MSG_PUB.count_and_get(
441: p_encoded => FND_API.g_false,
442: p_count => x_msg_count,
443: p_data => x_msg_data
444: );
445:

Line 457: WHEN FND_API.g_exc_error THEN

453:
454:
455: EXCEPTION
456:
457: WHEN FND_API.g_exc_error THEN
458: IF (AMS_DEBUG_HIGH_ON) THEN
459:
460: AMS_Utility_PVT.debug_message('into exception block');
461: END IF;

Line 464: x_return_status := FND_API.g_ret_sts_error;

460: AMS_Utility_PVT.debug_message('into exception block');
461: END IF;
462:
463: ROLLBACK TO update_act_partner;
464: x_return_status := FND_API.g_ret_sts_error;
465: FND_MSG_PUB.count_and_get(
466: p_encoded => FND_API.g_false,
467: p_count => x_msg_count,
468: p_data => x_msg_data

Line 466: p_encoded => FND_API.g_false,

462:
463: ROLLBACK TO update_act_partner;
464: x_return_status := FND_API.g_ret_sts_error;
465: FND_MSG_PUB.count_and_get(
466: p_encoded => FND_API.g_false,
467: p_count => x_msg_count,
468: p_data => x_msg_data
469: );
470: --RAISE FND_API.G_EXC_ERROR;

Line 470: --RAISE FND_API.G_EXC_ERROR;

466: p_encoded => FND_API.g_false,
467: p_count => x_msg_count,
468: p_data => x_msg_data
469: );
470: --RAISE FND_API.G_EXC_ERROR;
471:
472: WHEN FND_API.g_exc_unexpected_error THEN
473:
474: ROLLBACK TO update_act_partner;

Line 472: WHEN FND_API.g_exc_unexpected_error THEN

468: p_data => x_msg_data
469: );
470: --RAISE FND_API.G_EXC_ERROR;
471:
472: WHEN FND_API.g_exc_unexpected_error THEN
473:
474: ROLLBACK TO update_act_partner;
475: x_return_status := FND_API.g_ret_sts_unexp_error ;
476: FND_MSG_PUB.count_and_get(

Line 475: x_return_status := FND_API.g_ret_sts_unexp_error ;

471:
472: WHEN FND_API.g_exc_unexpected_error THEN
473:
474: ROLLBACK TO update_act_partner;
475: x_return_status := FND_API.g_ret_sts_unexp_error ;
476: FND_MSG_PUB.count_and_get(
477: p_encoded => FND_API.g_false,
478: p_count => x_msg_count,
479: p_data => x_msg_data

Line 477: p_encoded => FND_API.g_false,

473:
474: ROLLBACK TO update_act_partner;
475: x_return_status := FND_API.g_ret_sts_unexp_error ;
476: FND_MSG_PUB.count_and_get(
477: p_encoded => FND_API.g_false,
478: p_count => x_msg_count,
479: p_data => x_msg_data
480: );
481: --RAISE FND_API.g_exc_unexpected_error;

Line 481: --RAISE FND_API.g_exc_unexpected_error;

477: p_encoded => FND_API.g_false,
478: p_count => x_msg_count,
479: p_data => x_msg_data
480: );
481: --RAISE FND_API.g_exc_unexpected_error;
482:
483: WHEN OTHERS THEN
484:
485: ROLLBACK TO update_act_partner;

Line 486: x_return_status := FND_API.g_ret_sts_unexp_error ;

482:
483: WHEN OTHERS THEN
484:
485: ROLLBACK TO update_act_partner;
486: x_return_status := FND_API.g_ret_sts_unexp_error ;
487:
488: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
489: THEN
490: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 494: p_encoded => FND_API.g_false,

490: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
491: END IF;
492:
493: FND_MSG_PUB.count_and_get(
494: p_encoded => FND_API.g_false,
495: p_count => x_msg_count,
496: p_data => x_msg_data
497: );
498: --RAISE FND_API.G_EXC_ERROR;

Line 498: --RAISE FND_API.G_EXC_ERROR;

494: p_encoded => FND_API.g_false,
495: p_count => x_msg_count,
496: p_data => x_msg_data
497: );
498: --RAISE FND_API.G_EXC_ERROR;
499:
500: END update_act_partner;
501:
502: --------------------------------------------------------------------

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

513:
514: PROCEDURE delete_act_partner
515: (
516: p_api_version IN NUMBER,
517: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
518: p_commit IN VARCHAR2 := FND_API.g_false,
519:
520: x_return_status OUT NOCOPY VARCHAR2,
521: x_msg_count OUT NOCOPY NUMBER,

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

514: PROCEDURE delete_act_partner
515: (
516: p_api_version IN NUMBER,
517: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
518: p_commit IN VARCHAR2 := FND_API.g_false,
519:
520: x_return_status OUT NOCOPY VARCHAR2,
521: x_msg_count OUT NOCOPY NUMBER,
522: x_msg_data OUT NOCOPY VARCHAR2,

Line 574: IF FND_API.to_boolean(p_init_msg_list) THEN

570: AMS_Utility_PVT.debug_message(l_full_name||': start');
571:
572: END IF;
573:
574: IF FND_API.to_boolean(p_init_msg_list) THEN
575: FND_MSG_PUB.initialize;
576: END IF;
577:
578: IF NOT FND_API.compatible_api_call(

Line 578: IF NOT FND_API.compatible_api_call(

574: IF FND_API.to_boolean(p_init_msg_list) THEN
575: FND_MSG_PUB.initialize;
576: END IF;
577:
578: IF NOT FND_API.compatible_api_call(
579: l_api_version,
580: p_api_version,
581: l_api_name,
582: g_pkg_name

Line 584: RAISE FND_API.g_exc_unexpected_error;

580: p_api_version,
581: l_api_name,
582: g_pkg_name
583: ) THEN
584: RAISE FND_API.g_exc_unexpected_error;
585: END IF;
586:
587: x_return_status := FND_API.G_RET_STS_SUCCESS;
588:

Line 587: x_return_status := FND_API.G_RET_STS_SUCCESS;

583: ) THEN
584: RAISE FND_API.g_exc_unexpected_error;
585: END IF;
586:
587: x_return_status := FND_API.G_RET_STS_SUCCESS;
588:
589: OPEN c_partner_type (p_act_partner_id);
590: FETCH c_partner_type INTO l_object_type, l_object_id;
591: CLOSE c_partner_type;

Line 614: RAISE FND_API.g_exc_error;

610: THEN
611: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
612: FND_MSG_PUB.add;
613: END IF;
614: RAISE FND_API.g_exc_error;
615: END IF;
616:
617:
618: -------------------- finish --------------------------

Line 619: IF FND_API.to_boolean(p_commit) THEN

615: END IF;
616:
617:
618: -------------------- finish --------------------------
619: IF FND_API.to_boolean(p_commit) THEN
620: COMMIT;
621: END IF;
622:
623: FND_MSG_PUB.count_and_get(

Line 624: p_encoded => FND_API.g_false,

620: COMMIT;
621: END IF;
622:
623: FND_MSG_PUB.count_and_get(
624: p_encoded => FND_API.g_false,
625: p_count => x_msg_count,
626: p_data => x_msg_data
627: );
628:

Line 639: WHEN FND_API.g_exc_error THEN

635: END IF;
636:
637: EXCEPTION
638:
639: WHEN FND_API.g_exc_error THEN
640: ROLLBACK TO delete_act_partner;
641: x_return_status := FND_API.g_ret_sts_error;
642: FND_MSG_PUB.count_and_get(
643: p_encoded => FND_API.g_false,

Line 641: x_return_status := FND_API.g_ret_sts_error;

637: EXCEPTION
638:
639: WHEN FND_API.g_exc_error THEN
640: ROLLBACK TO delete_act_partner;
641: x_return_status := FND_API.g_ret_sts_error;
642: FND_MSG_PUB.count_and_get(
643: p_encoded => FND_API.g_false,
644: p_count => x_msg_count,
645: p_data => x_msg_data

Line 643: p_encoded => FND_API.g_false,

639: WHEN FND_API.g_exc_error THEN
640: ROLLBACK TO delete_act_partner;
641: x_return_status := FND_API.g_ret_sts_error;
642: FND_MSG_PUB.count_and_get(
643: p_encoded => FND_API.g_false,
644: p_count => x_msg_count,
645: p_data => x_msg_data
646: );
647:

Line 648: WHEN FND_API.g_exc_unexpected_error THEN

644: p_count => x_msg_count,
645: p_data => x_msg_data
646: );
647:
648: WHEN FND_API.g_exc_unexpected_error THEN
649: ROLLBACK TO delete_act_partner;
650: x_return_status := FND_API.g_ret_sts_unexp_error ;
651: FND_MSG_PUB.count_and_get(
652: p_encoded => FND_API.g_false,

Line 650: x_return_status := FND_API.g_ret_sts_unexp_error ;

646: );
647:
648: WHEN FND_API.g_exc_unexpected_error THEN
649: ROLLBACK TO delete_act_partner;
650: x_return_status := FND_API.g_ret_sts_unexp_error ;
651: FND_MSG_PUB.count_and_get(
652: p_encoded => FND_API.g_false,
653: p_count => x_msg_count,
654: p_data => x_msg_data

Line 652: p_encoded => FND_API.g_false,

648: WHEN FND_API.g_exc_unexpected_error THEN
649: ROLLBACK TO delete_act_partner;
650: x_return_status := FND_API.g_ret_sts_unexp_error ;
651: FND_MSG_PUB.count_and_get(
652: p_encoded => FND_API.g_false,
653: p_count => x_msg_count,
654: p_data => x_msg_data
655: );
656:

Line 659: x_return_status := FND_API.g_ret_sts_unexp_error ;

655: );
656:
657: WHEN OTHERS THEN
658: ROLLBACK TO delete_deliverable;
659: x_return_status := FND_API.g_ret_sts_unexp_error ;
660:
661: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
662: THEN
663: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 667: p_encoded => FND_API.g_false,

663: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
664: END IF;
665:
666: FND_MSG_PUB.count_and_get(
667: p_encoded => FND_API.g_false,
668: p_count => x_msg_count,
669: p_data => x_msg_data
670: );
671:

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

682:
683: PROCEDURE lock_act_partner
684: (
685: p_api_version IN NUMBER,
686: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
687:
688: x_return_status OUT NOCOPY VARCHAR2,
689: x_msg_count OUT NOCOPY NUMBER,
690: x_msg_data OUT NOCOPY VARCHAR2,

Line 718: IF FND_API.to_boolean(p_init_msg_list) THEN

714:
715: AMS_Utility_PVT.debug_message(l_full_name||': start');
716: END IF;
717:
718: IF FND_API.to_boolean(p_init_msg_list) THEN
719: FND_MSG_PUB.initialize;
720: END IF;
721:
722: IF NOT FND_API.compatible_api_call(

Line 722: IF NOT FND_API.compatible_api_call(

718: IF FND_API.to_boolean(p_init_msg_list) THEN
719: FND_MSG_PUB.initialize;
720: END IF;
721:
722: IF NOT FND_API.compatible_api_call(
723: l_api_version,
724: p_api_version,
725: l_api_name,
726: g_pkg_name

Line 728: RAISE FND_API.g_exc_unexpected_error;

724: p_api_version,
725: l_api_name,
726: g_pkg_name
727: ) THEN
728: RAISE FND_API.g_exc_unexpected_error;
729: END IF;
730:
731: x_return_status := FND_API.G_RET_STS_SUCCESS;
732:

Line 731: x_return_status := FND_API.G_RET_STS_SUCCESS;

727: ) THEN
728: RAISE FND_API.g_exc_unexpected_error;
729: END IF;
730:
731: x_return_status := FND_API.G_RET_STS_SUCCESS;
732:
733: ------------------------ lock -------------------------
734: IF (AMS_DEBUG_HIGH_ON) THEN
735:

Line 747: RAISE FND_API.g_exc_error;

743: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
744: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
745: FND_MSG_PUB.add;
746: END IF;
747: RAISE FND_API.g_exc_error;
748: END IF;
749: CLOSE c_act_partner;
750:
751: -------------------- finish --------------------------

Line 753: p_encoded => FND_API.g_false,

749: CLOSE c_act_partner;
750:
751: -------------------- finish --------------------------
752: FND_MSG_PUB.count_and_get(
753: p_encoded => FND_API.g_false,
754: p_count => x_msg_count,
755: p_data => x_msg_data
756: );
757:

Line 769: x_return_status := FND_API.g_ret_sts_error;

765:
766: EXCEPTION
767:
768: WHEN AMS_Utility_PVT.resource_locked THEN
769: x_return_status := FND_API.g_ret_sts_error;
770: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
771: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
772: FND_MSG_PUB.add;
773: END IF;

Line 776: p_encoded => FND_API.g_false,

772: FND_MSG_PUB.add;
773: END IF;
774:
775: FND_MSG_PUB.count_and_get(
776: p_encoded => FND_API.g_false,
777: p_count => x_msg_count,
778: p_data => x_msg_data
779: );
780:

Line 781: WHEN FND_API.g_exc_error THEN

777: p_count => x_msg_count,
778: p_data => x_msg_data
779: );
780:
781: WHEN FND_API.g_exc_error THEN
782: x_return_status := FND_API.g_ret_sts_error;
783: FND_MSG_PUB.count_and_get(
784: p_encoded => FND_API.g_false,
785: p_count => x_msg_count,

Line 782: x_return_status := FND_API.g_ret_sts_error;

778: p_data => x_msg_data
779: );
780:
781: WHEN FND_API.g_exc_error THEN
782: x_return_status := FND_API.g_ret_sts_error;
783: FND_MSG_PUB.count_and_get(
784: p_encoded => FND_API.g_false,
785: p_count => x_msg_count,
786: p_data => x_msg_data

Line 784: p_encoded => FND_API.g_false,

780:
781: WHEN FND_API.g_exc_error THEN
782: x_return_status := FND_API.g_ret_sts_error;
783: FND_MSG_PUB.count_and_get(
784: p_encoded => FND_API.g_false,
785: p_count => x_msg_count,
786: p_data => x_msg_data
787: );
788:

Line 789: WHEN FND_API.g_exc_unexpected_error THEN

785: p_count => x_msg_count,
786: p_data => x_msg_data
787: );
788:
789: WHEN FND_API.g_exc_unexpected_error THEN
790: x_return_status := FND_API.g_ret_sts_unexp_error ;
791: FND_MSG_PUB.count_and_get(
792: p_encoded => FND_API.g_false,
793: p_count => x_msg_count,

Line 790: x_return_status := FND_API.g_ret_sts_unexp_error ;

786: p_data => x_msg_data
787: );
788:
789: WHEN FND_API.g_exc_unexpected_error THEN
790: x_return_status := FND_API.g_ret_sts_unexp_error ;
791: FND_MSG_PUB.count_and_get(
792: p_encoded => FND_API.g_false,
793: p_count => x_msg_count,
794: p_data => x_msg_data

Line 792: p_encoded => FND_API.g_false,

788:
789: WHEN FND_API.g_exc_unexpected_error THEN
790: x_return_status := FND_API.g_ret_sts_unexp_error ;
791: FND_MSG_PUB.count_and_get(
792: p_encoded => FND_API.g_false,
793: p_count => x_msg_count,
794: p_data => x_msg_data
795: );
796:

Line 798: x_return_status := FND_API.g_ret_sts_unexp_error ;

794: p_data => x_msg_data
795: );
796:
797: WHEN OTHERS THEN
798: x_return_status := FND_API.g_ret_sts_unexp_error ;
799: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
800: THEN
801: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
802: END IF;

Line 805: p_encoded => FND_API.g_false,

801: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
802: END IF;
803:
804: FND_MSG_PUB.count_and_get(
805: p_encoded => FND_API.g_false,
806: p_count => x_msg_count,
807: p_data => x_msg_data
808: );
809:

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

821:
822: PROCEDURE validate_act_partner
823: (
824: p_api_version IN NUMBER,
825: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
826: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
827:
828: x_return_status OUT NOCOPY VARCHAR2,
829: x_msg_count OUT NOCOPY NUMBER,

Line 826: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

822: PROCEDURE validate_act_partner
823: (
824: p_api_version IN NUMBER,
825: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
826: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
827:
828: x_return_status OUT NOCOPY VARCHAR2,
829: x_msg_count OUT NOCOPY NUMBER,
830: x_msg_data OUT NOCOPY VARCHAR2,

Line 849: IF FND_API.to_boolean(p_init_msg_list) THEN

845:
846: AMS_Utility_PVT.debug_message(l_full_name||': start');
847: END IF;
848:
849: IF FND_API.to_boolean(p_init_msg_list) THEN
850: FND_MSG_PUB.initialize;
851: END IF;
852:
853: IF NOT FND_API.compatible_api_call(

Line 853: IF NOT FND_API.compatible_api_call(

849: IF FND_API.to_boolean(p_init_msg_list) THEN
850: FND_MSG_PUB.initialize;
851: END IF;
852:
853: IF NOT FND_API.compatible_api_call(
854: l_api_version,
855: p_api_version,
856: l_api_name,
857: g_pkg_name

Line 859: RAISE FND_API.g_exc_unexpected_error;

855: p_api_version,
856: l_api_name,
857: g_pkg_name
858: ) THEN
859: RAISE FND_API.g_exc_unexpected_error;
860: END IF;
861:
862: x_return_status := FND_API.g_ret_sts_success;
863:

Line 862: x_return_status := FND_API.g_ret_sts_success;

858: ) THEN
859: RAISE FND_API.g_exc_unexpected_error;
860: END IF;
861:
862: x_return_status := FND_API.g_ret_sts_success;
863:
864: ---------------------- validate ------------------------
865: IF (AMS_DEBUG_HIGH_ON) THEN
866:

Line 877: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

873: p_validation_mode => JTF_PLSQL_API.g_create,
874: x_return_status => l_return_status
875: );
876:
877: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
878: RAISE FND_API.g_exc_unexpected_error;
879: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
880: RAISE FND_API.g_exc_error;
881: END IF;

Line 878: RAISE FND_API.g_exc_unexpected_error;

874: x_return_status => l_return_status
875: );
876:
877: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
878: RAISE FND_API.g_exc_unexpected_error;
879: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
880: RAISE FND_API.g_exc_error;
881: END IF;
882: END IF;

Line 879: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

875: );
876:
877: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
878: RAISE FND_API.g_exc_unexpected_error;
879: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
880: RAISE FND_API.g_exc_error;
881: END IF;
882: END IF;
883:

Line 880: RAISE FND_API.g_exc_error;

876:
877: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
878: RAISE FND_API.g_exc_unexpected_error;
879: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
880: RAISE FND_API.g_exc_error;
881: END IF;
882: END IF;
883:
884: IF (AMS_DEBUG_HIGH_ON) THEN

Line 899: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

895: p_complete_rec => NULL,
896: x_return_status => l_return_status
897: );
898:
899: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
900: RAISE FND_API.g_exc_unexpected_error;
901: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
902: RAISE FND_API.g_exc_error;
903: END IF;

Line 900: RAISE FND_API.g_exc_unexpected_error;

896: x_return_status => l_return_status
897: );
898:
899: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
900: RAISE FND_API.g_exc_unexpected_error;
901: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
902: RAISE FND_API.g_exc_error;
903: END IF;
904: END IF;

Line 901: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

897: );
898:
899: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
900: RAISE FND_API.g_exc_unexpected_error;
901: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
902: RAISE FND_API.g_exc_error;
903: END IF;
904: END IF;
905:

Line 902: RAISE FND_API.g_exc_error;

898:
899: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
900: RAISE FND_API.g_exc_unexpected_error;
901: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
902: RAISE FND_API.g_exc_error;
903: END IF;
904: END IF;
905:
906: -------------------- finish --------------------------

Line 908: p_encoded => FND_API.g_false,

904: END IF;
905:
906: -------------------- finish --------------------------
907: FND_MSG_PUB.count_and_get(
908: p_encoded => FND_API.g_false,
909: p_count => x_msg_count,
910: p_data => x_msg_data
911: );
912:

Line 923: WHEN FND_API.g_exc_error THEN

919: END IF;
920:
921: EXCEPTION
922:
923: WHEN FND_API.g_exc_error THEN
924: x_return_status := FND_API.g_ret_sts_error;
925: FND_MSG_PUB.count_and_get(
926: p_encoded => FND_API.g_false,
927: p_count => x_msg_count,

Line 924: x_return_status := FND_API.g_ret_sts_error;

920:
921: EXCEPTION
922:
923: WHEN FND_API.g_exc_error THEN
924: x_return_status := FND_API.g_ret_sts_error;
925: FND_MSG_PUB.count_and_get(
926: p_encoded => FND_API.g_false,
927: p_count => x_msg_count,
928: p_data => x_msg_data

Line 926: p_encoded => FND_API.g_false,

922:
923: WHEN FND_API.g_exc_error THEN
924: x_return_status := FND_API.g_ret_sts_error;
925: FND_MSG_PUB.count_and_get(
926: p_encoded => FND_API.g_false,
927: p_count => x_msg_count,
928: p_data => x_msg_data
929: );
930:

Line 931: WHEN FND_API.g_exc_unexpected_error THEN

927: p_count => x_msg_count,
928: p_data => x_msg_data
929: );
930:
931: WHEN FND_API.g_exc_unexpected_error THEN
932: x_return_status := FND_API.g_ret_sts_unexp_error ;
933: FND_MSG_PUB.count_and_get(
934: p_encoded => FND_API.g_false,
935: p_count => x_msg_count,

Line 932: x_return_status := FND_API.g_ret_sts_unexp_error ;

928: p_data => x_msg_data
929: );
930:
931: WHEN FND_API.g_exc_unexpected_error THEN
932: x_return_status := FND_API.g_ret_sts_unexp_error ;
933: FND_MSG_PUB.count_and_get(
934: p_encoded => FND_API.g_false,
935: p_count => x_msg_count,
936: p_data => x_msg_data

Line 934: p_encoded => FND_API.g_false,

930:
931: WHEN FND_API.g_exc_unexpected_error THEN
932: x_return_status := FND_API.g_ret_sts_unexp_error ;
933: FND_MSG_PUB.count_and_get(
934: p_encoded => FND_API.g_false,
935: p_count => x_msg_count,
936: p_data => x_msg_data
937: );
938:

Line 940: x_return_status := FND_API.g_ret_sts_unexp_error;

936: p_data => x_msg_data
937: );
938:
939: WHEN OTHERS THEN
940: x_return_status := FND_API.g_ret_sts_unexp_error;
941: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
942: THEN
943: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
944: END IF;

Line 947: p_encoded => FND_API.g_false,

943: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
944: END IF;
945:
946: FND_MSG_PUB.count_and_get(
947: p_encoded => FND_API.g_false,
948: p_count => x_msg_count,
949: p_data => x_msg_data
950: );
951:

Line 969: x_return_status := FND_API.g_ret_sts_success;

965: )
966: IS
967: BEGIN
968:
969: x_return_status := FND_API.g_ret_sts_success;
970:
971: -------------------- put required items here ---------------------
972:
973: IF p_act_partner_rec.act_partner_used_by_id IS NULL THEN

Line 979: RAISE FND_API.g_exc_unexpected_error;

975: THEN
976: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PARTNER_NO_USEDBY_ID');
977: FND_MSG_PUB.add;
978: END IF;
979: RAISE FND_API.g_exc_unexpected_error;
980:
981: x_return_status := FND_API.g_ret_sts_error;
982: END IF;
983:

Line 981: x_return_status := FND_API.g_ret_sts_error;

977: FND_MSG_PUB.add;
978: END IF;
979: RAISE FND_API.g_exc_unexpected_error;
980:
981: x_return_status := FND_API.g_ret_sts_error;
982: END IF;
983:
984: IF p_act_partner_rec.arc_act_partner_used_by IS NULL THEN
985: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 990: RAISE FND_API.g_exc_unexpected_error;

986: THEN
987: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PARTNER_NO_USEDBY');
988: FND_MSG_PUB.add;
989: END IF;
990: RAISE FND_API.g_exc_unexpected_error;
991: x_return_status := FND_API.g_ret_sts_error;
992: RETURN;
993: END IF;
994:

Line 991: x_return_status := FND_API.g_ret_sts_error;

987: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PARTNER_NO_USEDBY');
988: FND_MSG_PUB.add;
989: END IF;
990: RAISE FND_API.g_exc_unexpected_error;
991: x_return_status := FND_API.g_ret_sts_error;
992: RETURN;
993: END IF;
994:
995: IF p_act_partner_rec.partner_id IS NULL THEN

Line 1001: RAISE FND_API.g_exc_unexpected_error;

997: THEN
998: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PARTNER_NO_PARTNER_ID');
999: FND_MSG_PUB.add;
1000: END IF;
1001: RAISE FND_API.g_exc_unexpected_error;
1002: x_return_status := FND_API.g_ret_sts_error;
1003: RETURN;
1004: END IF;
1005:

Line 1002: x_return_status := FND_API.g_ret_sts_error;

998: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PARTNER_NO_PARTNER_ID');
999: FND_MSG_PUB.add;
1000: END IF;
1001: RAISE FND_API.g_exc_unexpected_error;
1002: x_return_status := FND_API.g_ret_sts_error;
1003: RETURN;
1004: END IF;
1005:
1006: END check_act_partner_req_items;

Line 1033: IF x_return_status <> FND_API.g_ret_sts_success THEN

1029: p_act_partner_rec => p_act_partner_rec,
1030: x_return_status => x_return_status
1031: );
1032:
1033: IF x_return_status <> FND_API.g_ret_sts_success THEN
1034: RETURN;
1035: END IF;
1036:
1037: check_act_partner_uk_items (

Line 1041: IF x_return_status <> FND_API.g_ret_sts_success THEN

1037: check_act_partner_uk_items (
1038: p_act_partner_rec => p_act_partner_rec,
1039: x_return_status => x_return_status
1040: );
1041: IF x_return_status <> FND_API.g_ret_sts_success THEN
1042: RETURN;
1043: END IF;
1044: END check_act_partner_items;
1045:

Line 1065: x_return_status := FND_API.g_ret_sts_success;

1061: IS
1062:
1063: BEGIN
1064:
1065: x_return_status := FND_API.g_ret_sts_success;
1066:
1067: -- do other record level checkings
1068:
1069: END check_act_partner_record;

Line 1088: x_act_partner_rec.activity_partner_id := FND_API.g_miss_num;

1084: IS
1085:
1086: BEGIN
1087:
1088: x_act_partner_rec.activity_partner_id := FND_API.g_miss_num;
1089: x_act_partner_rec.last_update_date := FND_API.g_miss_date;
1090: x_act_partner_rec.last_updated_by := FND_API.g_miss_num;
1091: x_act_partner_rec.creation_date := FND_API.g_miss_date;
1092: x_act_partner_rec.created_by := FND_API.g_miss_num;

Line 1089: x_act_partner_rec.last_update_date := FND_API.g_miss_date;

1085:
1086: BEGIN
1087:
1088: x_act_partner_rec.activity_partner_id := FND_API.g_miss_num;
1089: x_act_partner_rec.last_update_date := FND_API.g_miss_date;
1090: x_act_partner_rec.last_updated_by := FND_API.g_miss_num;
1091: x_act_partner_rec.creation_date := FND_API.g_miss_date;
1092: x_act_partner_rec.created_by := FND_API.g_miss_num;
1093: x_act_partner_rec.last_update_login := FND_API.g_miss_num;

Line 1090: x_act_partner_rec.last_updated_by := FND_API.g_miss_num;

1086: BEGIN
1087:
1088: x_act_partner_rec.activity_partner_id := FND_API.g_miss_num;
1089: x_act_partner_rec.last_update_date := FND_API.g_miss_date;
1090: x_act_partner_rec.last_updated_by := FND_API.g_miss_num;
1091: x_act_partner_rec.creation_date := FND_API.g_miss_date;
1092: x_act_partner_rec.created_by := FND_API.g_miss_num;
1093: x_act_partner_rec.last_update_login := FND_API.g_miss_num;
1094: x_act_partner_rec.object_version_number := FND_API.g_miss_num;

Line 1091: x_act_partner_rec.creation_date := FND_API.g_miss_date;

1087:
1088: x_act_partner_rec.activity_partner_id := FND_API.g_miss_num;
1089: x_act_partner_rec.last_update_date := FND_API.g_miss_date;
1090: x_act_partner_rec.last_updated_by := FND_API.g_miss_num;
1091: x_act_partner_rec.creation_date := FND_API.g_miss_date;
1092: x_act_partner_rec.created_by := FND_API.g_miss_num;
1093: x_act_partner_rec.last_update_login := FND_API.g_miss_num;
1094: x_act_partner_rec.object_version_number := FND_API.g_miss_num;
1095: x_act_partner_rec.act_partner_used_by_id := FND_API.g_miss_num;

Line 1092: x_act_partner_rec.created_by := FND_API.g_miss_num;

1088: x_act_partner_rec.activity_partner_id := FND_API.g_miss_num;
1089: x_act_partner_rec.last_update_date := FND_API.g_miss_date;
1090: x_act_partner_rec.last_updated_by := FND_API.g_miss_num;
1091: x_act_partner_rec.creation_date := FND_API.g_miss_date;
1092: x_act_partner_rec.created_by := FND_API.g_miss_num;
1093: x_act_partner_rec.last_update_login := FND_API.g_miss_num;
1094: x_act_partner_rec.object_version_number := FND_API.g_miss_num;
1095: x_act_partner_rec.act_partner_used_by_id := FND_API.g_miss_num;
1096: x_act_partner_rec.arc_act_partner_used_by := FND_API.g_miss_char;

Line 1093: x_act_partner_rec.last_update_login := FND_API.g_miss_num;

1089: x_act_partner_rec.last_update_date := FND_API.g_miss_date;
1090: x_act_partner_rec.last_updated_by := FND_API.g_miss_num;
1091: x_act_partner_rec.creation_date := FND_API.g_miss_date;
1092: x_act_partner_rec.created_by := FND_API.g_miss_num;
1093: x_act_partner_rec.last_update_login := FND_API.g_miss_num;
1094: x_act_partner_rec.object_version_number := FND_API.g_miss_num;
1095: x_act_partner_rec.act_partner_used_by_id := FND_API.g_miss_num;
1096: x_act_partner_rec.arc_act_partner_used_by := FND_API.g_miss_char;
1097: x_act_partner_rec.partner_id := FND_API.g_miss_num;

Line 1094: x_act_partner_rec.object_version_number := FND_API.g_miss_num;

1090: x_act_partner_rec.last_updated_by := FND_API.g_miss_num;
1091: x_act_partner_rec.creation_date := FND_API.g_miss_date;
1092: x_act_partner_rec.created_by := FND_API.g_miss_num;
1093: x_act_partner_rec.last_update_login := FND_API.g_miss_num;
1094: x_act_partner_rec.object_version_number := FND_API.g_miss_num;
1095: x_act_partner_rec.act_partner_used_by_id := FND_API.g_miss_num;
1096: x_act_partner_rec.arc_act_partner_used_by := FND_API.g_miss_char;
1097: x_act_partner_rec.partner_id := FND_API.g_miss_num;
1098: x_act_partner_rec.primary_flag := FND_API.g_miss_char;

Line 1095: x_act_partner_rec.act_partner_used_by_id := FND_API.g_miss_num;

1091: x_act_partner_rec.creation_date := FND_API.g_miss_date;
1092: x_act_partner_rec.created_by := FND_API.g_miss_num;
1093: x_act_partner_rec.last_update_login := FND_API.g_miss_num;
1094: x_act_partner_rec.object_version_number := FND_API.g_miss_num;
1095: x_act_partner_rec.act_partner_used_by_id := FND_API.g_miss_num;
1096: x_act_partner_rec.arc_act_partner_used_by := FND_API.g_miss_char;
1097: x_act_partner_rec.partner_id := FND_API.g_miss_num;
1098: x_act_partner_rec.primary_flag := FND_API.g_miss_char;
1099: x_act_partner_rec.partner_type := FND_API.g_miss_char;

Line 1096: x_act_partner_rec.arc_act_partner_used_by := FND_API.g_miss_char;

1092: x_act_partner_rec.created_by := FND_API.g_miss_num;
1093: x_act_partner_rec.last_update_login := FND_API.g_miss_num;
1094: x_act_partner_rec.object_version_number := FND_API.g_miss_num;
1095: x_act_partner_rec.act_partner_used_by_id := FND_API.g_miss_num;
1096: x_act_partner_rec.arc_act_partner_used_by := FND_API.g_miss_char;
1097: x_act_partner_rec.partner_id := FND_API.g_miss_num;
1098: x_act_partner_rec.primary_flag := FND_API.g_miss_char;
1099: x_act_partner_rec.partner_type := FND_API.g_miss_char;
1100: x_act_partner_rec.description := FND_API.g_miss_char;

Line 1097: x_act_partner_rec.partner_id := FND_API.g_miss_num;

1093: x_act_partner_rec.last_update_login := FND_API.g_miss_num;
1094: x_act_partner_rec.object_version_number := FND_API.g_miss_num;
1095: x_act_partner_rec.act_partner_used_by_id := FND_API.g_miss_num;
1096: x_act_partner_rec.arc_act_partner_used_by := FND_API.g_miss_char;
1097: x_act_partner_rec.partner_id := FND_API.g_miss_num;
1098: x_act_partner_rec.primary_flag := FND_API.g_miss_char;
1099: x_act_partner_rec.partner_type := FND_API.g_miss_char;
1100: x_act_partner_rec.description := FND_API.g_miss_char;
1101: x_act_partner_rec.attribute_category := FND_API.g_miss_char;

Line 1098: x_act_partner_rec.primary_flag := FND_API.g_miss_char;

1094: x_act_partner_rec.object_version_number := FND_API.g_miss_num;
1095: x_act_partner_rec.act_partner_used_by_id := FND_API.g_miss_num;
1096: x_act_partner_rec.arc_act_partner_used_by := FND_API.g_miss_char;
1097: x_act_partner_rec.partner_id := FND_API.g_miss_num;
1098: x_act_partner_rec.primary_flag := FND_API.g_miss_char;
1099: x_act_partner_rec.partner_type := FND_API.g_miss_char;
1100: x_act_partner_rec.description := FND_API.g_miss_char;
1101: x_act_partner_rec.attribute_category := FND_API.g_miss_char;
1102: x_act_partner_rec.preferred_vad_id := FND_API.g_miss_num;

Line 1099: x_act_partner_rec.partner_type := FND_API.g_miss_char;

1095: x_act_partner_rec.act_partner_used_by_id := FND_API.g_miss_num;
1096: x_act_partner_rec.arc_act_partner_used_by := FND_API.g_miss_char;
1097: x_act_partner_rec.partner_id := FND_API.g_miss_num;
1098: x_act_partner_rec.primary_flag := FND_API.g_miss_char;
1099: x_act_partner_rec.partner_type := FND_API.g_miss_char;
1100: x_act_partner_rec.description := FND_API.g_miss_char;
1101: x_act_partner_rec.attribute_category := FND_API.g_miss_char;
1102: x_act_partner_rec.preferred_vad_id := FND_API.g_miss_num;
1103: x_act_partner_rec.partner_address_id := FND_API.g_miss_num;

Line 1100: x_act_partner_rec.description := FND_API.g_miss_char;

1096: x_act_partner_rec.arc_act_partner_used_by := FND_API.g_miss_char;
1097: x_act_partner_rec.partner_id := FND_API.g_miss_num;
1098: x_act_partner_rec.primary_flag := FND_API.g_miss_char;
1099: x_act_partner_rec.partner_type := FND_API.g_miss_char;
1100: x_act_partner_rec.description := FND_API.g_miss_char;
1101: x_act_partner_rec.attribute_category := FND_API.g_miss_char;
1102: x_act_partner_rec.preferred_vad_id := FND_API.g_miss_num;
1103: x_act_partner_rec.partner_address_id := FND_API.g_miss_num;
1104: x_act_partner_rec.primary_contact_id := FND_API.g_miss_num;

Line 1101: x_act_partner_rec.attribute_category := FND_API.g_miss_char;

1097: x_act_partner_rec.partner_id := FND_API.g_miss_num;
1098: x_act_partner_rec.primary_flag := FND_API.g_miss_char;
1099: x_act_partner_rec.partner_type := FND_API.g_miss_char;
1100: x_act_partner_rec.description := FND_API.g_miss_char;
1101: x_act_partner_rec.attribute_category := FND_API.g_miss_char;
1102: x_act_partner_rec.preferred_vad_id := FND_API.g_miss_num;
1103: x_act_partner_rec.partner_address_id := FND_API.g_miss_num;
1104: x_act_partner_rec.primary_contact_id := FND_API.g_miss_num;
1105: x_act_partner_rec.attribute1 := FND_API.g_miss_char;

Line 1102: x_act_partner_rec.preferred_vad_id := FND_API.g_miss_num;

1098: x_act_partner_rec.primary_flag := FND_API.g_miss_char;
1099: x_act_partner_rec.partner_type := FND_API.g_miss_char;
1100: x_act_partner_rec.description := FND_API.g_miss_char;
1101: x_act_partner_rec.attribute_category := FND_API.g_miss_char;
1102: x_act_partner_rec.preferred_vad_id := FND_API.g_miss_num;
1103: x_act_partner_rec.partner_address_id := FND_API.g_miss_num;
1104: x_act_partner_rec.primary_contact_id := FND_API.g_miss_num;
1105: x_act_partner_rec.attribute1 := FND_API.g_miss_char;
1106: x_act_partner_rec.attribute2 := FND_API.g_miss_char;

Line 1103: x_act_partner_rec.partner_address_id := FND_API.g_miss_num;

1099: x_act_partner_rec.partner_type := FND_API.g_miss_char;
1100: x_act_partner_rec.description := FND_API.g_miss_char;
1101: x_act_partner_rec.attribute_category := FND_API.g_miss_char;
1102: x_act_partner_rec.preferred_vad_id := FND_API.g_miss_num;
1103: x_act_partner_rec.partner_address_id := FND_API.g_miss_num;
1104: x_act_partner_rec.primary_contact_id := FND_API.g_miss_num;
1105: x_act_partner_rec.attribute1 := FND_API.g_miss_char;
1106: x_act_partner_rec.attribute2 := FND_API.g_miss_char;
1107: x_act_partner_rec.attribute3 := FND_API.g_miss_char;

Line 1104: x_act_partner_rec.primary_contact_id := FND_API.g_miss_num;

1100: x_act_partner_rec.description := FND_API.g_miss_char;
1101: x_act_partner_rec.attribute_category := FND_API.g_miss_char;
1102: x_act_partner_rec.preferred_vad_id := FND_API.g_miss_num;
1103: x_act_partner_rec.partner_address_id := FND_API.g_miss_num;
1104: x_act_partner_rec.primary_contact_id := FND_API.g_miss_num;
1105: x_act_partner_rec.attribute1 := FND_API.g_miss_char;
1106: x_act_partner_rec.attribute2 := FND_API.g_miss_char;
1107: x_act_partner_rec.attribute3 := FND_API.g_miss_char;
1108: x_act_partner_rec.attribute4 := FND_API.g_miss_char;

Line 1105: x_act_partner_rec.attribute1 := FND_API.g_miss_char;

1101: x_act_partner_rec.attribute_category := FND_API.g_miss_char;
1102: x_act_partner_rec.preferred_vad_id := FND_API.g_miss_num;
1103: x_act_partner_rec.partner_address_id := FND_API.g_miss_num;
1104: x_act_partner_rec.primary_contact_id := FND_API.g_miss_num;
1105: x_act_partner_rec.attribute1 := FND_API.g_miss_char;
1106: x_act_partner_rec.attribute2 := FND_API.g_miss_char;
1107: x_act_partner_rec.attribute3 := FND_API.g_miss_char;
1108: x_act_partner_rec.attribute4 := FND_API.g_miss_char;
1109: x_act_partner_rec.attribute5 := FND_API.g_miss_char;

Line 1106: x_act_partner_rec.attribute2 := FND_API.g_miss_char;

1102: x_act_partner_rec.preferred_vad_id := FND_API.g_miss_num;
1103: x_act_partner_rec.partner_address_id := FND_API.g_miss_num;
1104: x_act_partner_rec.primary_contact_id := FND_API.g_miss_num;
1105: x_act_partner_rec.attribute1 := FND_API.g_miss_char;
1106: x_act_partner_rec.attribute2 := FND_API.g_miss_char;
1107: x_act_partner_rec.attribute3 := FND_API.g_miss_char;
1108: x_act_partner_rec.attribute4 := FND_API.g_miss_char;
1109: x_act_partner_rec.attribute5 := FND_API.g_miss_char;
1110: x_act_partner_rec.attribute6 := FND_API.g_miss_char;

Line 1107: x_act_partner_rec.attribute3 := FND_API.g_miss_char;

1103: x_act_partner_rec.partner_address_id := FND_API.g_miss_num;
1104: x_act_partner_rec.primary_contact_id := FND_API.g_miss_num;
1105: x_act_partner_rec.attribute1 := FND_API.g_miss_char;
1106: x_act_partner_rec.attribute2 := FND_API.g_miss_char;
1107: x_act_partner_rec.attribute3 := FND_API.g_miss_char;
1108: x_act_partner_rec.attribute4 := FND_API.g_miss_char;
1109: x_act_partner_rec.attribute5 := FND_API.g_miss_char;
1110: x_act_partner_rec.attribute6 := FND_API.g_miss_char;
1111: x_act_partner_rec.attribute7 := FND_API.g_miss_char;

Line 1108: x_act_partner_rec.attribute4 := FND_API.g_miss_char;

1104: x_act_partner_rec.primary_contact_id := FND_API.g_miss_num;
1105: x_act_partner_rec.attribute1 := FND_API.g_miss_char;
1106: x_act_partner_rec.attribute2 := FND_API.g_miss_char;
1107: x_act_partner_rec.attribute3 := FND_API.g_miss_char;
1108: x_act_partner_rec.attribute4 := FND_API.g_miss_char;
1109: x_act_partner_rec.attribute5 := FND_API.g_miss_char;
1110: x_act_partner_rec.attribute6 := FND_API.g_miss_char;
1111: x_act_partner_rec.attribute7 := FND_API.g_miss_char;
1112: x_act_partner_rec.attribute8 := FND_API.g_miss_char;

Line 1109: x_act_partner_rec.attribute5 := FND_API.g_miss_char;

1105: x_act_partner_rec.attribute1 := FND_API.g_miss_char;
1106: x_act_partner_rec.attribute2 := FND_API.g_miss_char;
1107: x_act_partner_rec.attribute3 := FND_API.g_miss_char;
1108: x_act_partner_rec.attribute4 := FND_API.g_miss_char;
1109: x_act_partner_rec.attribute5 := FND_API.g_miss_char;
1110: x_act_partner_rec.attribute6 := FND_API.g_miss_char;
1111: x_act_partner_rec.attribute7 := FND_API.g_miss_char;
1112: x_act_partner_rec.attribute8 := FND_API.g_miss_char;
1113: x_act_partner_rec.attribute9 := FND_API.g_miss_char;

Line 1110: x_act_partner_rec.attribute6 := FND_API.g_miss_char;

1106: x_act_partner_rec.attribute2 := FND_API.g_miss_char;
1107: x_act_partner_rec.attribute3 := FND_API.g_miss_char;
1108: x_act_partner_rec.attribute4 := FND_API.g_miss_char;
1109: x_act_partner_rec.attribute5 := FND_API.g_miss_char;
1110: x_act_partner_rec.attribute6 := FND_API.g_miss_char;
1111: x_act_partner_rec.attribute7 := FND_API.g_miss_char;
1112: x_act_partner_rec.attribute8 := FND_API.g_miss_char;
1113: x_act_partner_rec.attribute9 := FND_API.g_miss_char;
1114: x_act_partner_rec.attribute10 := FND_API.g_miss_char;

Line 1111: x_act_partner_rec.attribute7 := FND_API.g_miss_char;

1107: x_act_partner_rec.attribute3 := FND_API.g_miss_char;
1108: x_act_partner_rec.attribute4 := FND_API.g_miss_char;
1109: x_act_partner_rec.attribute5 := FND_API.g_miss_char;
1110: x_act_partner_rec.attribute6 := FND_API.g_miss_char;
1111: x_act_partner_rec.attribute7 := FND_API.g_miss_char;
1112: x_act_partner_rec.attribute8 := FND_API.g_miss_char;
1113: x_act_partner_rec.attribute9 := FND_API.g_miss_char;
1114: x_act_partner_rec.attribute10 := FND_API.g_miss_char;
1115: x_act_partner_rec.attribute11 := FND_API.g_miss_char;

Line 1112: x_act_partner_rec.attribute8 := FND_API.g_miss_char;

1108: x_act_partner_rec.attribute4 := FND_API.g_miss_char;
1109: x_act_partner_rec.attribute5 := FND_API.g_miss_char;
1110: x_act_partner_rec.attribute6 := FND_API.g_miss_char;
1111: x_act_partner_rec.attribute7 := FND_API.g_miss_char;
1112: x_act_partner_rec.attribute8 := FND_API.g_miss_char;
1113: x_act_partner_rec.attribute9 := FND_API.g_miss_char;
1114: x_act_partner_rec.attribute10 := FND_API.g_miss_char;
1115: x_act_partner_rec.attribute11 := FND_API.g_miss_char;
1116: x_act_partner_rec.attribute12 := FND_API.g_miss_char;

Line 1113: x_act_partner_rec.attribute9 := FND_API.g_miss_char;

1109: x_act_partner_rec.attribute5 := FND_API.g_miss_char;
1110: x_act_partner_rec.attribute6 := FND_API.g_miss_char;
1111: x_act_partner_rec.attribute7 := FND_API.g_miss_char;
1112: x_act_partner_rec.attribute8 := FND_API.g_miss_char;
1113: x_act_partner_rec.attribute9 := FND_API.g_miss_char;
1114: x_act_partner_rec.attribute10 := FND_API.g_miss_char;
1115: x_act_partner_rec.attribute11 := FND_API.g_miss_char;
1116: x_act_partner_rec.attribute12 := FND_API.g_miss_char;
1117: x_act_partner_rec.attribute13 := FND_API.g_miss_char;

Line 1114: x_act_partner_rec.attribute10 := FND_API.g_miss_char;

1110: x_act_partner_rec.attribute6 := FND_API.g_miss_char;
1111: x_act_partner_rec.attribute7 := FND_API.g_miss_char;
1112: x_act_partner_rec.attribute8 := FND_API.g_miss_char;
1113: x_act_partner_rec.attribute9 := FND_API.g_miss_char;
1114: x_act_partner_rec.attribute10 := FND_API.g_miss_char;
1115: x_act_partner_rec.attribute11 := FND_API.g_miss_char;
1116: x_act_partner_rec.attribute12 := FND_API.g_miss_char;
1117: x_act_partner_rec.attribute13 := FND_API.g_miss_char;
1118: x_act_partner_rec.attribute14 := FND_API.g_miss_char;

Line 1115: x_act_partner_rec.attribute11 := FND_API.g_miss_char;

1111: x_act_partner_rec.attribute7 := FND_API.g_miss_char;
1112: x_act_partner_rec.attribute8 := FND_API.g_miss_char;
1113: x_act_partner_rec.attribute9 := FND_API.g_miss_char;
1114: x_act_partner_rec.attribute10 := FND_API.g_miss_char;
1115: x_act_partner_rec.attribute11 := FND_API.g_miss_char;
1116: x_act_partner_rec.attribute12 := FND_API.g_miss_char;
1117: x_act_partner_rec.attribute13 := FND_API.g_miss_char;
1118: x_act_partner_rec.attribute14 := FND_API.g_miss_char;
1119: x_act_partner_rec.attribute15 := FND_API.g_miss_char;

Line 1116: x_act_partner_rec.attribute12 := FND_API.g_miss_char;

1112: x_act_partner_rec.attribute8 := FND_API.g_miss_char;
1113: x_act_partner_rec.attribute9 := FND_API.g_miss_char;
1114: x_act_partner_rec.attribute10 := FND_API.g_miss_char;
1115: x_act_partner_rec.attribute11 := FND_API.g_miss_char;
1116: x_act_partner_rec.attribute12 := FND_API.g_miss_char;
1117: x_act_partner_rec.attribute13 := FND_API.g_miss_char;
1118: x_act_partner_rec.attribute14 := FND_API.g_miss_char;
1119: x_act_partner_rec.attribute15 := FND_API.g_miss_char;
1120:

Line 1117: x_act_partner_rec.attribute13 := FND_API.g_miss_char;

1113: x_act_partner_rec.attribute9 := FND_API.g_miss_char;
1114: x_act_partner_rec.attribute10 := FND_API.g_miss_char;
1115: x_act_partner_rec.attribute11 := FND_API.g_miss_char;
1116: x_act_partner_rec.attribute12 := FND_API.g_miss_char;
1117: x_act_partner_rec.attribute13 := FND_API.g_miss_char;
1118: x_act_partner_rec.attribute14 := FND_API.g_miss_char;
1119: x_act_partner_rec.attribute15 := FND_API.g_miss_char;
1120:
1121: END init_act_partner_rec;

Line 1118: x_act_partner_rec.attribute14 := FND_API.g_miss_char;

1114: x_act_partner_rec.attribute10 := FND_API.g_miss_char;
1115: x_act_partner_rec.attribute11 := FND_API.g_miss_char;
1116: x_act_partner_rec.attribute12 := FND_API.g_miss_char;
1117: x_act_partner_rec.attribute13 := FND_API.g_miss_char;
1118: x_act_partner_rec.attribute14 := FND_API.g_miss_char;
1119: x_act_partner_rec.attribute15 := FND_API.g_miss_char;
1120:
1121: END init_act_partner_rec;
1122:

Line 1119: x_act_partner_rec.attribute15 := FND_API.g_miss_char;

1115: x_act_partner_rec.attribute11 := FND_API.g_miss_char;
1116: x_act_partner_rec.attribute12 := FND_API.g_miss_char;
1117: x_act_partner_rec.attribute13 := FND_API.g_miss_char;
1118: x_act_partner_rec.attribute14 := FND_API.g_miss_char;
1119: x_act_partner_rec.attribute15 := FND_API.g_miss_char;
1120:
1121: END init_act_partner_rec;
1122:
1123: ---------------------------------------------------------------------

Line 1156: RAISE FND_API.g_exc_error;

1152: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1153: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1154: FND_MSG_PUB.add;
1155: END IF;
1156: RAISE FND_API.g_exc_error;
1157: END IF;
1158: --CLOSE c_act_partner;
1159: IF (AMS_DEBUG_HIGH_ON) THEN
1160:

Line 1164: IF p_act_partner_rec.act_partner_used_by_id = FND_API.g_miss_num THEN

1160:
1161: AMS_Utility_PVT.debug_message('end cursor...');
1162: END IF;
1163:
1164: IF p_act_partner_rec.act_partner_used_by_id = FND_API.g_miss_num THEN
1165: x_complete_rec.act_partner_used_by_id := l_act_partner_rec.act_partner_used_by_id;
1166: END IF;
1167:
1168: IF p_act_partner_rec.arc_act_partner_used_by = FND_API.g_miss_char THEN

Line 1168: IF p_act_partner_rec.arc_act_partner_used_by = FND_API.g_miss_char THEN

1164: IF p_act_partner_rec.act_partner_used_by_id = FND_API.g_miss_num THEN
1165: x_complete_rec.act_partner_used_by_id := l_act_partner_rec.act_partner_used_by_id;
1166: END IF;
1167:
1168: IF p_act_partner_rec.arc_act_partner_used_by = FND_API.g_miss_char THEN
1169: x_complete_rec.arc_act_partner_used_by := l_act_partner_rec.arc_act_partner_used_by;
1170: END IF;
1171:
1172: IF p_act_partner_rec.primary_flag = FND_API.g_miss_char THEN

Line 1172: IF p_act_partner_rec.primary_flag = FND_API.g_miss_char THEN

1168: IF p_act_partner_rec.arc_act_partner_used_by = FND_API.g_miss_char THEN
1169: x_complete_rec.arc_act_partner_used_by := l_act_partner_rec.arc_act_partner_used_by;
1170: END IF;
1171:
1172: IF p_act_partner_rec.primary_flag = FND_API.g_miss_char THEN
1173: x_complete_rec.primary_flag := l_act_partner_rec.primary_flag;
1174: END IF;
1175:
1176: IF p_act_partner_rec.partner_id = FND_API.g_miss_num THEN

Line 1176: IF p_act_partner_rec.partner_id = FND_API.g_miss_num THEN

1172: IF p_act_partner_rec.primary_flag = FND_API.g_miss_char THEN
1173: x_complete_rec.primary_flag := l_act_partner_rec.primary_flag;
1174: END IF;
1175:
1176: IF p_act_partner_rec.partner_id = FND_API.g_miss_num THEN
1177: x_complete_rec.partner_id := l_act_partner_rec.partner_id;
1178: END IF;
1179:
1180: IF p_act_partner_rec.partner_type = FND_API.g_miss_char THEN

Line 1180: IF p_act_partner_rec.partner_type = FND_API.g_miss_char THEN

1176: IF p_act_partner_rec.partner_id = FND_API.g_miss_num THEN
1177: x_complete_rec.partner_id := l_act_partner_rec.partner_id;
1178: END IF;
1179:
1180: IF p_act_partner_rec.partner_type = FND_API.g_miss_char THEN
1181: x_complete_rec.partner_type := l_act_partner_rec.partner_type;
1182: END IF;
1183:
1184: IF p_act_partner_rec.description = FND_API.g_miss_char THEN

Line 1184: IF p_act_partner_rec.description = FND_API.g_miss_char THEN

1180: IF p_act_partner_rec.partner_type = FND_API.g_miss_char THEN
1181: x_complete_rec.partner_type := l_act_partner_rec.partner_type;
1182: END IF;
1183:
1184: IF p_act_partner_rec.description = FND_API.g_miss_char THEN
1185: x_complete_rec.description := l_act_partner_rec.description;
1186: END IF;
1187:
1188: IF p_act_partner_rec.attribute_category = FND_API.g_miss_char THEN

Line 1188: IF p_act_partner_rec.attribute_category = FND_API.g_miss_char THEN

1184: IF p_act_partner_rec.description = FND_API.g_miss_char THEN
1185: x_complete_rec.description := l_act_partner_rec.description;
1186: END IF;
1187:
1188: IF p_act_partner_rec.attribute_category = FND_API.g_miss_char THEN
1189: x_complete_rec.attribute_category := l_act_partner_rec.attribute_category;
1190: END IF;
1191:
1192: IF p_act_partner_rec.preferred_vad_id = FND_API.g_miss_num THEN

Line 1192: IF p_act_partner_rec.preferred_vad_id = FND_API.g_miss_num THEN

1188: IF p_act_partner_rec.attribute_category = FND_API.g_miss_char THEN
1189: x_complete_rec.attribute_category := l_act_partner_rec.attribute_category;
1190: END IF;
1191:
1192: IF p_act_partner_rec.preferred_vad_id = FND_API.g_miss_num THEN
1193: x_complete_rec.preferred_vad_id := l_act_partner_rec.preferred_vad_id;
1194: END IF;
1195:
1196: IF p_act_partner_rec.partner_address_id = FND_API.g_miss_num THEN

Line 1196: IF p_act_partner_rec.partner_address_id = FND_API.g_miss_num THEN

1192: IF p_act_partner_rec.preferred_vad_id = FND_API.g_miss_num THEN
1193: x_complete_rec.preferred_vad_id := l_act_partner_rec.preferred_vad_id;
1194: END IF;
1195:
1196: IF p_act_partner_rec.partner_address_id = FND_API.g_miss_num THEN
1197: x_complete_rec.partner_address_id := l_act_partner_rec.partner_address_id;
1198: END IF;
1199:
1200: IF p_act_partner_rec.primary_contact_id = FND_API.g_miss_num THEN

Line 1200: IF p_act_partner_rec.primary_contact_id = FND_API.g_miss_num THEN

1196: IF p_act_partner_rec.partner_address_id = FND_API.g_miss_num THEN
1197: x_complete_rec.partner_address_id := l_act_partner_rec.partner_address_id;
1198: END IF;
1199:
1200: IF p_act_partner_rec.primary_contact_id = FND_API.g_miss_num THEN
1201: x_complete_rec.primary_contact_id := l_act_partner_rec.primary_contact_id;
1202: END IF;
1203:
1204: IF p_act_partner_rec.attribute1 = FND_API.g_miss_char THEN

Line 1204: IF p_act_partner_rec.attribute1 = FND_API.g_miss_char THEN

1200: IF p_act_partner_rec.primary_contact_id = FND_API.g_miss_num THEN
1201: x_complete_rec.primary_contact_id := l_act_partner_rec.primary_contact_id;
1202: END IF;
1203:
1204: IF p_act_partner_rec.attribute1 = FND_API.g_miss_char THEN
1205: x_complete_rec.attribute1 := l_act_partner_rec.attribute1;
1206: END IF;
1207:
1208: IF p_act_partner_rec.attribute2 = FND_API.g_miss_char THEN

Line 1208: IF p_act_partner_rec.attribute2 = FND_API.g_miss_char THEN

1204: IF p_act_partner_rec.attribute1 = FND_API.g_miss_char THEN
1205: x_complete_rec.attribute1 := l_act_partner_rec.attribute1;
1206: END IF;
1207:
1208: IF p_act_partner_rec.attribute2 = FND_API.g_miss_char THEN
1209: x_complete_rec.attribute2 := l_act_partner_rec.attribute2;
1210: END IF;
1211:
1212: IF p_act_partner_rec.attribute3 = FND_API.g_miss_char THEN

Line 1212: IF p_act_partner_rec.attribute3 = FND_API.g_miss_char THEN

1208: IF p_act_partner_rec.attribute2 = FND_API.g_miss_char THEN
1209: x_complete_rec.attribute2 := l_act_partner_rec.attribute2;
1210: END IF;
1211:
1212: IF p_act_partner_rec.attribute3 = FND_API.g_miss_char THEN
1213: x_complete_rec.attribute3 := l_act_partner_rec.attribute3;
1214: END IF;
1215:
1216: IF p_act_partner_rec.attribute4 = FND_API.g_miss_char THEN

Line 1216: IF p_act_partner_rec.attribute4 = FND_API.g_miss_char THEN

1212: IF p_act_partner_rec.attribute3 = FND_API.g_miss_char THEN
1213: x_complete_rec.attribute3 := l_act_partner_rec.attribute3;
1214: END IF;
1215:
1216: IF p_act_partner_rec.attribute4 = FND_API.g_miss_char THEN
1217: x_complete_rec.attribute4 := l_act_partner_rec.attribute4;
1218: END IF;
1219:
1220: IF p_act_partner_rec.attribute5 = FND_API.g_miss_char THEN

Line 1220: IF p_act_partner_rec.attribute5 = FND_API.g_miss_char THEN

1216: IF p_act_partner_rec.attribute4 = FND_API.g_miss_char THEN
1217: x_complete_rec.attribute4 := l_act_partner_rec.attribute4;
1218: END IF;
1219:
1220: IF p_act_partner_rec.attribute5 = FND_API.g_miss_char THEN
1221: x_complete_rec.attribute5 := l_act_partner_rec.attribute5;
1222: END IF;
1223:
1224: IF p_act_partner_rec.attribute6 = FND_API.g_miss_char THEN

Line 1224: IF p_act_partner_rec.attribute6 = FND_API.g_miss_char THEN

1220: IF p_act_partner_rec.attribute5 = FND_API.g_miss_char THEN
1221: x_complete_rec.attribute5 := l_act_partner_rec.attribute5;
1222: END IF;
1223:
1224: IF p_act_partner_rec.attribute6 = FND_API.g_miss_char THEN
1225: x_complete_rec.attribute6 := l_act_partner_rec.attribute6;
1226: END IF;
1227:
1228: IF p_act_partner_rec.attribute7 = FND_API.g_miss_char THEN

Line 1228: IF p_act_partner_rec.attribute7 = FND_API.g_miss_char THEN

1224: IF p_act_partner_rec.attribute6 = FND_API.g_miss_char THEN
1225: x_complete_rec.attribute6 := l_act_partner_rec.attribute6;
1226: END IF;
1227:
1228: IF p_act_partner_rec.attribute7 = FND_API.g_miss_char THEN
1229: x_complete_rec.attribute7 := l_act_partner_rec.attribute7;
1230: END IF;
1231:
1232: IF p_act_partner_rec.attribute8 = FND_API.g_miss_char THEN

Line 1232: IF p_act_partner_rec.attribute8 = FND_API.g_miss_char THEN

1228: IF p_act_partner_rec.attribute7 = FND_API.g_miss_char THEN
1229: x_complete_rec.attribute7 := l_act_partner_rec.attribute7;
1230: END IF;
1231:
1232: IF p_act_partner_rec.attribute8 = FND_API.g_miss_char THEN
1233: x_complete_rec.attribute8 := l_act_partner_rec.attribute8;
1234: END IF;
1235:
1236: IF p_act_partner_rec.attribute9 = FND_API.g_miss_char THEN

Line 1236: IF p_act_partner_rec.attribute9 = FND_API.g_miss_char THEN

1232: IF p_act_partner_rec.attribute8 = FND_API.g_miss_char THEN
1233: x_complete_rec.attribute8 := l_act_partner_rec.attribute8;
1234: END IF;
1235:
1236: IF p_act_partner_rec.attribute9 = FND_API.g_miss_char THEN
1237: x_complete_rec.attribute9 := l_act_partner_rec.attribute9;
1238: END IF;
1239:
1240: IF p_act_partner_rec.attribute10 = FND_API.g_miss_char THEN

Line 1240: IF p_act_partner_rec.attribute10 = FND_API.g_miss_char THEN

1236: IF p_act_partner_rec.attribute9 = FND_API.g_miss_char THEN
1237: x_complete_rec.attribute9 := l_act_partner_rec.attribute9;
1238: END IF;
1239:
1240: IF p_act_partner_rec.attribute10 = FND_API.g_miss_char THEN
1241: x_complete_rec.attribute10 := l_act_partner_rec.attribute10;
1242: END IF;
1243:
1244: IF p_act_partner_rec.attribute11 = FND_API.g_miss_char THEN

Line 1244: IF p_act_partner_rec.attribute11 = FND_API.g_miss_char THEN

1240: IF p_act_partner_rec.attribute10 = FND_API.g_miss_char THEN
1241: x_complete_rec.attribute10 := l_act_partner_rec.attribute10;
1242: END IF;
1243:
1244: IF p_act_partner_rec.attribute11 = FND_API.g_miss_char THEN
1245: x_complete_rec.attribute11 := l_act_partner_rec.attribute11;
1246: END IF;
1247:
1248: IF p_act_partner_rec.attribute12 = FND_API.g_miss_char THEN

Line 1248: IF p_act_partner_rec.attribute12 = FND_API.g_miss_char THEN

1244: IF p_act_partner_rec.attribute11 = FND_API.g_miss_char THEN
1245: x_complete_rec.attribute11 := l_act_partner_rec.attribute11;
1246: END IF;
1247:
1248: IF p_act_partner_rec.attribute12 = FND_API.g_miss_char THEN
1249: x_complete_rec.attribute12 := l_act_partner_rec.attribute12;
1250: END IF;
1251:
1252: IF p_act_partner_rec.attribute13 = FND_API.g_miss_char THEN

Line 1252: IF p_act_partner_rec.attribute13 = FND_API.g_miss_char THEN

1248: IF p_act_partner_rec.attribute12 = FND_API.g_miss_char THEN
1249: x_complete_rec.attribute12 := l_act_partner_rec.attribute12;
1250: END IF;
1251:
1252: IF p_act_partner_rec.attribute13 = FND_API.g_miss_char THEN
1253: x_complete_rec.attribute13 := l_act_partner_rec.attribute13;
1254: END IF;
1255:
1256: IF p_act_partner_rec.attribute14 = FND_API.g_miss_char THEN

Line 1256: IF p_act_partner_rec.attribute14 = FND_API.g_miss_char THEN

1252: IF p_act_partner_rec.attribute13 = FND_API.g_miss_char THEN
1253: x_complete_rec.attribute13 := l_act_partner_rec.attribute13;
1254: END IF;
1255:
1256: IF p_act_partner_rec.attribute14 = FND_API.g_miss_char THEN
1257: x_complete_rec.attribute14 := l_act_partner_rec.attribute14;
1258: END IF;
1259:
1260: IF p_act_partner_rec.attribute15 = FND_API.g_miss_char THEN

Line 1260: IF p_act_partner_rec.attribute15 = FND_API.g_miss_char THEN

1256: IF p_act_partner_rec.attribute14 = FND_API.g_miss_char THEN
1257: x_complete_rec.attribute14 := l_act_partner_rec.attribute14;
1258: END IF;
1259:
1260: IF p_act_partner_rec.attribute15 = FND_API.g_miss_char THEN
1261: x_complete_rec.attribute15 := l_act_partner_rec.attribute15;
1262: END IF;
1263: IF (AMS_DEBUG_HIGH_ON) THEN
1264:

Line 1323: x_return_status := FND_API.g_ret_sts_error;

1319: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1320: FND_MESSAGE.set_name('AMS', 'AMS_ACT_INVALID_PRIMARY');
1321: FND_MSG_PUB.add;
1322: END IF;
1323: x_return_status := FND_API.g_ret_sts_error;
1324: END IF;
1325: END check_primary;
1326:
1327: PROCEDURE check_act_partner_uk_items (

Line 1338: x_return_status := FND_API.g_ret_sts_success;

1334: SELECT partner_party_name
1335: FROM pv_partners_v
1336: WHERE partner_id = p_partner_id; -- instead of partner_party_id; anchaudh changed it to partner_id on 30 Apr-05.
1337: BEGIN
1338: x_return_status := FND_API.g_ret_sts_success;
1339:
1340: -- validate uniqueness of arc_used_by, arc_used_by_id, and partner_id
1341: IF AMS_Utility_PVT.check_uniqueness (
1342: 'AMS_ACT_PARTNERS',

Line 1346: ) = FND_API.g_false THEN

1342: 'AMS_ACT_PARTNERS',
1343: 'arc_act_partner_used_by = ' || p_act_partner_rec.arc_act_partner_used_by ||
1344: ' AND act_partner_used_by_id = ' || p_act_partner_rec.act_partner_used_by_id ||
1345: ' AND partner_id = ' || p_act_partner_rec.partner_id
1346: ) = FND_API.g_false THEN
1347: OPEN c_partner_name (p_act_partner_rec.partner_id);
1348: FETCH c_partner_name INTO l_partner_name;
1349: CLOSE c_partner_name;
1350: AMS_Utility_PVT.error_message ('AMS_ACTPART_DUP_ACTPARTNER', 'PARTNER_NAME', l_partner_name);

Line 1351: x_return_status := FND_API.g_ret_sts_error;

1347: OPEN c_partner_name (p_act_partner_rec.partner_id);
1348: FETCH c_partner_name INTO l_partner_name;
1349: CLOSE c_partner_name;
1350: AMS_Utility_PVT.error_message ('AMS_ACTPART_DUP_ACTPARTNER', 'PARTNER_NAME', l_partner_name);
1351: x_return_status := FND_API.g_ret_sts_error;
1352: END IF;
1353: END check_act_partner_uk_items;
1354:
1355: END AMS_ActPartner_PVT;