APPS.AMS_ASSOCIATIONS_PVT dependencies on FND_API

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

34: -- (fixed bug# 2063150)
35: ---------------------------------------------------------------------
36: PROCEDURE create_association(
37: p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
39: p_commit IN VARCHAR2 := FND_API.g_false,
40: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
41:
42: x_return_status OUT NOCOPY VARCHAR2,

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

35: ---------------------------------------------------------------------
36: PROCEDURE create_association(
37: p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
39: p_commit IN VARCHAR2 := FND_API.g_false,
40: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
41:
42: x_return_status OUT NOCOPY VARCHAR2,
43: x_msg_count OUT NOCOPY NUMBER,

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

36: PROCEDURE create_association(
37: p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
39: p_commit IN VARCHAR2 := FND_API.g_false,
40: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
41:
42: x_return_status OUT NOCOPY VARCHAR2,
43: x_msg_count OUT NOCOPY NUMBER,
44: x_msg_data OUT NOCOPY VARCHAR2,

Line 103: IF FND_API.to_boolean(p_init_msg_list) THEN

99: AMS_Utility_PVT.debug_message(l_full_name||': start');
100:
101: END IF;
102:
103: IF FND_API.to_boolean(p_init_msg_list) THEN
104: FND_MSG_PUB.initialize;
105: END IF;
106:
107: IF NOT FND_API.compatible_api_call(

Line 107: IF NOT FND_API.compatible_api_call(

103: IF FND_API.to_boolean(p_init_msg_list) THEN
104: FND_MSG_PUB.initialize;
105: END IF;
106:
107: IF NOT FND_API.compatible_api_call(
108: l_api_version,
109: p_api_version,
110: l_api_name,
111: g_pkg_name

Line 113: RAISE FND_API.g_exc_unexpected_error;

109: p_api_version,
110: l_api_name,
111: g_pkg_name
112: ) THEN
113: RAISE FND_API.g_exc_unexpected_error;
114: END IF;
115:
116: x_return_status := FND_API.g_ret_sts_success;
117:

Line 116: x_return_status := FND_API.g_ret_sts_success;

112: ) THEN
113: RAISE FND_API.g_exc_unexpected_error;
114: END IF;
115:
116: x_return_status := FND_API.g_ret_sts_success;
117:
118: ----------------------- validate -----------------------
119: IF (AMS_DEBUG_HIGH_ON) THEN
120:

Line 134: IF l_return_status = FND_API.g_ret_sts_error THEN

130: x_msg_data => x_msg_data,
131: p_association_rec => l_association_rec
132: );
133:
134: IF l_return_status = FND_API.g_ret_sts_error THEN
135: RAISE FND_API.g_exc_error;
136: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
137: RAISE FND_API.g_exc_unexpected_error;
138: END IF;

Line 135: RAISE FND_API.g_exc_error;

131: p_association_rec => l_association_rec
132: );
133:
134: IF l_return_status = FND_API.g_ret_sts_error THEN
135: RAISE FND_API.g_exc_error;
136: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
137: RAISE FND_API.g_exc_unexpected_error;
138: END IF;
139: --------------- CHECK ACCESS FOR THE USER-------------------

Line 136: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

132: );
133:
134: IF l_return_status = FND_API.g_ret_sts_error THEN
135: RAISE FND_API.g_exc_error;
136: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
137: RAISE FND_API.g_exc_unexpected_error;
138: END IF;
139: --------------- CHECK ACCESS FOR THE USER-------------------
140: ----------added sugupta 07/25/2000

Line 137: RAISE FND_API.g_exc_unexpected_error;

133:
134: IF l_return_status = FND_API.g_ret_sts_error THEN
135: RAISE FND_API.g_exc_error;
136: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
137: RAISE FND_API.g_exc_unexpected_error;
138: END IF;
139: --------------- CHECK ACCESS FOR THE USER-------------------
140: ----------added sugupta 07/25/2000
141: l_user_id := FND_GLOBAL.User_Id;

Line 154: RAISE FND_API.g_exc_error;

150: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
151: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_UPDATE_ACCESS'); --resuing message
152: FND_MSG_PUB.add;
153: END IF;
154: RAISE FND_API.g_exc_error;
155: end if;
156: END IF ;
157:
158: ------------------- Added by ABHOLA ------------------

Line 179: RAISE FND_API.g_exc_error;

175: if FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) then
176: FND_MESSAGE.set_name('AMS', 'AMS_DELV_CSCH_LANGUAGE');
177: FND_MSG_PUB.add;
178: end if;
179: RAISE FND_API.g_exc_error;
180: end if;
181:
182: end if;*/
183:

Line 196: RAISE FND_API.g_exc_error;

192: if FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) then
193: FND_MESSAGE.set_name('AMS', 'AMS_DELV_INVALID_DATES');
194: FND_MSG_PUB.add;
195: end if;
196: RAISE FND_API.g_exc_error;
197: end if;
198:
199: check_association_dates(
200: p_association_rec => l_association_rec,

Line 204: IF x_return_status = FND_API.g_ret_sts_error THEN

200: p_association_rec => l_association_rec,
201: x_return_status => x_return_status
202: );
203:
204: IF x_return_status = FND_API.g_ret_sts_error THEN
205: RAISE FND_API.g_exc_error;
206: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
207: RAISE FND_API.g_exc_unexpected_error;
208: END IF;

Line 205: RAISE FND_API.g_exc_error;

201: x_return_status => x_return_status
202: );
203:
204: IF x_return_status = FND_API.g_ret_sts_error THEN
205: RAISE FND_API.g_exc_error;
206: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
207: RAISE FND_API.g_exc_unexpected_error;
208: END IF;
209:

Line 206: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

202: );
203:
204: IF x_return_status = FND_API.g_ret_sts_error THEN
205: RAISE FND_API.g_exc_error;
206: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
207: RAISE FND_API.g_exc_unexpected_error;
208: END IF;
209:
210:

Line 207: RAISE FND_API.g_exc_unexpected_error;

203:
204: IF x_return_status = FND_API.g_ret_sts_error THEN
205: RAISE FND_API.g_exc_error;
206: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
207: RAISE FND_API.g_exc_unexpected_error;
208: END IF;
209:
210:
211:

Line 333: p_init_msg_list => FND_API.g_false,

329: AND l_association_rec.USING_OBJECT_TYPE <> 'EVEO')
330: THEN
331: AMS_ObjectAttribute_PVT.modify_object_attribute(
332: p_api_version => l_api_version,
333: p_init_msg_list => FND_API.g_false,
334: p_commit => FND_API.g_false,
335: p_validation_level => FND_API.g_valid_level_full,
336:
337: x_return_status => l_return_status,

Line 334: p_commit => FND_API.g_false,

330: THEN
331: AMS_ObjectAttribute_PVT.modify_object_attribute(
332: p_api_version => l_api_version,
333: p_init_msg_list => FND_API.g_false,
334: p_commit => FND_API.g_false,
335: p_validation_level => FND_API.g_valid_level_full,
336:
337: x_return_status => l_return_status,
338: x_msg_count => x_msg_count,

Line 335: p_validation_level => FND_API.g_valid_level_full,

331: AMS_ObjectAttribute_PVT.modify_object_attribute(
332: p_api_version => l_api_version,
333: p_init_msg_list => FND_API.g_false,
334: p_commit => FND_API.g_false,
335: p_validation_level => FND_API.g_valid_level_full,
336:
337: x_return_status => l_return_status,
338: x_msg_count => x_msg_count,
339: x_msg_data => x_msg_data,

Line 347: IF l_return_status = FND_API.g_ret_sts_error THEN

343: p_attr => l_association_rec.USING_OBJECT_TYPE,
344: p_attr_defined_flag => 'Y'
345: );
346:
347: IF l_return_status = FND_API.g_ret_sts_error THEN
348: RAISE FND_API.g_exc_error;
349: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
350: RAISE FND_API.g_exc_unexpected_error;
351: END IF;

Line 348: RAISE FND_API.g_exc_error;

344: p_attr_defined_flag => 'Y'
345: );
346:
347: IF l_return_status = FND_API.g_ret_sts_error THEN
348: RAISE FND_API.g_exc_error;
349: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
350: RAISE FND_API.g_exc_unexpected_error;
351: END IF;
352: END IF ;

Line 349: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

345: );
346:
347: IF l_return_status = FND_API.g_ret_sts_error THEN
348: RAISE FND_API.g_exc_error;
349: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
350: RAISE FND_API.g_exc_unexpected_error;
351: END IF;
352: END IF ;
353: *******************/

Line 350: RAISE FND_API.g_exc_unexpected_error;

346:
347: IF l_return_status = FND_API.g_ret_sts_error THEN
348: RAISE FND_API.g_exc_error;
349: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
350: RAISE FND_API.g_exc_unexpected_error;
351: END IF;
352: END IF ;
353: *******************/
354:

Line 359: IF FND_API.to_boolean(p_commit) THEN

355: -- =========================================================================
356: -- End of Code modified by ptendulk on 15-Jul-2000
357: -- =========================================================================
358:
359: IF FND_API.to_boolean(p_commit) THEN
360: COMMIT;
361: END IF;
362:
363: FND_MSG_PUB.count_and_get(

Line 364: p_encoded => FND_API.g_false,

360: COMMIT;
361: END IF;
362:
363: FND_MSG_PUB.count_and_get(
364: p_encoded => FND_API.g_false,
365: p_count => x_msg_count,
366: p_data => x_msg_data
367: );
368:

Line 379: WHEN FND_API.g_exc_error THEN

375: END IF;
376:
377: EXCEPTION
378:
379: WHEN FND_API.g_exc_error THEN
380: ROLLBACK TO create_association;
381: x_return_status := FND_API.g_ret_sts_error;
382: FND_MSG_PUB.count_and_get(
383: p_encoded => FND_API.g_false,

Line 381: x_return_status := FND_API.g_ret_sts_error;

377: EXCEPTION
378:
379: WHEN FND_API.g_exc_error THEN
380: ROLLBACK TO create_association;
381: x_return_status := FND_API.g_ret_sts_error;
382: FND_MSG_PUB.count_and_get(
383: p_encoded => FND_API.g_false,
384: p_count => x_msg_count,
385: p_data => x_msg_data

Line 383: p_encoded => FND_API.g_false,

379: WHEN FND_API.g_exc_error THEN
380: ROLLBACK TO create_association;
381: x_return_status := FND_API.g_ret_sts_error;
382: FND_MSG_PUB.count_and_get(
383: p_encoded => FND_API.g_false,
384: p_count => x_msg_count,
385: p_data => x_msg_data
386: );
387:

Line 388: WHEN FND_API.g_exc_unexpected_error THEN

384: p_count => x_msg_count,
385: p_data => x_msg_data
386: );
387:
388: WHEN FND_API.g_exc_unexpected_error THEN
389: ROLLBACK TO create_association;
390: x_return_status := FND_API.g_ret_sts_unexp_error ;
391: FND_MSG_PUB.count_and_get(
392: p_encoded => FND_API.g_false,

Line 390: x_return_status := FND_API.g_ret_sts_unexp_error ;

386: );
387:
388: WHEN FND_API.g_exc_unexpected_error THEN
389: ROLLBACK TO create_association;
390: x_return_status := FND_API.g_ret_sts_unexp_error ;
391: FND_MSG_PUB.count_and_get(
392: p_encoded => FND_API.g_false,
393: p_count => x_msg_count,
394: p_data => x_msg_data

Line 392: p_encoded => FND_API.g_false,

388: WHEN FND_API.g_exc_unexpected_error THEN
389: ROLLBACK TO create_association;
390: x_return_status := FND_API.g_ret_sts_unexp_error ;
391: FND_MSG_PUB.count_and_get(
392: p_encoded => FND_API.g_false,
393: p_count => x_msg_count,
394: p_data => x_msg_data
395: );
396:

Line 400: x_return_status := FND_API.g_ret_sts_unexp_error ;

396:
397:
398: WHEN OTHERS THEN
399: ROLLBACK TO create_association;
400: x_return_status := FND_API.g_ret_sts_unexp_error ;
401:
402: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
403: THEN
404: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 408: p_encoded => FND_API.g_false,

404: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
405: END IF;
406:
407: FND_MSG_PUB.count_and_get(
408: p_encoded => FND_API.g_false,
409: p_count => x_msg_count,
410: p_data => x_msg_data
411: );
412:

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

422: -- using object is not events .
423: ---------------------------------------------------------------
424: PROCEDURE delete_association(
425: p_api_version IN NUMBER,
426: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
427: p_commit IN VARCHAR2 := FND_API.g_false,
428: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
429:
430: x_return_status OUT NOCOPY VARCHAR2,

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

423: ---------------------------------------------------------------
424: PROCEDURE delete_association(
425: p_api_version IN NUMBER,
426: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
427: p_commit IN VARCHAR2 := FND_API.g_false,
428: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
429:
430: x_return_status OUT NOCOPY VARCHAR2,
431: x_msg_count OUT NOCOPY NUMBER,

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

424: PROCEDURE delete_association(
425: p_api_version IN NUMBER,
426: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
427: p_commit IN VARCHAR2 := FND_API.g_false,
428: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
429:
430: x_return_status OUT NOCOPY VARCHAR2,
431: x_msg_count OUT NOCOPY NUMBER,
432: x_msg_data OUT NOCOPY VARCHAR2,

Line 491: IF FND_API.to_boolean(p_init_msg_list) THEN

487: AMS_Utility_PVT.debug_message(l_full_name||': start');
488:
489: END IF;
490:
491: IF FND_API.to_boolean(p_init_msg_list) THEN
492: FND_MSG_PUB.initialize;
493: END IF;
494:
495: IF NOT FND_API.compatible_api_call(

Line 495: IF NOT FND_API.compatible_api_call(

491: IF FND_API.to_boolean(p_init_msg_list) THEN
492: FND_MSG_PUB.initialize;
493: END IF;
494:
495: IF NOT FND_API.compatible_api_call(
496: l_api_version,
497: p_api_version,
498: l_api_name,
499: g_pkg_name

Line 501: RAISE FND_API.g_exc_unexpected_error;

497: p_api_version,
498: l_api_name,
499: g_pkg_name
500: ) THEN
501: RAISE FND_API.g_exc_unexpected_error;
502: END IF;
503:
504: x_return_status := FND_API.G_RET_STS_SUCCESS;
505: --------------- CHECK ACCESS FOR THE USER-------------------

Line 504: x_return_status := FND_API.G_RET_STS_SUCCESS;

500: ) THEN
501: RAISE FND_API.g_exc_unexpected_error;
502: END IF;
503:
504: x_return_status := FND_API.G_RET_STS_SUCCESS;
505: --------------- CHECK ACCESS FOR THE USER-------------------
506: ----------added sugupta 07/25/2000
507: l_user_id := FND_GLOBAL.User_Id;
508: if l_user_id IS NOT NULL then

Line 524: RAISE FND_API.g_exc_error;

520: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
521: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_UPDATE_ACCESS'); --reusing message
522: FND_MSG_PUB.add;
523: END IF;
524: RAISE FND_API.g_exc_error;
525: end if;
526: END IF ;
527:
528: ------------------------ delete ------------------------

Line 548: RAISE FND_API.g_exc_error;

544: THEN
545: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
546: FND_MSG_PUB.add;
547: END IF;
548: RAISE FND_API.g_exc_error;
549: END IF;
550:
551: ----- Modify Object Attribute ---------------
552:

Line 574: p_init_msg_list => FND_API.g_false,

570: THEN
571:
572: AMS_ObjectAttribute_PVT.modify_object_attribute(
573: p_api_version => l_api_version,
574: p_init_msg_list => FND_API.g_false,
575: p_commit => FND_API.g_false,
576: p_validation_level => FND_API.g_valid_level_full,
577:
578: x_return_status => x_return_status,

Line 575: p_commit => FND_API.g_false,

571:
572: AMS_ObjectAttribute_PVT.modify_object_attribute(
573: p_api_version => l_api_version,
574: p_init_msg_list => FND_API.g_false,
575: p_commit => FND_API.g_false,
576: p_validation_level => FND_API.g_valid_level_full,
577:
578: x_return_status => x_return_status,
579: x_msg_count => x_msg_count,

Line 576: p_validation_level => FND_API.g_valid_level_full,

572: AMS_ObjectAttribute_PVT.modify_object_attribute(
573: p_api_version => l_api_version,
574: p_init_msg_list => FND_API.g_false,
575: p_commit => FND_API.g_false,
576: p_validation_level => FND_API.g_valid_level_full,
577:
578: x_return_status => x_return_status,
579: x_msg_count => x_msg_count,
580: x_msg_data => x_msg_data,

Line 587: IF x_return_status = FND_API.g_ret_sts_error THEN

583: p_object_id => l_object_id,
584: p_attr => l_attr,
585: p_attr_defined_flag => 'N'
586: );
587: IF x_return_status = FND_API.g_ret_sts_error THEN
588: RAISE FND_API.g_exc_error;
589: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
590: RAISE FND_API.g_exc_unexpected_error;
591: END IF;

Line 588: RAISE FND_API.g_exc_error;

584: p_attr => l_attr,
585: p_attr_defined_flag => 'N'
586: );
587: IF x_return_status = FND_API.g_ret_sts_error THEN
588: RAISE FND_API.g_exc_error;
589: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
590: RAISE FND_API.g_exc_unexpected_error;
591: END IF;
592: END IF;

Line 589: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

585: p_attr_defined_flag => 'N'
586: );
587: IF x_return_status = FND_API.g_ret_sts_error THEN
588: RAISE FND_API.g_exc_error;
589: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
590: RAISE FND_API.g_exc_unexpected_error;
591: END IF;
592: END IF;
593: **/

Line 590: RAISE FND_API.g_exc_unexpected_error;

586: );
587: IF x_return_status = FND_API.g_ret_sts_error THEN
588: RAISE FND_API.g_exc_error;
589: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
590: RAISE FND_API.g_exc_unexpected_error;
591: END IF;
592: END IF;
593: **/
594: -- =========================================================================

Line 603: IF FND_API.to_boolean(p_commit) THEN

599:
600: CLOSE get_count;
601:
602: -------------------- finish --------------------------
603: IF FND_API.to_boolean(p_commit) THEN
604: COMMIT;
605: END IF;
606:
607: FND_MSG_PUB.count_and_get(

Line 608: p_encoded => FND_API.g_false,

604: COMMIT;
605: END IF;
606:
607: FND_MSG_PUB.count_and_get(
608: p_encoded => FND_API.g_false,
609: p_count => x_msg_count,
610: p_data => x_msg_data
611: );
612:

Line 623: WHEN FND_API.g_exc_error THEN

619: END IF;
620:
621: EXCEPTION
622:
623: WHEN FND_API.g_exc_error THEN
624: ROLLBACK TO delete_association;
625: x_return_status := FND_API.g_ret_sts_error;
626: FND_MSG_PUB.count_and_get(
627: p_encoded => FND_API.g_false,

Line 625: x_return_status := FND_API.g_ret_sts_error;

621: EXCEPTION
622:
623: WHEN FND_API.g_exc_error THEN
624: ROLLBACK TO delete_association;
625: x_return_status := FND_API.g_ret_sts_error;
626: FND_MSG_PUB.count_and_get(
627: p_encoded => FND_API.g_false,
628: p_count => x_msg_count,
629: p_data => x_msg_data

Line 627: p_encoded => FND_API.g_false,

623: WHEN FND_API.g_exc_error THEN
624: ROLLBACK TO delete_association;
625: x_return_status := FND_API.g_ret_sts_error;
626: FND_MSG_PUB.count_and_get(
627: p_encoded => FND_API.g_false,
628: p_count => x_msg_count,
629: p_data => x_msg_data
630: );
631:

Line 632: WHEN FND_API.g_exc_unexpected_error THEN

628: p_count => x_msg_count,
629: p_data => x_msg_data
630: );
631:
632: WHEN FND_API.g_exc_unexpected_error THEN
633: ROLLBACK TO delete_association;
634: x_return_status := FND_API.g_ret_sts_unexp_error ;
635: FND_MSG_PUB.count_and_get(
636: p_encoded => FND_API.g_false,

Line 634: x_return_status := FND_API.g_ret_sts_unexp_error ;

630: );
631:
632: WHEN FND_API.g_exc_unexpected_error THEN
633: ROLLBACK TO delete_association;
634: x_return_status := FND_API.g_ret_sts_unexp_error ;
635: FND_MSG_PUB.count_and_get(
636: p_encoded => FND_API.g_false,
637: p_count => x_msg_count,
638: p_data => x_msg_data

Line 636: p_encoded => FND_API.g_false,

632: WHEN FND_API.g_exc_unexpected_error THEN
633: ROLLBACK TO delete_association;
634: x_return_status := FND_API.g_ret_sts_unexp_error ;
635: FND_MSG_PUB.count_and_get(
636: p_encoded => FND_API.g_false,
637: p_count => x_msg_count,
638: p_data => x_msg_data
639: );
640:

Line 643: x_return_status := FND_API.g_ret_sts_unexp_error ;

639: );
640:
641: WHEN OTHERS THEN
642: ROLLBACK TO delete_association;
643: x_return_status := FND_API.g_ret_sts_unexp_error ;
644:
645: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
646: THEN
647: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 651: p_encoded => FND_API.g_false,

647: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
648: END IF;
649:
650: FND_MSG_PUB.count_and_get(
651: p_encoded => FND_API.g_false,
652: p_count => x_msg_count,
653: p_data => x_msg_data
654: );
655:

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

663: -- 11/10/99 sugupta created
664: --------------------------------------------------------------------
665: PROCEDURE lock_association(
666: p_api_version IN NUMBER,
667: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
668: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
669:
670: x_return_status OUT NOCOPY VARCHAR2,
671: x_msg_count OUT NOCOPY NUMBER,

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

664: --------------------------------------------------------------------
665: PROCEDURE lock_association(
666: p_api_version IN NUMBER,
667: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
668: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
669:
670: x_return_status OUT NOCOPY VARCHAR2,
671: x_msg_count OUT NOCOPY NUMBER,
672: x_msg_data OUT NOCOPY VARCHAR2,

Line 701: IF FND_API.to_boolean(p_init_msg_list) THEN

697:
698: AMS_Utility_PVT.debug_message(l_full_name||': start');
699: END IF;
700:
701: IF FND_API.to_boolean(p_init_msg_list) THEN
702: FND_MSG_PUB.initialize;
703: END IF;
704:
705: IF NOT FND_API.compatible_api_call(

Line 705: IF NOT FND_API.compatible_api_call(

701: IF FND_API.to_boolean(p_init_msg_list) THEN
702: FND_MSG_PUB.initialize;
703: END IF;
704:
705: IF NOT FND_API.compatible_api_call(
706: l_api_version,
707: p_api_version,
708: l_api_name,
709: g_pkg_name

Line 711: RAISE FND_API.g_exc_unexpected_error;

707: p_api_version,
708: l_api_name,
709: g_pkg_name
710: ) THEN
711: RAISE FND_API.g_exc_unexpected_error;
712: END IF;
713:
714: x_return_status := FND_API.G_RET_STS_SUCCESS;
715:

Line 714: x_return_status := FND_API.G_RET_STS_SUCCESS;

710: ) THEN
711: RAISE FND_API.g_exc_unexpected_error;
712: END IF;
713:
714: x_return_status := FND_API.G_RET_STS_SUCCESS;
715:
716: ------------------------ lock -------------------------
717: IF (AMS_DEBUG_HIGH_ON) THEN
718:

Line 730: RAISE FND_API.g_exc_error;

726: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
727: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
728: FND_MSG_PUB.add;
729: END IF;
730: RAISE FND_API.g_exc_error;
731: END IF;
732: CLOSE c_association_b;
733: -------------------- finish --------------------------
734: FND_MSG_PUB.count_and_get(

Line 735: p_encoded => FND_API.g_false,

731: END IF;
732: CLOSE c_association_b;
733: -------------------- finish --------------------------
734: FND_MSG_PUB.count_and_get(
735: p_encoded => FND_API.g_false,
736: p_count => x_msg_count,
737: p_data => x_msg_data
738: );
739:

Line 751: x_return_status := FND_API.g_ret_sts_error;

747:
748: EXCEPTION
749:
750: WHEN AMS_Utility_PVT.resource_locked THEN
751: x_return_status := FND_API.g_ret_sts_error;
752: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
753: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
754: FND_MSG_PUB.add;
755: END IF;

Line 758: p_encoded => FND_API.g_false,

754: FND_MSG_PUB.add;
755: END IF;
756:
757: FND_MSG_PUB.count_and_get(
758: p_encoded => FND_API.g_false,
759: p_count => x_msg_count,
760: p_data => x_msg_data
761: );
762:

Line 763: WHEN FND_API.g_exc_error THEN

759: p_count => x_msg_count,
760: p_data => x_msg_data
761: );
762:
763: WHEN FND_API.g_exc_error THEN
764: x_return_status := FND_API.g_ret_sts_error;
765: FND_MSG_PUB.count_and_get(
766: p_encoded => FND_API.g_false,
767: p_count => x_msg_count,

Line 764: x_return_status := FND_API.g_ret_sts_error;

760: p_data => x_msg_data
761: );
762:
763: WHEN FND_API.g_exc_error THEN
764: x_return_status := FND_API.g_ret_sts_error;
765: FND_MSG_PUB.count_and_get(
766: p_encoded => FND_API.g_false,
767: p_count => x_msg_count,
768: p_data => x_msg_data

Line 766: p_encoded => FND_API.g_false,

762:
763: WHEN FND_API.g_exc_error THEN
764: x_return_status := FND_API.g_ret_sts_error;
765: FND_MSG_PUB.count_and_get(
766: p_encoded => FND_API.g_false,
767: p_count => x_msg_count,
768: p_data => x_msg_data
769: );
770:

Line 771: WHEN FND_API.g_exc_unexpected_error THEN

767: p_count => x_msg_count,
768: p_data => x_msg_data
769: );
770:
771: WHEN FND_API.g_exc_unexpected_error THEN
772: x_return_status := FND_API.g_ret_sts_unexp_error ;
773: FND_MSG_PUB.count_and_get(
774: p_encoded => FND_API.g_false,
775: p_count => x_msg_count,

Line 772: x_return_status := FND_API.g_ret_sts_unexp_error ;

768: p_data => x_msg_data
769: );
770:
771: WHEN FND_API.g_exc_unexpected_error THEN
772: x_return_status := FND_API.g_ret_sts_unexp_error ;
773: FND_MSG_PUB.count_and_get(
774: p_encoded => FND_API.g_false,
775: p_count => x_msg_count,
776: p_data => x_msg_data

Line 774: p_encoded => FND_API.g_false,

770:
771: WHEN FND_API.g_exc_unexpected_error THEN
772: x_return_status := FND_API.g_ret_sts_unexp_error ;
773: FND_MSG_PUB.count_and_get(
774: p_encoded => FND_API.g_false,
775: p_count => x_msg_count,
776: p_data => x_msg_data
777: );
778:

Line 780: x_return_status := FND_API.g_ret_sts_unexp_error ;

776: p_data => x_msg_data
777: );
778:
779: WHEN OTHERS THEN
780: x_return_status := FND_API.g_ret_sts_unexp_error ;
781: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
782: THEN
783: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
784: END IF;

Line 787: p_encoded => FND_API.g_false,

783: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
784: END IF;
785:
786: FND_MSG_PUB.count_and_get(
787: p_encoded => FND_API.g_false,
788: p_count => x_msg_count,
789: p_data => x_msg_data
790: );
791:

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

800: -- 11/10/99 sugupta created
801: ----------------------------------------------------------------------
802: PROCEDURE update_association(
803: p_api_version IN NUMBER,
804: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
805: p_commit IN VARCHAR2 := FND_API.g_false,
806: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
807:
808: x_return_status OUT NOCOPY VARCHAR2,

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

801: ----------------------------------------------------------------------
802: PROCEDURE update_association(
803: p_api_version IN NUMBER,
804: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
805: p_commit IN VARCHAR2 := FND_API.g_false,
806: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
807:
808: x_return_status OUT NOCOPY VARCHAR2,
809: x_msg_count OUT NOCOPY NUMBER,

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

802: PROCEDURE update_association(
803: p_api_version IN NUMBER,
804: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
805: p_commit IN VARCHAR2 := FND_API.g_false,
806: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
807:
808: x_return_status OUT NOCOPY VARCHAR2,
809: x_msg_count OUT NOCOPY NUMBER,
810: x_msg_data OUT NOCOPY VARCHAR2,

Line 843: IF FND_API.to_boolean(p_init_msg_list) THEN

839: AMS_Utility_PVT.debug_message(l_full_name||': start');
840:
841: END IF;
842:
843: IF FND_API.to_boolean(p_init_msg_list) THEN
844: FND_MSG_PUB.initialize;
845: END IF;
846:
847: IF NOT FND_API.compatible_api_call(

Line 847: IF NOT FND_API.compatible_api_call(

843: IF FND_API.to_boolean(p_init_msg_list) THEN
844: FND_MSG_PUB.initialize;
845: END IF;
846:
847: IF NOT FND_API.compatible_api_call(
848: l_api_version,
849: p_api_version,
850: l_api_name,
851: g_pkg_name

Line 853: RAISE FND_API.g_exc_unexpected_error;

849: p_api_version,
850: l_api_name,
851: g_pkg_name
852: ) THEN
853: RAISE FND_API.g_exc_unexpected_error;
854: END IF;
855:
856: x_return_status := FND_API.G_RET_STS_SUCCESS;
857:

Line 856: x_return_status := FND_API.G_RET_STS_SUCCESS;

852: ) THEN
853: RAISE FND_API.g_exc_unexpected_error;
854: END IF;
855:
856: x_return_status := FND_API.G_RET_STS_SUCCESS;
857:
858: -- replace g_miss_char/num/date with current column values
859: complete_association_rec(p_association_rec, l_association_rec);
860:

Line 874: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

870: p_validation_mode => JTF_PLSQL_API.g_update,
871: x_return_status => l_return_status
872: );
873:
874: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
875: RAISE FND_API.g_exc_unexpected_error;
876: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
877: RAISE FND_API.g_exc_error;
878: END IF;

Line 875: RAISE FND_API.g_exc_unexpected_error;

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

Line 876: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

872: );
873:
874: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
875: RAISE FND_API.g_exc_unexpected_error;
876: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
877: RAISE FND_API.g_exc_error;
878: END IF;
879: END IF;
880:

Line 877: RAISE FND_API.g_exc_error;

873:
874: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
875: RAISE FND_API.g_exc_unexpected_error;
876: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
877: RAISE FND_API.g_exc_error;
878: END IF;
879: END IF;
880:
881: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

Line 887: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

883: p_association_rec => p_association_rec,
884: x_return_status => l_return_status
885: );
886:
887: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
888: RAISE FND_API.g_exc_unexpected_error;
889: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
890: RAISE FND_API.g_exc_error;
891: END IF;

Line 888: RAISE FND_API.g_exc_unexpected_error;

884: x_return_status => l_return_status
885: );
886:
887: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
888: RAISE FND_API.g_exc_unexpected_error;
889: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
890: RAISE FND_API.g_exc_error;
891: END IF;
892: END IF;

Line 889: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

885: );
886:
887: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
888: RAISE FND_API.g_exc_unexpected_error;
889: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
890: RAISE FND_API.g_exc_error;
891: END IF;
892: END IF;
893: --------------- CHECK ACCESS FOR THE USER-------------------

Line 890: RAISE FND_API.g_exc_error;

886:
887: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
888: RAISE FND_API.g_exc_unexpected_error;
889: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
890: RAISE FND_API.g_exc_error;
891: END IF;
892: END IF;
893: --------------- CHECK ACCESS FOR THE USER-------------------
894: ----------added sugupta 07/25/2000

Line 908: RAISE FND_API.g_exc_error;

904: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
905: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_UPDATE_ACCESS');
906: FND_MSG_PUB.add;
907: END IF;
908: RAISE FND_API.g_exc_error;
909: end if;
910: END IF ;
911: -------------------------- update --------------------
912: IF (AMS_DEBUG_HIGH_ON) THEN

Line 962: RAISE FND_API.g_exc_error;

958: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
959: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
960: FND_MSG_PUB.add;
961: END IF;
962: RAISE FND_API.g_exc_error;
963: END IF;
964:
965: -------------------- finish --------------------------
966: IF FND_API.to_boolean(p_commit) THEN

Line 966: IF FND_API.to_boolean(p_commit) THEN

962: RAISE FND_API.g_exc_error;
963: END IF;
964:
965: -------------------- finish --------------------------
966: IF FND_API.to_boolean(p_commit) THEN
967: COMMIT;
968: END IF;
969:
970: FND_MSG_PUB.count_and_get(

Line 971: p_encoded => FND_API.g_false,

967: COMMIT;
968: END IF;
969:
970: FND_MSG_PUB.count_and_get(
971: p_encoded => FND_API.g_false,
972: p_count => x_msg_count,
973: p_data => x_msg_data
974: );
975:

Line 986: WHEN FND_API.g_exc_error THEN

982: END IF;
983:
984: EXCEPTION
985:
986: WHEN FND_API.g_exc_error THEN
987: ROLLBACK TO update_association;
988: x_return_status := FND_API.g_ret_sts_error;
989: FND_MSG_PUB.count_and_get(
990: p_encoded => FND_API.g_false,

Line 988: x_return_status := FND_API.g_ret_sts_error;

984: EXCEPTION
985:
986: WHEN FND_API.g_exc_error THEN
987: ROLLBACK TO update_association;
988: x_return_status := FND_API.g_ret_sts_error;
989: FND_MSG_PUB.count_and_get(
990: p_encoded => FND_API.g_false,
991: p_count => x_msg_count,
992: p_data => x_msg_data

Line 990: p_encoded => FND_API.g_false,

986: WHEN FND_API.g_exc_error THEN
987: ROLLBACK TO update_association;
988: x_return_status := FND_API.g_ret_sts_error;
989: FND_MSG_PUB.count_and_get(
990: p_encoded => FND_API.g_false,
991: p_count => x_msg_count,
992: p_data => x_msg_data
993: );
994:

Line 995: WHEN FND_API.g_exc_unexpected_error THEN

991: p_count => x_msg_count,
992: p_data => x_msg_data
993: );
994:
995: WHEN FND_API.g_exc_unexpected_error THEN
996: ROLLBACK TO update_association;
997: x_return_status := FND_API.g_ret_sts_unexp_error ;
998: FND_MSG_PUB.count_and_get(
999: p_encoded => FND_API.g_false,

Line 997: x_return_status := FND_API.g_ret_sts_unexp_error ;

993: );
994:
995: WHEN FND_API.g_exc_unexpected_error THEN
996: ROLLBACK TO update_association;
997: x_return_status := FND_API.g_ret_sts_unexp_error ;
998: FND_MSG_PUB.count_and_get(
999: p_encoded => FND_API.g_false,
1000: p_count => x_msg_count,
1001: p_data => x_msg_data

Line 999: p_encoded => FND_API.g_false,

995: WHEN FND_API.g_exc_unexpected_error THEN
996: ROLLBACK TO update_association;
997: x_return_status := FND_API.g_ret_sts_unexp_error ;
998: FND_MSG_PUB.count_and_get(
999: p_encoded => FND_API.g_false,
1000: p_count => x_msg_count,
1001: p_data => x_msg_data
1002: );
1003:

Line 1006: x_return_status := FND_API.g_ret_sts_unexp_error ;

1002: );
1003:
1004: WHEN OTHERS THEN
1005: ROLLBACK TO update_association;
1006: x_return_status := FND_API.g_ret_sts_unexp_error ;
1007:
1008: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1009: THEN
1010: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 1014: p_encoded => FND_API.g_false,

1010: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1011: END IF;
1012:
1013: FND_MSG_PUB.count_and_get(
1014: p_encoded => FND_API.g_false,
1015: p_count => x_msg_count,
1016: p_data => x_msg_data
1017: );
1018:

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

1025: -- 11/10/99 sugupta created
1026: --------------------------------------------------------------------
1027: PROCEDURE validate_association(
1028: p_api_version IN NUMBER,
1029: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1030: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1031:
1032: x_return_status OUT NOCOPY VARCHAR2,
1033: x_msg_count OUT NOCOPY NUMBER,

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

1026: --------------------------------------------------------------------
1027: PROCEDURE validate_association(
1028: p_api_version IN NUMBER,
1029: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1030: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1031:
1032: x_return_status OUT NOCOPY VARCHAR2,
1033: x_msg_count OUT NOCOPY NUMBER,
1034: x_msg_data OUT NOCOPY VARCHAR2,

Line 1053: IF FND_API.to_boolean(p_init_msg_list) THEN

1049:
1050: AMS_Utility_PVT.debug_message(l_full_name||': start');
1051: END IF;
1052:
1053: IF FND_API.to_boolean(p_init_msg_list) THEN
1054: FND_MSG_PUB.initialize;
1055: END IF;
1056:
1057: IF NOT FND_API.compatible_api_call(

Line 1057: IF NOT FND_API.compatible_api_call(

1053: IF FND_API.to_boolean(p_init_msg_list) THEN
1054: FND_MSG_PUB.initialize;
1055: END IF;
1056:
1057: IF NOT FND_API.compatible_api_call(
1058: l_api_version,
1059: p_api_version,
1060: l_api_name,
1061: g_pkg_name

Line 1063: RAISE FND_API.g_exc_unexpected_error;

1059: p_api_version,
1060: l_api_name,
1061: g_pkg_name
1062: ) THEN
1063: RAISE FND_API.g_exc_unexpected_error;
1064: END IF;
1065:
1066: x_return_status := FND_API.g_ret_sts_success;
1067:

Line 1066: x_return_status := FND_API.g_ret_sts_success;

1062: ) THEN
1063: RAISE FND_API.g_exc_unexpected_error;
1064: END IF;
1065:
1066: x_return_status := FND_API.g_ret_sts_success;
1067:
1068: ---------------------- validate ------------------------
1069: IF (AMS_DEBUG_HIGH_ON) THEN
1070:

Line 1081: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1077: p_validation_mode => JTF_PLSQL_API.g_create,
1078: x_return_status => l_return_status
1079: );
1080:
1081: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1082: RAISE FND_API.g_exc_unexpected_error;
1083: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1084: RAISE FND_API.g_exc_error;
1085: END IF;

Line 1082: RAISE FND_API.g_exc_unexpected_error;

1078: x_return_status => l_return_status
1079: );
1080:
1081: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1082: RAISE FND_API.g_exc_unexpected_error;
1083: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1084: RAISE FND_API.g_exc_error;
1085: END IF;
1086: END IF;

Line 1083: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

1079: );
1080:
1081: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1082: RAISE FND_API.g_exc_unexpected_error;
1083: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1084: RAISE FND_API.g_exc_error;
1085: END IF;
1086: END IF;
1087:

Line 1084: RAISE FND_API.g_exc_error;

1080:
1081: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1082: RAISE FND_API.g_exc_unexpected_error;
1083: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1084: RAISE FND_API.g_exc_error;
1085: END IF;
1086: END IF;
1087:
1088: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1102: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1098: p_association_rec => p_association_rec,
1099: x_return_status => l_return_status
1100: );
1101:
1102: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1103: RAISE FND_API.g_exc_unexpected_error;
1104: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1105: RAISE FND_API.g_exc_error;
1106: END IF;

Line 1103: RAISE FND_API.g_exc_unexpected_error;

1099: x_return_status => l_return_status
1100: );
1101:
1102: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1103: RAISE FND_API.g_exc_unexpected_error;
1104: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1105: RAISE FND_API.g_exc_error;
1106: END IF;
1107: END IF;

Line 1104: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

1100: );
1101:
1102: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1103: RAISE FND_API.g_exc_unexpected_error;
1104: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1105: RAISE FND_API.g_exc_error;
1106: END IF;
1107: END IF;
1108:

Line 1105: RAISE FND_API.g_exc_error;

1101:
1102: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1103: RAISE FND_API.g_exc_unexpected_error;
1104: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1105: RAISE FND_API.g_exc_error;
1106: END IF;
1107: END IF;
1108:
1109: -------------------- finish --------------------------

Line 1111: p_encoded => FND_API.g_false,

1107: END IF;
1108:
1109: -------------------- finish --------------------------
1110: FND_MSG_PUB.count_and_get(
1111: p_encoded => FND_API.g_false,
1112: p_count => x_msg_count,
1113: p_data => x_msg_data
1114: );
1115:

Line 1126: WHEN FND_API.g_exc_error THEN

1122: END IF;
1123:
1124: EXCEPTION
1125:
1126: WHEN FND_API.g_exc_error THEN
1127: x_return_status := FND_API.g_ret_sts_error;
1128: FND_MSG_PUB.count_and_get(
1129: p_encoded => FND_API.g_false,
1130: p_count => x_msg_count,

Line 1127: x_return_status := FND_API.g_ret_sts_error;

1123:
1124: EXCEPTION
1125:
1126: WHEN FND_API.g_exc_error THEN
1127: x_return_status := FND_API.g_ret_sts_error;
1128: FND_MSG_PUB.count_and_get(
1129: p_encoded => FND_API.g_false,
1130: p_count => x_msg_count,
1131: p_data => x_msg_data

Line 1129: p_encoded => FND_API.g_false,

1125:
1126: WHEN FND_API.g_exc_error THEN
1127: x_return_status := FND_API.g_ret_sts_error;
1128: FND_MSG_PUB.count_and_get(
1129: p_encoded => FND_API.g_false,
1130: p_count => x_msg_count,
1131: p_data => x_msg_data
1132: );
1133:

Line 1134: WHEN FND_API.g_exc_unexpected_error THEN

1130: p_count => x_msg_count,
1131: p_data => x_msg_data
1132: );
1133:
1134: WHEN FND_API.g_exc_unexpected_error THEN
1135: x_return_status := FND_API.g_ret_sts_unexp_error ;
1136: FND_MSG_PUB.count_and_get(
1137: p_encoded => FND_API.g_false,
1138: p_count => x_msg_count,

Line 1135: x_return_status := FND_API.g_ret_sts_unexp_error ;

1131: p_data => x_msg_data
1132: );
1133:
1134: WHEN FND_API.g_exc_unexpected_error THEN
1135: x_return_status := FND_API.g_ret_sts_unexp_error ;
1136: FND_MSG_PUB.count_and_get(
1137: p_encoded => FND_API.g_false,
1138: p_count => x_msg_count,
1139: p_data => x_msg_data

Line 1137: p_encoded => FND_API.g_false,

1133:
1134: WHEN FND_API.g_exc_unexpected_error THEN
1135: x_return_status := FND_API.g_ret_sts_unexp_error ;
1136: FND_MSG_PUB.count_and_get(
1137: p_encoded => FND_API.g_false,
1138: p_count => x_msg_count,
1139: p_data => x_msg_data
1140: );
1141:

Line 1143: x_return_status := FND_API.g_ret_sts_unexp_error;

1139: p_data => x_msg_data
1140: );
1141:
1142: WHEN OTHERS THEN
1143: x_return_status := FND_API.g_ret_sts_unexp_error;
1144: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1145: THEN
1146: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1147: END IF;

Line 1150: p_encoded => FND_API.g_false,

1146: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1147: END IF;
1148:
1149: FND_MSG_PUB.count_and_get(
1150: p_encoded => FND_API.g_false,
1151: p_count => x_msg_count,
1152: p_data => x_msg_data
1153: );
1154:

Line 1194: return FND_API.g_false;

1190: THEN l_foreign_table := 'AMS_CAMPAIGN_SCHEDULES_B';
1191: l_foreign_table_id := 'SCHEDULE_ID';
1192: ELSE
1193:
1194: return FND_API.g_false;
1195: END IF;
1196: -- call fk utility to check master....will call again later to check for using..
1197:
1198: IF AMS_Utility_PVT.check_fk_exists(

Line 1202: ) = FND_API.g_false

1198: IF AMS_Utility_PVT.check_fk_exists(
1199: l_foreign_table,
1200: l_foreign_table_id,
1201: p_master_id
1202: ) = FND_API.g_false
1203: THEN
1204: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1205: THEN
1206: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_INVALID_MASTER_ID');

Line 1210: return FND_API.g_false;

1206: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_INVALID_MASTER_ID');
1207: FND_MSG_PUB.add;
1208: END IF;
1209:
1210: return FND_API.g_false;
1211: END IF;
1212:
1213: IF p_using_type = 'EVEH'
1214: THEN l_foreign_table := 'AMS_EVENT_HEADERS_ALL_B';

Line 1231: return FND_API.g_false;

1227: ELSIF p_using_type = 'DELV'
1228: THEN l_foreign_table := 'AMS_DELIVERABLES_ALL_B';
1229: l_foreign_table_id := 'DELIVERABLE_ID';
1230: ELSE
1231: return FND_API.g_false;
1232: END IF;
1233:
1234: IF AMS_Utility_PVT.check_fk_exists(
1235: l_foreign_table,

Line 1238: ) = FND_API.g_false

1234: IF AMS_Utility_PVT.check_fk_exists(
1235: l_foreign_table,
1236: l_foreign_table_id,
1237: p_using_id
1238: ) = FND_API.g_false
1239: THEN
1240: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1241: THEN
1242: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_INVALID_USING_ID');

Line 1246: return FND_API.g_false;

1242: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_INVALID_USING_ID');
1243: FND_MSG_PUB.add;
1244: END IF;
1245:
1246: return FND_API.g_false;
1247: END IF;
1248: return fnd_api.g_true;
1249: END check_association;
1250:

Line 1248: return fnd_api.g_true;

1244: END IF;
1245:
1246: return FND_API.g_false;
1247: END IF;
1248: return fnd_api.g_true;
1249: END check_association;
1250:
1251: ---------------------------------------------------------------------
1252: -- PROCEDURE

Line 1265: x_return_status := FND_API.g_ret_sts_success;

1261: )
1262: IS
1263: BEGIN
1264:
1265: x_return_status := FND_API.g_ret_sts_success;
1266:
1267: ------------------------ user_status_id --------------------------
1268: IF p_association_rec.master_object_id IS NULL THEN
1269: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 1275: x_return_status := FND_API.g_ret_sts_error;

1271: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_NO_MASTER_OBJ_ID');
1272: FND_MSG_PUB.add;
1273: END IF;
1274:
1275: x_return_status := FND_API.g_ret_sts_error;
1276: RETURN;
1277: END IF;
1278:
1279: IF p_association_rec.using_object_id IS NULL THEN

Line 1286: x_return_status := FND_API.g_ret_sts_error;

1282: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_NO_USING_OBJ_ID');
1283: FND_MSG_PUB.add;
1284: END IF;
1285:
1286: x_return_status := FND_API.g_ret_sts_error;
1287: RETURN;
1288: END IF;
1289:
1290: IF p_association_rec.using_object_type IS NULL THEN

Line 1297: x_return_status := FND_API.g_ret_sts_error;

1293: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_NO_USING_OBJ_TYPE');
1294: FND_MSG_PUB.add;
1295: END IF;
1296:
1297: x_return_status := FND_API.g_ret_sts_error;
1298: RETURN;
1299: END IF;
1300:
1301: IF p_association_rec.master_object_type IS NULL THEN

Line 1308: x_return_status := FND_API.g_ret_sts_error;

1304: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_NO_MASTER_OBJ_TYPE');
1305: FND_MSG_PUB.add;
1306: END IF;
1307:
1308: x_return_status := FND_API.g_ret_sts_error;
1309: RETURN;
1310: END IF;
1311:
1312: IF p_association_rec.primary_flag IS NULL THEN

Line 1319: x_return_status := FND_API.g_ret_sts_error;

1315: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_NO_PRIMARY_FLAG');
1316: FND_MSG_PUB.add;
1317: END IF;
1318:
1319: x_return_status := FND_API.g_ret_sts_error;
1320: RETURN;
1321: END IF;
1322:
1323: END check_association_req_items;

Line 1360: x_return_status := FND_API.g_ret_sts_success;

1356:
1357:
1358: BEGIN
1359:
1360: x_return_status := FND_API.g_ret_sts_success;
1361:
1362: -- For create_associations, when association_id is passed in, we need to
1363: -- check if this association_id is unique.
1364: --

Line 1371: ) = FND_API.g_false

1367: THEN
1368: IF AMS_Utility_PVT.check_uniqueness(
1369: 'ams_object_associations',
1370: 'object_association_id = ' || p_association_rec.object_association_id
1371: ) = FND_API.g_false
1372: THEN
1373: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1374: THEN
1375: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_DUPLICATE_ID');

Line 1378: x_return_status := FND_API.g_ret_sts_error;

1374: THEN
1375: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_DUPLICATE_ID');
1376: FND_MSG_PUB.add;
1377: END IF;
1378: x_return_status := FND_API.g_ret_sts_error;
1379: RETURN;
1380: END IF;
1381: END IF;
1382:

Line 1384: AND p_association_rec.using_object_id <> FND_API.g_miss_num

1380: END IF;
1381: END IF;
1382:
1383: IF p_validation_mode = JTF_PLSQL_API.g_create
1384: AND p_association_rec.using_object_id <> FND_API.g_miss_num
1385: AND p_association_rec.master_object_id <> FND_API.g_miss_num
1386: AND p_association_rec.using_object_type <> FND_API.g_miss_char
1387: AND p_association_rec.master_object_type <> FND_API.g_miss_char
1388: THEN

Line 1385: AND p_association_rec.master_object_id <> FND_API.g_miss_num

1381: END IF;
1382:
1383: IF p_validation_mode = JTF_PLSQL_API.g_create
1384: AND p_association_rec.using_object_id <> FND_API.g_miss_num
1385: AND p_association_rec.master_object_id <> FND_API.g_miss_num
1386: AND p_association_rec.using_object_type <> FND_API.g_miss_char
1387: AND p_association_rec.master_object_type <> FND_API.g_miss_char
1388: THEN
1389: OPEN c_check_obj(p_association_rec.using_object_id,p_association_rec.using_object_type,p_association_rec.master_object_id,p_association_rec.master_object_type);

Line 1386: AND p_association_rec.using_object_type <> FND_API.g_miss_char

1382:
1383: IF p_validation_mode = JTF_PLSQL_API.g_create
1384: AND p_association_rec.using_object_id <> FND_API.g_miss_num
1385: AND p_association_rec.master_object_id <> FND_API.g_miss_num
1386: AND p_association_rec.using_object_type <> FND_API.g_miss_char
1387: AND p_association_rec.master_object_type <> FND_API.g_miss_char
1388: THEN
1389: OPEN c_check_obj(p_association_rec.using_object_id,p_association_rec.using_object_type,p_association_rec.master_object_id,p_association_rec.master_object_type);
1390: FETCH c_check_obj INTO l_valid_flag;

Line 1387: AND p_association_rec.master_object_type <> FND_API.g_miss_char

1383: IF p_validation_mode = JTF_PLSQL_API.g_create
1384: AND p_association_rec.using_object_id <> FND_API.g_miss_num
1385: AND p_association_rec.master_object_id <> FND_API.g_miss_num
1386: AND p_association_rec.using_object_type <> FND_API.g_miss_char
1387: AND p_association_rec.master_object_type <> FND_API.g_miss_char
1388: THEN
1389: OPEN c_check_obj(p_association_rec.using_object_id,p_association_rec.using_object_type,p_association_rec.master_object_id,p_association_rec.master_object_type);
1390: FETCH c_check_obj INTO l_valid_flag;
1391: CLOSE c_check_obj;

Line 1399: x_return_status := FND_API.g_ret_sts_error;

1395: THEN
1396: FND_MESSAGE.set_name('AMS','AMS_ACCESS_DUPLICATE_ID');
1397: FND_MSG_PUB.add;
1398: END IF;
1399: x_return_status := FND_API.g_ret_sts_error;
1400: RETURN;
1401: END IF;
1402: END IF;
1403:

Line 1432: x_return_status := FND_API.g_ret_sts_success;

1428: l_additional_where_clause VARCHAR2(4000);
1429:
1430: BEGIN
1431:
1432: x_return_status := FND_API.g_ret_sts_success;
1433:
1434: ----------------------- association to object ------------------------
1435: IF p_association_rec.usage_type <> FND_API.g_miss_char THEN
1436: l_usage_type := p_association_rec.usage_type;

Line 1435: IF p_association_rec.usage_type <> FND_API.g_miss_char THEN

1431:
1432: x_return_status := FND_API.g_ret_sts_success;
1433:
1434: ----------------------- association to object ------------------------
1435: IF p_association_rec.usage_type <> FND_API.g_miss_char THEN
1436: l_usage_type := p_association_rec.usage_type;
1437: IF AMS_Utility_PVT.check_lookup_exists(
1438: p_lookup_type => 'AMS_OBJECT_USAGE_TYPE',
1439: p_lookup_code => p_association_rec.usage_type

Line 1440: ) = FND_API.g_false

1436: l_usage_type := p_association_rec.usage_type;
1437: IF AMS_Utility_PVT.check_lookup_exists(
1438: p_lookup_type => 'AMS_OBJECT_USAGE_TYPE',
1439: p_lookup_code => p_association_rec.usage_type
1440: ) = FND_API.g_false
1441: THEN
1442: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1443: THEN
1444: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_INVALID_USAGE_TYPE');

Line 1446: x_return_status := FND_API.g_ret_sts_error;

1442: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1443: THEN
1444: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_INVALID_USAGE_TYPE');
1445: FND_MSG_PUB.add;
1446: x_return_status := FND_API.g_ret_sts_error;
1447: RETURN;
1448: END IF;
1449: ELSE
1450: /* master and using object lookup and their association with

Line 1454: IF p_association_rec.master_object_type <> FND_API.g_miss_char THEN

1450: /* master and using object lookup and their association with
1451: usage type logic*/
1452: /* check for master object type lookup..*/
1453:
1454: IF p_association_rec.master_object_type <> FND_API.g_miss_char THEN
1455: IF AMS_Utility_PVT.check_lookup_exists(
1456: p_lookup_type => 'AMS_MASTER_OBJECT_TYPE',
1457: p_lookup_code => p_association_rec.master_object_type
1458: ) = FND_API.g_false

Line 1458: ) = FND_API.g_false

1454: IF p_association_rec.master_object_type <> FND_API.g_miss_char THEN
1455: IF AMS_Utility_PVT.check_lookup_exists(
1456: p_lookup_type => 'AMS_MASTER_OBJECT_TYPE',
1457: p_lookup_code => p_association_rec.master_object_type
1458: ) = FND_API.g_false
1459: THEN
1460: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1461: THEN
1462: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_INVALID_MASTER_TYPE');

Line 1464: x_return_status := FND_API.g_ret_sts_error;

1460: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1461: THEN
1462: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_INVALID_MASTER_TYPE');
1463: FND_MSG_PUB.add;
1464: x_return_status := FND_API.g_ret_sts_error;
1465: RETURN;
1466: END IF;
1467: END IF;
1468: END IF;

Line 1471: IF p_association_rec.using_object_type <> FND_API.g_miss_char THEN

1467: END IF;
1468: END IF;
1469:
1470: -- check for using object type lookup..
1471: IF p_association_rec.using_object_type <> FND_API.g_miss_char THEN
1472: IF AMS_Utility_PVT.check_lookup_exists(
1473: p_lookup_type => 'AMS_USING_OBJECT_TYPE',
1474: p_lookup_code => p_association_rec.using_object_type
1475: ) = FND_API.g_false

Line 1475: ) = FND_API.g_false

1471: IF p_association_rec.using_object_type <> FND_API.g_miss_char THEN
1472: IF AMS_Utility_PVT.check_lookup_exists(
1473: p_lookup_type => 'AMS_USING_OBJECT_TYPE',
1474: p_lookup_code => p_association_rec.using_object_type
1475: ) = FND_API.g_false
1476: THEN
1477: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1478: THEN
1479: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_INVALID_USING_TYPE');

Line 1481: x_return_status := FND_API.g_ret_sts_error;

1477: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1478: THEN
1479: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_INVALID_USING_TYPE');
1480: FND_MSG_PUB.add;
1481: x_return_status := FND_API.g_ret_sts_error;
1482: RETURN;
1483: END IF;
1484: END IF;
1485: END IF; /* using obj type*/

Line 1487: IF p_association_rec.master_object_id <> FND_API.g_miss_num THEN

1483: END IF;
1484: END IF;
1485: END IF; /* using obj type*/
1486: ---- check for fk id's....
1487: IF p_association_rec.master_object_id <> FND_API.g_miss_num THEN
1488: l_master_id := p_association_rec.master_object_id;
1489: END IF;
1490:
1491: IF p_association_rec.using_object_id <> FND_API.g_miss_num THEN

Line 1491: IF p_association_rec.using_object_id <> FND_API.g_miss_num THEN

1487: IF p_association_rec.master_object_id <> FND_API.g_miss_num THEN
1488: l_master_id := p_association_rec.master_object_id;
1489: END IF;
1490:
1491: IF p_association_rec.using_object_id <> FND_API.g_miss_num THEN
1492: l_using_id := p_association_rec.using_object_id;
1493: END IF;
1494:
1495: --- check corersponsing fk id's for master and using types..

Line 1496: IF (p_association_rec.master_object_type <> FND_API.g_miss_char

1492: l_using_id := p_association_rec.using_object_id;
1493: END IF;
1494:
1495: --- check corersponsing fk id's for master and using types..
1496: IF (p_association_rec.master_object_type <> FND_API.g_miss_char
1497: AND p_association_rec.using_object_type <> FND_API.g_miss_char) THEN
1498:
1499: l_master_type := p_association_rec.master_object_type;
1500: l_using_type := p_association_rec.using_object_type;

Line 1497: AND p_association_rec.using_object_type <> FND_API.g_miss_char) THEN

1493: END IF;
1494:
1495: --- check corersponsing fk id's for master and using types..
1496: IF (p_association_rec.master_object_type <> FND_API.g_miss_char
1497: AND p_association_rec.using_object_type <> FND_API.g_miss_char) THEN
1498:
1499: l_master_type := p_association_rec.master_object_type;
1500: l_using_type := p_association_rec.using_object_type;
1501:

Line 1502: IF check_association(l_master_type,l_master_id, l_using_type, l_using_id) = FND_API.g_false

1498:
1499: l_master_type := p_association_rec.master_object_type;
1500: l_using_type := p_association_rec.using_object_type;
1501:
1502: IF check_association(l_master_type,l_master_id, l_using_type, l_using_id) = FND_API.g_false
1503: THEN
1504: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1505: THEN
1506: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_INVALID_ASSOCIATION');

Line 1508: x_return_status := FND_API.g_ret_sts_error;

1504: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1505: THEN
1506: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_INVALID_ASSOCIATION');
1507: FND_MSG_PUB.add;
1508: x_return_status := FND_API.g_ret_sts_error;
1509: RETURN;
1510: END IF;
1511: END IF; /* check association */
1512: END IF; /* check id's if types not null*/

Line 1514: END IF; /* usage type lookup not fnd_api.g_miss_char */

1510: END IF;
1511: END IF; /* check association */
1512: END IF; /* check id's if types not null*/
1513: END IF; /* usage type lookup exists */
1514: END IF; /* usage type lookup not fnd_api.g_miss_char */
1515: -------------------------max_cost_currency_code--------------------
1516: l_additional_where_clause := ' enabled_flag '||''''||'Y'||'''';
1517: IF p_association_rec.max_cost_currency_code <> FND_API.g_miss_char
1518: AND p_association_rec.max_cost_currency_code IS NOT NULL THEN

Line 1517: IF p_association_rec.max_cost_currency_code <> FND_API.g_miss_char

1513: END IF; /* usage type lookup exists */
1514: END IF; /* usage type lookup not fnd_api.g_miss_char */
1515: -------------------------max_cost_currency_code--------------------
1516: l_additional_where_clause := ' enabled_flag '||''''||'Y'||'''';
1517: IF p_association_rec.max_cost_currency_code <> FND_API.g_miss_char
1518: AND p_association_rec.max_cost_currency_code IS NOT NULL THEN
1519: IF AMS_Utility_PVT.Check_FK_Exists (
1520: p_table_name => 'FND_CURRENCIES'
1521: ,p_pk_name => 'CURRENCY_CODE'

Line 1525: ) = FND_API.G_FALSE

1521: ,p_pk_name => 'CURRENCY_CODE'
1522: ,p_pk_value => p_association_rec.max_cost_currency_code
1523: ,p_pk_data_type => AMS_Utility_PVT.G_VARCHAR2
1524: ,p_additional_where_clause => l_additional_where_clause
1525: ) = FND_API.G_FALSE
1526: THEN
1527: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1528: THEN
1529: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_BAD_CURRENCY_CODE');

Line 1533: x_return_status := FND_API.g_ret_sts_error;

1529: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_BAD_CURRENCY_CODE');
1530: FND_MSG_PUB.add;
1531: END IF;
1532:
1533: x_return_status := FND_API.g_ret_sts_error;
1534: RETURN;
1535: END IF;
1536: END IF;
1537: -------------------------fulfill_on_type_code--------------------

Line 1539: IF p_association_rec.fulfill_on_type_code <> FND_API.g_miss_char

1535: END IF;
1536: END IF;
1537: -------------------------fulfill_on_type_code--------------------
1538: /**
1539: IF p_association_rec.fulfill_on_type_code <> FND_API.g_miss_char
1540: AND p_association_rec.fulfill_on_type_code IS NOT NULL THEN
1541: IF AMS_Utility_PVT.check_lookup_exists(
1542: p_lookup_type => 'AMS_EVENT_FULFILL_ON',
1543: p_lookup_code => p_association_rec.fulfill_on_type_code

Line 1544: ) = FND_API.g_false

1540: AND p_association_rec.fulfill_on_type_code IS NOT NULL THEN
1541: IF AMS_Utility_PVT.check_lookup_exists(
1542: p_lookup_type => 'AMS_EVENT_FULFILL_ON',
1543: p_lookup_code => p_association_rec.fulfill_on_type_code
1544: ) = FND_API.g_false
1545: THEN
1546: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1547: THEN
1548: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_BAD_FULFILL');

Line 1552: x_return_status := FND_API.g_ret_sts_error;

1548: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_BAD_FULFILL');
1549: FND_MSG_PUB.add;
1550: END IF;
1551:
1552: x_return_status := FND_API.g_ret_sts_error;
1553: RETURN;
1554: END IF;
1555: END IF;
1556: **/

Line 1573: x_return_status := FND_API.g_ret_sts_success;

1569: )
1570: IS
1571: BEGIN
1572:
1573: x_return_status := FND_API.g_ret_sts_success;
1574:
1575: ----------------------- primary_flag ------------------------
1576: IF p_association_rec.primary_flag <> FND_API.g_miss_char
1577: AND p_association_rec.primary_flag IS NOT NULL

Line 1576: IF p_association_rec.primary_flag <> FND_API.g_miss_char

1572:
1573: x_return_status := FND_API.g_ret_sts_success;
1574:
1575: ----------------------- primary_flag ------------------------
1576: IF p_association_rec.primary_flag <> FND_API.g_miss_char
1577: AND p_association_rec.primary_flag IS NOT NULL
1578: THEN
1579: IF AMS_Utility_PVT.is_Y_or_N(p_association_rec.primary_flag) = FND_API.g_false
1580: THEN

Line 1579: IF AMS_Utility_PVT.is_Y_or_N(p_association_rec.primary_flag) = FND_API.g_false

1575: ----------------------- primary_flag ------------------------
1576: IF p_association_rec.primary_flag <> FND_API.g_miss_char
1577: AND p_association_rec.primary_flag IS NOT NULL
1578: THEN
1579: IF AMS_Utility_PVT.is_Y_or_N(p_association_rec.primary_flag) = FND_API.g_false
1580: THEN
1581: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1582: THEN
1583: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_BAD_PRIMARY_FLAG');

Line 1587: x_return_status := FND_API.g_ret_sts_error;

1583: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_BAD_PRIMARY_FLAG');
1584: FND_MSG_PUB.add;
1585: END IF;
1586:
1587: x_return_status := FND_API.g_ret_sts_error;
1588: RETURN;
1589: END IF;
1590: END IF;
1591: ----------------------- cost_frozen_flag ------------------------

Line 1592: IF p_association_rec.cost_frozen_flag <> FND_API.g_miss_char

1588: RETURN;
1589: END IF;
1590: END IF;
1591: ----------------------- cost_frozen_flag ------------------------
1592: IF p_association_rec.cost_frozen_flag <> FND_API.g_miss_char
1593: AND p_association_rec.cost_frozen_flag IS NOT NULL
1594: THEN
1595: IF AMS_Utility_PVT.is_Y_or_N(p_association_rec.cost_frozen_flag) = FND_API.g_false
1596: THEN

Line 1595: IF AMS_Utility_PVT.is_Y_or_N(p_association_rec.cost_frozen_flag) = FND_API.g_false

1591: ----------------------- cost_frozen_flag ------------------------
1592: IF p_association_rec.cost_frozen_flag <> FND_API.g_miss_char
1593: AND p_association_rec.cost_frozen_flag IS NOT NULL
1594: THEN
1595: IF AMS_Utility_PVT.is_Y_or_N(p_association_rec.cost_frozen_flag) = FND_API.g_false
1596: THEN
1597: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1598: THEN
1599: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_BAD_COST_FROZEN_FLAG');

Line 1603: x_return_status := FND_API.g_ret_sts_error;

1599: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_BAD_COST_FROZEN_FLAG');
1600: FND_MSG_PUB.add;
1601: END IF;
1602:
1603: x_return_status := FND_API.g_ret_sts_error;
1604: RETURN;
1605: END IF;
1606: END IF;
1607:

Line 1652: x_return_status := FND_API.g_ret_sts_success;

1648:
1649:
1650: BEGIN
1651:
1652: x_return_status := FND_API.g_ret_sts_success;
1653:
1654:
1655: IF p_association_rec.using_object_type = 'DELV'
1656: THEN

Line 1688: x_return_status := FND_API.g_ret_sts_error;

1684: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1685: THEN
1686: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_INVALID_MASTER_TYPE');
1687: FND_MSG_PUB.add;
1688: x_return_status := FND_API.g_ret_sts_error;
1689: RETURN;
1690: END IF;
1691: END IF;
1692:

Line 1694: AND p_association_rec.quantity_needed_by_date <> FND_API.g_miss_date

1690: END IF;
1691: END IF;
1692:
1693: IF p_association_rec.quantity_needed_by_date IS NOT NULL
1694: AND p_association_rec.quantity_needed_by_date <> FND_API.g_miss_date
1695: THEN
1696: IF p_association_rec.quantity_needed_by_date > l_end_date
1697: THEN
1698: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 1703: x_return_status := FND_API.g_ret_sts_error;

1699: THEN
1700: FND_MESSAGE.set_name('AMS', 'AMS_MASTER_OBJ_INVALID_DATES');
1701: FND_MSG_PUB.add;
1702: END IF;
1703: x_return_status := FND_API.g_ret_sts_error;
1704: RETURN;
1705: END IF;
1706: END IF;
1707:

Line 1731: IF x_return_status <> FND_API.g_ret_sts_success THEN

1727: p_association_rec => p_association_rec,
1728: x_return_status => x_return_status
1729: );
1730:
1731: IF x_return_status <> FND_API.g_ret_sts_success THEN
1732: RETURN;
1733: END IF;
1734:
1735: check_association_uk_items(

Line 1741: IF x_return_status <> FND_API.g_ret_sts_success THEN

1737: p_validation_mode => p_validation_mode,
1738: x_return_status => x_return_status
1739: );
1740:
1741: IF x_return_status <> FND_API.g_ret_sts_success THEN
1742: RETURN;
1743: END IF;
1744:
1745: check_association_lookup_fk(

Line 1750: IF x_return_status <> FND_API.g_ret_sts_success THEN

1746: p_association_rec => p_association_rec,
1747: x_return_status => x_return_status
1748: );
1749:
1750: IF x_return_status <> FND_API.g_ret_sts_success THEN
1751: RETURN;
1752: END IF;
1753:
1754: check_association_flag_items(

Line 1759: IF x_return_status <> FND_API.g_ret_sts_success THEN

1755: p_association_rec => p_association_rec,
1756: x_return_status => x_return_status
1757: );
1758:
1759: IF x_return_status <> FND_API.g_ret_sts_success THEN
1760: RETURN;
1761: END IF;
1762:
1763: END check_association_items;

Line 1778: x_return_status := FND_API.g_ret_sts_success;

1774: )
1775: IS
1776: BEGIN
1777:
1778: x_return_status := FND_API.g_ret_sts_success;
1779:
1780: -- do other record level checkings
1781:
1782: END check_association_record;

Line 1815: RAISE FND_API.g_exc_error;

1811: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1812: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1813: FND_MSG_PUB.add;
1814: END IF;
1815: RAISE FND_API.g_exc_error;
1816: END IF;
1817: CLOSE c_association;
1818:
1819: IF p_association_rec.master_object_type = FND_API.g_miss_char THEN

Line 1819: IF p_association_rec.master_object_type = FND_API.g_miss_char THEN

1815: RAISE FND_API.g_exc_error;
1816: END IF;
1817: CLOSE c_association;
1818:
1819: IF p_association_rec.master_object_type = FND_API.g_miss_char THEN
1820: x_complete_rec.master_object_type := l_association_rec.master_object_type;
1821: END IF;
1822:
1823: IF p_association_rec.master_object_id = FND_API.g_miss_num THEN

Line 1823: IF p_association_rec.master_object_id = FND_API.g_miss_num THEN

1819: IF p_association_rec.master_object_type = FND_API.g_miss_char THEN
1820: x_complete_rec.master_object_type := l_association_rec.master_object_type;
1821: END IF;
1822:
1823: IF p_association_rec.master_object_id = FND_API.g_miss_num THEN
1824: x_complete_rec.master_object_id := l_association_rec.master_object_id;
1825: END IF;
1826:
1827: IF p_association_rec.using_object_type = FND_API.g_miss_char THEN

Line 1827: IF p_association_rec.using_object_type = FND_API.g_miss_char THEN

1823: IF p_association_rec.master_object_id = FND_API.g_miss_num THEN
1824: x_complete_rec.master_object_id := l_association_rec.master_object_id;
1825: END IF;
1826:
1827: IF p_association_rec.using_object_type = FND_API.g_miss_char THEN
1828: x_complete_rec.using_object_type := l_association_rec.using_object_type;
1829: END IF;
1830:
1831: IF p_association_rec.using_object_id = FND_API.g_miss_num THEN

Line 1831: IF p_association_rec.using_object_id = FND_API.g_miss_num THEN

1827: IF p_association_rec.using_object_type = FND_API.g_miss_char THEN
1828: x_complete_rec.using_object_type := l_association_rec.using_object_type;
1829: END IF;
1830:
1831: IF p_association_rec.using_object_id = FND_API.g_miss_num THEN
1832: x_complete_rec.using_object_id := l_association_rec.using_object_id;
1833: END IF;
1834:
1835: IF p_association_rec.usage_type = FND_API.g_miss_char THEN

Line 1835: IF p_association_rec.usage_type = FND_API.g_miss_char THEN

1831: IF p_association_rec.using_object_id = FND_API.g_miss_num THEN
1832: x_complete_rec.using_object_id := l_association_rec.using_object_id;
1833: END IF;
1834:
1835: IF p_association_rec.usage_type = FND_API.g_miss_char THEN
1836: x_complete_rec.usage_type := l_association_rec.usage_type;
1837: END IF;
1838:
1839: IF p_association_rec.quantity_needed = FND_API.g_miss_num THEN

Line 1839: IF p_association_rec.quantity_needed = FND_API.g_miss_num THEN

1835: IF p_association_rec.usage_type = FND_API.g_miss_char THEN
1836: x_complete_rec.usage_type := l_association_rec.usage_type;
1837: END IF;
1838:
1839: IF p_association_rec.quantity_needed = FND_API.g_miss_num THEN
1840: x_complete_rec.quantity_needed := l_association_rec.quantity_needed;
1841: END IF;
1842:
1843: IF p_association_rec.quantity_needed_by_date = FND_API.g_miss_date THEN

Line 1843: IF p_association_rec.quantity_needed_by_date = FND_API.g_miss_date THEN

1839: IF p_association_rec.quantity_needed = FND_API.g_miss_num THEN
1840: x_complete_rec.quantity_needed := l_association_rec.quantity_needed;
1841: END IF;
1842:
1843: IF p_association_rec.quantity_needed_by_date = FND_API.g_miss_date THEN
1844: x_complete_rec.quantity_needed_by_date := l_association_rec.quantity_needed_by_date;
1845: END IF;
1846:
1847: IF p_association_rec.primary_flag = FND_API.g_miss_char THEN

Line 1847: IF p_association_rec.primary_flag = FND_API.g_miss_char THEN

1843: IF p_association_rec.quantity_needed_by_date = FND_API.g_miss_date THEN
1844: x_complete_rec.quantity_needed_by_date := l_association_rec.quantity_needed_by_date;
1845: END IF;
1846:
1847: IF p_association_rec.primary_flag = FND_API.g_miss_char THEN
1848: x_complete_rec.primary_flag := l_association_rec.primary_flag ;
1849: END IF;
1850:
1851: IF p_association_rec.cost_frozen_flag = FND_API.g_miss_char THEN

Line 1851: IF p_association_rec.cost_frozen_flag = FND_API.g_miss_char THEN

1847: IF p_association_rec.primary_flag = FND_API.g_miss_char THEN
1848: x_complete_rec.primary_flag := l_association_rec.primary_flag ;
1849: END IF;
1850:
1851: IF p_association_rec.cost_frozen_flag = FND_API.g_miss_char THEN
1852: x_complete_rec.cost_frozen_flag := l_association_rec.cost_frozen_flag ;
1853: END IF;
1854:
1855: IF p_association_rec.pct_of_cost_to_charge_used_by = FND_API.g_miss_num THEN

Line 1855: IF p_association_rec.pct_of_cost_to_charge_used_by = FND_API.g_miss_num THEN

1851: IF p_association_rec.cost_frozen_flag = FND_API.g_miss_char THEN
1852: x_complete_rec.cost_frozen_flag := l_association_rec.cost_frozen_flag ;
1853: END IF;
1854:
1855: IF p_association_rec.pct_of_cost_to_charge_used_by = FND_API.g_miss_num THEN
1856: x_complete_rec.pct_of_cost_to_charge_used_by := l_association_rec.pct_of_cost_to_charge_used_by ;
1857: END IF;
1858:
1859: IF p_association_rec.max_cost_to_charge_used_by = FND_API.g_miss_num THEN

Line 1859: IF p_association_rec.max_cost_to_charge_used_by = FND_API.g_miss_num THEN

1855: IF p_association_rec.pct_of_cost_to_charge_used_by = FND_API.g_miss_num THEN
1856: x_complete_rec.pct_of_cost_to_charge_used_by := l_association_rec.pct_of_cost_to_charge_used_by ;
1857: END IF;
1858:
1859: IF p_association_rec.max_cost_to_charge_used_by = FND_API.g_miss_num THEN
1860: x_complete_rec.max_cost_to_charge_used_by := l_association_rec.max_cost_to_charge_used_by ;
1861: END IF;
1862:
1863: IF p_association_rec.max_cost_currency_code = FND_API.g_miss_char THEN

Line 1863: IF p_association_rec.max_cost_currency_code = FND_API.g_miss_char THEN

1859: IF p_association_rec.max_cost_to_charge_used_by = FND_API.g_miss_num THEN
1860: x_complete_rec.max_cost_to_charge_used_by := l_association_rec.max_cost_to_charge_used_by ;
1861: END IF;
1862:
1863: IF p_association_rec.max_cost_currency_code = FND_API.g_miss_char THEN
1864: x_complete_rec.max_cost_currency_code := l_association_rec.max_cost_currency_code ;
1865: END IF;
1866:
1867:

Line 1868: IF p_association_rec.metric_class = FND_API.g_miss_char THEN

1864: x_complete_rec.max_cost_currency_code := l_association_rec.max_cost_currency_code ;
1865: END IF;
1866:
1867:
1868: IF p_association_rec.metric_class = FND_API.g_miss_char THEN
1869: x_complete_rec.metric_class := l_association_rec.metric_class ;
1870: END IF;
1871:
1872: IF p_association_rec.content_type = FND_API.g_miss_char THEN

Line 1872: IF p_association_rec.content_type = FND_API.g_miss_char THEN

1868: IF p_association_rec.metric_class = FND_API.g_miss_char THEN
1869: x_complete_rec.metric_class := l_association_rec.metric_class ;
1870: END IF;
1871:
1872: IF p_association_rec.content_type = FND_API.g_miss_char THEN
1873: x_complete_rec.content_type := l_association_rec.content_type ;
1874: END IF;
1875:
1876: IF p_association_rec.sequence_no = FND_API.g_miss_num THEN

Line 1876: IF p_association_rec.sequence_no = FND_API.g_miss_num THEN

1872: IF p_association_rec.content_type = FND_API.g_miss_char THEN
1873: x_complete_rec.content_type := l_association_rec.content_type ;
1874: END IF;
1875:
1876: IF p_association_rec.sequence_no = FND_API.g_miss_num THEN
1877: x_complete_rec.sequence_no := l_association_rec.sequence_no ;
1878: END IF;
1879: END complete_association_rec;
1880: ---------------------------------------------------------------------

Line 1893: x_association_rec.OBJECT_ASSOCIATION_ID := FND_API.g_miss_num;

1889: )
1890: IS
1891: BEGIN
1892:
1893: x_association_rec.OBJECT_ASSOCIATION_ID := FND_API.g_miss_num;
1894: x_association_rec.last_update_date := FND_API.g_miss_date;
1895: x_association_rec.last_updated_by := FND_API.g_miss_num;
1896: x_association_rec.creation_date := FND_API.g_miss_date;
1897: x_association_rec.created_by := FND_API.g_miss_num;

Line 1894: x_association_rec.last_update_date := FND_API.g_miss_date;

1890: IS
1891: BEGIN
1892:
1893: x_association_rec.OBJECT_ASSOCIATION_ID := FND_API.g_miss_num;
1894: x_association_rec.last_update_date := FND_API.g_miss_date;
1895: x_association_rec.last_updated_by := FND_API.g_miss_num;
1896: x_association_rec.creation_date := FND_API.g_miss_date;
1897: x_association_rec.created_by := FND_API.g_miss_num;
1898: x_association_rec.last_update_login := FND_API.g_miss_num;

Line 1895: x_association_rec.last_updated_by := FND_API.g_miss_num;

1891: BEGIN
1892:
1893: x_association_rec.OBJECT_ASSOCIATION_ID := FND_API.g_miss_num;
1894: x_association_rec.last_update_date := FND_API.g_miss_date;
1895: x_association_rec.last_updated_by := FND_API.g_miss_num;
1896: x_association_rec.creation_date := FND_API.g_miss_date;
1897: x_association_rec.created_by := FND_API.g_miss_num;
1898: x_association_rec.last_update_login := FND_API.g_miss_num;
1899: x_association_rec.object_version_number := FND_API.g_miss_num;

Line 1896: x_association_rec.creation_date := FND_API.g_miss_date;

1892:
1893: x_association_rec.OBJECT_ASSOCIATION_ID := FND_API.g_miss_num;
1894: x_association_rec.last_update_date := FND_API.g_miss_date;
1895: x_association_rec.last_updated_by := FND_API.g_miss_num;
1896: x_association_rec.creation_date := FND_API.g_miss_date;
1897: x_association_rec.created_by := FND_API.g_miss_num;
1898: x_association_rec.last_update_login := FND_API.g_miss_num;
1899: x_association_rec.object_version_number := FND_API.g_miss_num;
1900: x_association_rec.MASTER_OBJECT_TYPE := FND_API.g_miss_char;

Line 1897: x_association_rec.created_by := FND_API.g_miss_num;

1893: x_association_rec.OBJECT_ASSOCIATION_ID := FND_API.g_miss_num;
1894: x_association_rec.last_update_date := FND_API.g_miss_date;
1895: x_association_rec.last_updated_by := FND_API.g_miss_num;
1896: x_association_rec.creation_date := FND_API.g_miss_date;
1897: x_association_rec.created_by := FND_API.g_miss_num;
1898: x_association_rec.last_update_login := FND_API.g_miss_num;
1899: x_association_rec.object_version_number := FND_API.g_miss_num;
1900: x_association_rec.MASTER_OBJECT_TYPE := FND_API.g_miss_char;
1901: x_association_rec.MASTER_OBJECT_ID := FND_API.g_miss_num;

Line 1898: x_association_rec.last_update_login := FND_API.g_miss_num;

1894: x_association_rec.last_update_date := FND_API.g_miss_date;
1895: x_association_rec.last_updated_by := FND_API.g_miss_num;
1896: x_association_rec.creation_date := FND_API.g_miss_date;
1897: x_association_rec.created_by := FND_API.g_miss_num;
1898: x_association_rec.last_update_login := FND_API.g_miss_num;
1899: x_association_rec.object_version_number := FND_API.g_miss_num;
1900: x_association_rec.MASTER_OBJECT_TYPE := FND_API.g_miss_char;
1901: x_association_rec.MASTER_OBJECT_ID := FND_API.g_miss_num;
1902: x_association_rec.USING_OBJECT_TYPE := FND_API.g_miss_char;

Line 1899: x_association_rec.object_version_number := FND_API.g_miss_num;

1895: x_association_rec.last_updated_by := FND_API.g_miss_num;
1896: x_association_rec.creation_date := FND_API.g_miss_date;
1897: x_association_rec.created_by := FND_API.g_miss_num;
1898: x_association_rec.last_update_login := FND_API.g_miss_num;
1899: x_association_rec.object_version_number := FND_API.g_miss_num;
1900: x_association_rec.MASTER_OBJECT_TYPE := FND_API.g_miss_char;
1901: x_association_rec.MASTER_OBJECT_ID := FND_API.g_miss_num;
1902: x_association_rec.USING_OBJECT_TYPE := FND_API.g_miss_char;
1903: x_association_rec.USING_OBJECT_ID := FND_API.g_miss_num;

Line 1900: x_association_rec.MASTER_OBJECT_TYPE := FND_API.g_miss_char;

1896: x_association_rec.creation_date := FND_API.g_miss_date;
1897: x_association_rec.created_by := FND_API.g_miss_num;
1898: x_association_rec.last_update_login := FND_API.g_miss_num;
1899: x_association_rec.object_version_number := FND_API.g_miss_num;
1900: x_association_rec.MASTER_OBJECT_TYPE := FND_API.g_miss_char;
1901: x_association_rec.MASTER_OBJECT_ID := FND_API.g_miss_num;
1902: x_association_rec.USING_OBJECT_TYPE := FND_API.g_miss_char;
1903: x_association_rec.USING_OBJECT_ID := FND_API.g_miss_num;
1904: x_association_rec.PRIMARY_FLAG := FND_API.g_miss_char;

Line 1901: x_association_rec.MASTER_OBJECT_ID := FND_API.g_miss_num;

1897: x_association_rec.created_by := FND_API.g_miss_num;
1898: x_association_rec.last_update_login := FND_API.g_miss_num;
1899: x_association_rec.object_version_number := FND_API.g_miss_num;
1900: x_association_rec.MASTER_OBJECT_TYPE := FND_API.g_miss_char;
1901: x_association_rec.MASTER_OBJECT_ID := FND_API.g_miss_num;
1902: x_association_rec.USING_OBJECT_TYPE := FND_API.g_miss_char;
1903: x_association_rec.USING_OBJECT_ID := FND_API.g_miss_num;
1904: x_association_rec.PRIMARY_FLAG := FND_API.g_miss_char;
1905: x_association_rec.USAGE_TYPE := FND_API.g_miss_char;

Line 1902: x_association_rec.USING_OBJECT_TYPE := FND_API.g_miss_char;

1898: x_association_rec.last_update_login := FND_API.g_miss_num;
1899: x_association_rec.object_version_number := FND_API.g_miss_num;
1900: x_association_rec.MASTER_OBJECT_TYPE := FND_API.g_miss_char;
1901: x_association_rec.MASTER_OBJECT_ID := FND_API.g_miss_num;
1902: x_association_rec.USING_OBJECT_TYPE := FND_API.g_miss_char;
1903: x_association_rec.USING_OBJECT_ID := FND_API.g_miss_num;
1904: x_association_rec.PRIMARY_FLAG := FND_API.g_miss_char;
1905: x_association_rec.USAGE_TYPE := FND_API.g_miss_char;
1906: x_association_rec.QUANTITY_NEEDED := FND_API.g_miss_num;

Line 1903: x_association_rec.USING_OBJECT_ID := FND_API.g_miss_num;

1899: x_association_rec.object_version_number := FND_API.g_miss_num;
1900: x_association_rec.MASTER_OBJECT_TYPE := FND_API.g_miss_char;
1901: x_association_rec.MASTER_OBJECT_ID := FND_API.g_miss_num;
1902: x_association_rec.USING_OBJECT_TYPE := FND_API.g_miss_char;
1903: x_association_rec.USING_OBJECT_ID := FND_API.g_miss_num;
1904: x_association_rec.PRIMARY_FLAG := FND_API.g_miss_char;
1905: x_association_rec.USAGE_TYPE := FND_API.g_miss_char;
1906: x_association_rec.QUANTITY_NEEDED := FND_API.g_miss_num;
1907: x_association_rec.QUANTITY_NEEDED_BY_DATE := FND_API.g_miss_date;

Line 1904: x_association_rec.PRIMARY_FLAG := FND_API.g_miss_char;

1900: x_association_rec.MASTER_OBJECT_TYPE := FND_API.g_miss_char;
1901: x_association_rec.MASTER_OBJECT_ID := FND_API.g_miss_num;
1902: x_association_rec.USING_OBJECT_TYPE := FND_API.g_miss_char;
1903: x_association_rec.USING_OBJECT_ID := FND_API.g_miss_num;
1904: x_association_rec.PRIMARY_FLAG := FND_API.g_miss_char;
1905: x_association_rec.USAGE_TYPE := FND_API.g_miss_char;
1906: x_association_rec.QUANTITY_NEEDED := FND_API.g_miss_num;
1907: x_association_rec.QUANTITY_NEEDED_BY_DATE := FND_API.g_miss_date;
1908: x_association_rec.COST_FROZEN_FLAG := FND_API.g_miss_char;

Line 1905: x_association_rec.USAGE_TYPE := FND_API.g_miss_char;

1901: x_association_rec.MASTER_OBJECT_ID := FND_API.g_miss_num;
1902: x_association_rec.USING_OBJECT_TYPE := FND_API.g_miss_char;
1903: x_association_rec.USING_OBJECT_ID := FND_API.g_miss_num;
1904: x_association_rec.PRIMARY_FLAG := FND_API.g_miss_char;
1905: x_association_rec.USAGE_TYPE := FND_API.g_miss_char;
1906: x_association_rec.QUANTITY_NEEDED := FND_API.g_miss_num;
1907: x_association_rec.QUANTITY_NEEDED_BY_DATE := FND_API.g_miss_date;
1908: x_association_rec.COST_FROZEN_FLAG := FND_API.g_miss_char;
1909: x_association_rec.PCT_OF_COST_TO_CHARGE_USED_BY := FND_API.g_miss_num;

Line 1906: x_association_rec.QUANTITY_NEEDED := FND_API.g_miss_num;

1902: x_association_rec.USING_OBJECT_TYPE := FND_API.g_miss_char;
1903: x_association_rec.USING_OBJECT_ID := FND_API.g_miss_num;
1904: x_association_rec.PRIMARY_FLAG := FND_API.g_miss_char;
1905: x_association_rec.USAGE_TYPE := FND_API.g_miss_char;
1906: x_association_rec.QUANTITY_NEEDED := FND_API.g_miss_num;
1907: x_association_rec.QUANTITY_NEEDED_BY_DATE := FND_API.g_miss_date;
1908: x_association_rec.COST_FROZEN_FLAG := FND_API.g_miss_char;
1909: x_association_rec.PCT_OF_COST_TO_CHARGE_USED_BY := FND_API.g_miss_num;
1910: x_association_rec.MAX_COST_TO_CHARGE_USED_BY := FND_API.g_miss_num;

Line 1907: x_association_rec.QUANTITY_NEEDED_BY_DATE := FND_API.g_miss_date;

1903: x_association_rec.USING_OBJECT_ID := FND_API.g_miss_num;
1904: x_association_rec.PRIMARY_FLAG := FND_API.g_miss_char;
1905: x_association_rec.USAGE_TYPE := FND_API.g_miss_char;
1906: x_association_rec.QUANTITY_NEEDED := FND_API.g_miss_num;
1907: x_association_rec.QUANTITY_NEEDED_BY_DATE := FND_API.g_miss_date;
1908: x_association_rec.COST_FROZEN_FLAG := FND_API.g_miss_char;
1909: x_association_rec.PCT_OF_COST_TO_CHARGE_USED_BY := FND_API.g_miss_num;
1910: x_association_rec.MAX_COST_TO_CHARGE_USED_BY := FND_API.g_miss_num;
1911: x_association_rec.MAX_COST_CURRENCY_CODE := FND_API.g_miss_char;

Line 1908: x_association_rec.COST_FROZEN_FLAG := FND_API.g_miss_char;

1904: x_association_rec.PRIMARY_FLAG := FND_API.g_miss_char;
1905: x_association_rec.USAGE_TYPE := FND_API.g_miss_char;
1906: x_association_rec.QUANTITY_NEEDED := FND_API.g_miss_num;
1907: x_association_rec.QUANTITY_NEEDED_BY_DATE := FND_API.g_miss_date;
1908: x_association_rec.COST_FROZEN_FLAG := FND_API.g_miss_char;
1909: x_association_rec.PCT_OF_COST_TO_CHARGE_USED_BY := FND_API.g_miss_num;
1910: x_association_rec.MAX_COST_TO_CHARGE_USED_BY := FND_API.g_miss_num;
1911: x_association_rec.MAX_COST_CURRENCY_CODE := FND_API.g_miss_char;
1912: x_association_rec.METRIC_CLASS := FND_API.g_miss_char;

Line 1909: x_association_rec.PCT_OF_COST_TO_CHARGE_USED_BY := FND_API.g_miss_num;

1905: x_association_rec.USAGE_TYPE := FND_API.g_miss_char;
1906: x_association_rec.QUANTITY_NEEDED := FND_API.g_miss_num;
1907: x_association_rec.QUANTITY_NEEDED_BY_DATE := FND_API.g_miss_date;
1908: x_association_rec.COST_FROZEN_FLAG := FND_API.g_miss_char;
1909: x_association_rec.PCT_OF_COST_TO_CHARGE_USED_BY := FND_API.g_miss_num;
1910: x_association_rec.MAX_COST_TO_CHARGE_USED_BY := FND_API.g_miss_num;
1911: x_association_rec.MAX_COST_CURRENCY_CODE := FND_API.g_miss_char;
1912: x_association_rec.METRIC_CLASS := FND_API.g_miss_char;
1913: x_association_rec.FULFILL_ON_TYPE_CODE := FND_API.g_miss_char;

Line 1910: x_association_rec.MAX_COST_TO_CHARGE_USED_BY := FND_API.g_miss_num;

1906: x_association_rec.QUANTITY_NEEDED := FND_API.g_miss_num;
1907: x_association_rec.QUANTITY_NEEDED_BY_DATE := FND_API.g_miss_date;
1908: x_association_rec.COST_FROZEN_FLAG := FND_API.g_miss_char;
1909: x_association_rec.PCT_OF_COST_TO_CHARGE_USED_BY := FND_API.g_miss_num;
1910: x_association_rec.MAX_COST_TO_CHARGE_USED_BY := FND_API.g_miss_num;
1911: x_association_rec.MAX_COST_CURRENCY_CODE := FND_API.g_miss_char;
1912: x_association_rec.METRIC_CLASS := FND_API.g_miss_char;
1913: x_association_rec.FULFILL_ON_TYPE_CODE := FND_API.g_miss_char;
1914: x_association_rec.attribute1 := FND_API.g_miss_char;

Line 1911: x_association_rec.MAX_COST_CURRENCY_CODE := FND_API.g_miss_char;

1907: x_association_rec.QUANTITY_NEEDED_BY_DATE := FND_API.g_miss_date;
1908: x_association_rec.COST_FROZEN_FLAG := FND_API.g_miss_char;
1909: x_association_rec.PCT_OF_COST_TO_CHARGE_USED_BY := FND_API.g_miss_num;
1910: x_association_rec.MAX_COST_TO_CHARGE_USED_BY := FND_API.g_miss_num;
1911: x_association_rec.MAX_COST_CURRENCY_CODE := FND_API.g_miss_char;
1912: x_association_rec.METRIC_CLASS := FND_API.g_miss_char;
1913: x_association_rec.FULFILL_ON_TYPE_CODE := FND_API.g_miss_char;
1914: x_association_rec.attribute1 := FND_API.g_miss_char;
1915: x_association_rec.attribute2 := FND_API.g_miss_char;

Line 1912: x_association_rec.METRIC_CLASS := FND_API.g_miss_char;

1908: x_association_rec.COST_FROZEN_FLAG := FND_API.g_miss_char;
1909: x_association_rec.PCT_OF_COST_TO_CHARGE_USED_BY := FND_API.g_miss_num;
1910: x_association_rec.MAX_COST_TO_CHARGE_USED_BY := FND_API.g_miss_num;
1911: x_association_rec.MAX_COST_CURRENCY_CODE := FND_API.g_miss_char;
1912: x_association_rec.METRIC_CLASS := FND_API.g_miss_char;
1913: x_association_rec.FULFILL_ON_TYPE_CODE := FND_API.g_miss_char;
1914: x_association_rec.attribute1 := FND_API.g_miss_char;
1915: x_association_rec.attribute2 := FND_API.g_miss_char;
1916: x_association_rec.attribute3 := FND_API.g_miss_char;

Line 1913: x_association_rec.FULFILL_ON_TYPE_CODE := FND_API.g_miss_char;

1909: x_association_rec.PCT_OF_COST_TO_CHARGE_USED_BY := FND_API.g_miss_num;
1910: x_association_rec.MAX_COST_TO_CHARGE_USED_BY := FND_API.g_miss_num;
1911: x_association_rec.MAX_COST_CURRENCY_CODE := FND_API.g_miss_char;
1912: x_association_rec.METRIC_CLASS := FND_API.g_miss_char;
1913: x_association_rec.FULFILL_ON_TYPE_CODE := FND_API.g_miss_char;
1914: x_association_rec.attribute1 := FND_API.g_miss_char;
1915: x_association_rec.attribute2 := FND_API.g_miss_char;
1916: x_association_rec.attribute3 := FND_API.g_miss_char;
1917: x_association_rec.attribute4 := FND_API.g_miss_char;

Line 1914: x_association_rec.attribute1 := FND_API.g_miss_char;

1910: x_association_rec.MAX_COST_TO_CHARGE_USED_BY := FND_API.g_miss_num;
1911: x_association_rec.MAX_COST_CURRENCY_CODE := FND_API.g_miss_char;
1912: x_association_rec.METRIC_CLASS := FND_API.g_miss_char;
1913: x_association_rec.FULFILL_ON_TYPE_CODE := FND_API.g_miss_char;
1914: x_association_rec.attribute1 := FND_API.g_miss_char;
1915: x_association_rec.attribute2 := FND_API.g_miss_char;
1916: x_association_rec.attribute3 := FND_API.g_miss_char;
1917: x_association_rec.attribute4 := FND_API.g_miss_char;
1918: x_association_rec.attribute5 := FND_API.g_miss_char;

Line 1915: x_association_rec.attribute2 := FND_API.g_miss_char;

1911: x_association_rec.MAX_COST_CURRENCY_CODE := FND_API.g_miss_char;
1912: x_association_rec.METRIC_CLASS := FND_API.g_miss_char;
1913: x_association_rec.FULFILL_ON_TYPE_CODE := FND_API.g_miss_char;
1914: x_association_rec.attribute1 := FND_API.g_miss_char;
1915: x_association_rec.attribute2 := FND_API.g_miss_char;
1916: x_association_rec.attribute3 := FND_API.g_miss_char;
1917: x_association_rec.attribute4 := FND_API.g_miss_char;
1918: x_association_rec.attribute5 := FND_API.g_miss_char;
1919: x_association_rec.attribute6 := FND_API.g_miss_char;

Line 1916: x_association_rec.attribute3 := FND_API.g_miss_char;

1912: x_association_rec.METRIC_CLASS := FND_API.g_miss_char;
1913: x_association_rec.FULFILL_ON_TYPE_CODE := FND_API.g_miss_char;
1914: x_association_rec.attribute1 := FND_API.g_miss_char;
1915: x_association_rec.attribute2 := FND_API.g_miss_char;
1916: x_association_rec.attribute3 := FND_API.g_miss_char;
1917: x_association_rec.attribute4 := FND_API.g_miss_char;
1918: x_association_rec.attribute5 := FND_API.g_miss_char;
1919: x_association_rec.attribute6 := FND_API.g_miss_char;
1920: x_association_rec.attribute7 := FND_API.g_miss_char;

Line 1917: x_association_rec.attribute4 := FND_API.g_miss_char;

1913: x_association_rec.FULFILL_ON_TYPE_CODE := FND_API.g_miss_char;
1914: x_association_rec.attribute1 := FND_API.g_miss_char;
1915: x_association_rec.attribute2 := FND_API.g_miss_char;
1916: x_association_rec.attribute3 := FND_API.g_miss_char;
1917: x_association_rec.attribute4 := FND_API.g_miss_char;
1918: x_association_rec.attribute5 := FND_API.g_miss_char;
1919: x_association_rec.attribute6 := FND_API.g_miss_char;
1920: x_association_rec.attribute7 := FND_API.g_miss_char;
1921: x_association_rec.attribute8 := FND_API.g_miss_char;

Line 1918: x_association_rec.attribute5 := FND_API.g_miss_char;

1914: x_association_rec.attribute1 := FND_API.g_miss_char;
1915: x_association_rec.attribute2 := FND_API.g_miss_char;
1916: x_association_rec.attribute3 := FND_API.g_miss_char;
1917: x_association_rec.attribute4 := FND_API.g_miss_char;
1918: x_association_rec.attribute5 := FND_API.g_miss_char;
1919: x_association_rec.attribute6 := FND_API.g_miss_char;
1920: x_association_rec.attribute7 := FND_API.g_miss_char;
1921: x_association_rec.attribute8 := FND_API.g_miss_char;
1922: x_association_rec.attribute9 := FND_API.g_miss_char;

Line 1919: x_association_rec.attribute6 := FND_API.g_miss_char;

1915: x_association_rec.attribute2 := FND_API.g_miss_char;
1916: x_association_rec.attribute3 := FND_API.g_miss_char;
1917: x_association_rec.attribute4 := FND_API.g_miss_char;
1918: x_association_rec.attribute5 := FND_API.g_miss_char;
1919: x_association_rec.attribute6 := FND_API.g_miss_char;
1920: x_association_rec.attribute7 := FND_API.g_miss_char;
1921: x_association_rec.attribute8 := FND_API.g_miss_char;
1922: x_association_rec.attribute9 := FND_API.g_miss_char;
1923: x_association_rec.attribute10 := FND_API.g_miss_char;

Line 1920: x_association_rec.attribute7 := FND_API.g_miss_char;

1916: x_association_rec.attribute3 := FND_API.g_miss_char;
1917: x_association_rec.attribute4 := FND_API.g_miss_char;
1918: x_association_rec.attribute5 := FND_API.g_miss_char;
1919: x_association_rec.attribute6 := FND_API.g_miss_char;
1920: x_association_rec.attribute7 := FND_API.g_miss_char;
1921: x_association_rec.attribute8 := FND_API.g_miss_char;
1922: x_association_rec.attribute9 := FND_API.g_miss_char;
1923: x_association_rec.attribute10 := FND_API.g_miss_char;
1924: x_association_rec.attribute11 := FND_API.g_miss_char;

Line 1921: x_association_rec.attribute8 := FND_API.g_miss_char;

1917: x_association_rec.attribute4 := FND_API.g_miss_char;
1918: x_association_rec.attribute5 := FND_API.g_miss_char;
1919: x_association_rec.attribute6 := FND_API.g_miss_char;
1920: x_association_rec.attribute7 := FND_API.g_miss_char;
1921: x_association_rec.attribute8 := FND_API.g_miss_char;
1922: x_association_rec.attribute9 := FND_API.g_miss_char;
1923: x_association_rec.attribute10 := FND_API.g_miss_char;
1924: x_association_rec.attribute11 := FND_API.g_miss_char;
1925: x_association_rec.attribute12 := FND_API.g_miss_char;

Line 1922: x_association_rec.attribute9 := FND_API.g_miss_char;

1918: x_association_rec.attribute5 := FND_API.g_miss_char;
1919: x_association_rec.attribute6 := FND_API.g_miss_char;
1920: x_association_rec.attribute7 := FND_API.g_miss_char;
1921: x_association_rec.attribute8 := FND_API.g_miss_char;
1922: x_association_rec.attribute9 := FND_API.g_miss_char;
1923: x_association_rec.attribute10 := FND_API.g_miss_char;
1924: x_association_rec.attribute11 := FND_API.g_miss_char;
1925: x_association_rec.attribute12 := FND_API.g_miss_char;
1926: x_association_rec.attribute13 := FND_API.g_miss_char;

Line 1923: x_association_rec.attribute10 := FND_API.g_miss_char;

1919: x_association_rec.attribute6 := FND_API.g_miss_char;
1920: x_association_rec.attribute7 := FND_API.g_miss_char;
1921: x_association_rec.attribute8 := FND_API.g_miss_char;
1922: x_association_rec.attribute9 := FND_API.g_miss_char;
1923: x_association_rec.attribute10 := FND_API.g_miss_char;
1924: x_association_rec.attribute11 := FND_API.g_miss_char;
1925: x_association_rec.attribute12 := FND_API.g_miss_char;
1926: x_association_rec.attribute13 := FND_API.g_miss_char;
1927: x_association_rec.attribute14 := FND_API.g_miss_char;

Line 1924: x_association_rec.attribute11 := FND_API.g_miss_char;

1920: x_association_rec.attribute7 := FND_API.g_miss_char;
1921: x_association_rec.attribute8 := FND_API.g_miss_char;
1922: x_association_rec.attribute9 := FND_API.g_miss_char;
1923: x_association_rec.attribute10 := FND_API.g_miss_char;
1924: x_association_rec.attribute11 := FND_API.g_miss_char;
1925: x_association_rec.attribute12 := FND_API.g_miss_char;
1926: x_association_rec.attribute13 := FND_API.g_miss_char;
1927: x_association_rec.attribute14 := FND_API.g_miss_char;
1928: x_association_rec.attribute15 := FND_API.g_miss_char;

Line 1925: x_association_rec.attribute12 := FND_API.g_miss_char;

1921: x_association_rec.attribute8 := FND_API.g_miss_char;
1922: x_association_rec.attribute9 := FND_API.g_miss_char;
1923: x_association_rec.attribute10 := FND_API.g_miss_char;
1924: x_association_rec.attribute11 := FND_API.g_miss_char;
1925: x_association_rec.attribute12 := FND_API.g_miss_char;
1926: x_association_rec.attribute13 := FND_API.g_miss_char;
1927: x_association_rec.attribute14 := FND_API.g_miss_char;
1928: x_association_rec.attribute15 := FND_API.g_miss_char;
1929: x_association_rec.content_type := FND_API.g_miss_char;

Line 1926: x_association_rec.attribute13 := FND_API.g_miss_char;

1922: x_association_rec.attribute9 := FND_API.g_miss_char;
1923: x_association_rec.attribute10 := FND_API.g_miss_char;
1924: x_association_rec.attribute11 := FND_API.g_miss_char;
1925: x_association_rec.attribute12 := FND_API.g_miss_char;
1926: x_association_rec.attribute13 := FND_API.g_miss_char;
1927: x_association_rec.attribute14 := FND_API.g_miss_char;
1928: x_association_rec.attribute15 := FND_API.g_miss_char;
1929: x_association_rec.content_type := FND_API.g_miss_char;
1930: x_association_rec.sequence_no := FND_API.g_miss_num;

Line 1927: x_association_rec.attribute14 := FND_API.g_miss_char;

1923: x_association_rec.attribute10 := FND_API.g_miss_char;
1924: x_association_rec.attribute11 := FND_API.g_miss_char;
1925: x_association_rec.attribute12 := FND_API.g_miss_char;
1926: x_association_rec.attribute13 := FND_API.g_miss_char;
1927: x_association_rec.attribute14 := FND_API.g_miss_char;
1928: x_association_rec.attribute15 := FND_API.g_miss_char;
1929: x_association_rec.content_type := FND_API.g_miss_char;
1930: x_association_rec.sequence_no := FND_API.g_miss_num;
1931: END init_association_rec;

Line 1928: x_association_rec.attribute15 := FND_API.g_miss_char;

1924: x_association_rec.attribute11 := FND_API.g_miss_char;
1925: x_association_rec.attribute12 := FND_API.g_miss_char;
1926: x_association_rec.attribute13 := FND_API.g_miss_char;
1927: x_association_rec.attribute14 := FND_API.g_miss_char;
1928: x_association_rec.attribute15 := FND_API.g_miss_char;
1929: x_association_rec.content_type := FND_API.g_miss_char;
1930: x_association_rec.sequence_no := FND_API.g_miss_num;
1931: END init_association_rec;
1932:

Line 1929: x_association_rec.content_type := FND_API.g_miss_char;

1925: x_association_rec.attribute12 := FND_API.g_miss_char;
1926: x_association_rec.attribute13 := FND_API.g_miss_char;
1927: x_association_rec.attribute14 := FND_API.g_miss_char;
1928: x_association_rec.attribute15 := FND_API.g_miss_char;
1929: x_association_rec.content_type := FND_API.g_miss_char;
1930: x_association_rec.sequence_no := FND_API.g_miss_num;
1931: END init_association_rec;
1932:
1933: END AMS_Associations_PVT;

Line 1930: x_association_rec.sequence_no := FND_API.g_miss_num;

1926: x_association_rec.attribute13 := FND_API.g_miss_char;
1927: x_association_rec.attribute14 := FND_API.g_miss_char;
1928: x_association_rec.attribute15 := FND_API.g_miss_char;
1929: x_association_rec.content_type := FND_API.g_miss_char;
1930: x_association_rec.sequence_no := FND_API.g_miss_num;
1931: END init_association_rec;
1932:
1933: END AMS_Associations_PVT;