eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_TAX_ASSIGNMENT_V2PUB dependencies on FND_API

Line 23: p_lock_flag IN VARCHAR2 := FND_API.G_FALSE,

19: PROCEDURE do_create_loc_assignment(
20: p_location_id IN NUMBER,
21: x_loc_id OUT NOCOPY NUMBER,
22: x_return_status IN OUT NOCOPY VARCHAR2, /* Changed from OUT NOCOPY to IN OUT*/
23: p_lock_flag IN VARCHAR2 := FND_API.G_FALSE,
24: p_created_by_module IN VARCHAR2,
25: p_application_id IN NUMBER
26: );
27:

Line 37: p_lock_flag IN VARCHAR2 := FND_API.G_TRUE

33: p_do_addr_val IN VARCHAR2,
34: x_addr_val_status OUT NOCOPY VARCHAR2,
35: x_addr_warn_msg OUT NOCOPY VARCHAR2,
36: x_return_status IN OUT NOCOPY VARCHAR2, /* Changed from OUT NOCOPY to IN OUT*/
37: p_lock_flag IN VARCHAR2 := FND_API.G_TRUE
38: );
39:
40: --------------------------------------
41: -- private procedures and functions

Line 137: p_lock_flag IN VARCHAR2 := FND_API.G_FALSE,

133: PROCEDURE do_create_loc_assignment(
134: p_location_id IN NUMBER,
135: x_loc_id OUT NOCOPY NUMBER,
136: x_return_status IN OUT NOCOPY VARCHAR2, /* Changed from OUT NOCOPY to IN OUT*/
137: p_lock_flag IN VARCHAR2 := FND_API.G_FALSE,
138: p_created_by_module IN VARCHAR2,
139: p_application_id IN NUMBER
140: ) IS
141:

Line 183: p_location_id = FND_API.G_MISS_NUM

179:
180: -- check the required fields:
181: IF p_location_id IS NULL
182: OR
183: p_location_id = FND_API.G_MISS_NUM
184: THEN
185: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
186: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_location_id');
187: FND_MSG_PUB.ADD;

Line 188: RAISE FND_API.G_EXC_ERROR;

184: THEN
185: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
186: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_location_id');
187: FND_MSG_PUB.ADD;
188: RAISE FND_API.G_EXC_ERROR;
189: END IF;
190:
191: -- checking whether this location is for Remit-To Address or not
192: BEGIN

Line 285: p_lock_flag IN VARCHAR2 := FND_API.G_TRUE

281: p_do_addr_val IN VARCHAR2,
282: x_addr_val_status OUT NOCOPY VARCHAR2,
283: x_addr_warn_msg OUT NOCOPY VARCHAR2,
284: x_return_status IN OUT NOCOPY VARCHAR2, /* Changed from OUT NOCOPY to IN OUT*/
285: p_lock_flag IN VARCHAR2 := FND_API.G_TRUE
286: ) IS
287:
288: l_is_remit_to_location VARCHAR2(1) := 'N';
289: l_loc_assg_exists VARCHAR2(1) := 'N';

Line 331: p_location_id = FND_API.G_MISS_NUM

327:
328: -- check the required fields:
329: IF p_location_id IS NULL
330: OR
331: p_location_id = FND_API.G_MISS_NUM
332: THEN
333: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
334: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_location_id');
335: FND_MSG_PUB.ADD;

Line 336: RAISE FND_API.G_EXC_ERROR;

332: THEN
333: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
334: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_location_id');
335: FND_MSG_PUB.ADD;
336: RAISE FND_API.G_EXC_ERROR;
337: END IF;
338:
339: BEGIN
340: SELECT DATE_VALIDATED, VALIDATION_STATUS_CODE

Line 350: x_return_status := FND_API.G_RET_STS_ERROR;

346: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
347: FND_MESSAGE.SET_TOKEN('RECORD', 'hz_locations');
348: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_location_id));
349: FND_MSG_PUB.ADD;
350: x_return_status := FND_API.G_RET_STS_ERROR;
351: END;
352:
353: -- raise error if the update location profile option is turned off and
354: -- the address has been validated before

Line 362: RAISE fnd_api.g_exc_error;

358: l_validation_status_code IS NOT NULL)
359: THEN
360: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_NO_UPDATE');
361: FND_MSG_PUB.ADD;
362: RAISE fnd_api.g_exc_error;
363: END IF;
364:
365: -- checking whether this location is for Remit-To Address or not
366: BEGIN

Line 475: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

471: *
472: * ARGUMENTS
473: * IN:
474: * p_init_msg_list Initialize message stack if it is set to
475: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
476: * p_location_id Location ID.
477: * p_lock_flag Lock record or not. Default is FND_API.G_FALSE.
478: * p_created_by_module Module name which creates this record.
479: * p_application_id Application ID which creates this record.

Line 477: * p_lock_flag Lock record or not. Default is FND_API.G_FALSE.

473: * IN:
474: * p_init_msg_list Initialize message stack if it is set to
475: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
476: * p_location_id Location ID.
477: * p_lock_flag Lock record or not. Default is FND_API.G_FALSE.
478: * p_created_by_module Module name which creates this record.
479: * p_application_id Application ID which creates this record.
480: * IN/OUT:
481: * OUT:

Line 483: * be FND_API.G_RET_STS_SUCCESS (success),

479: * p_application_id Application ID which creates this record.
480: * IN/OUT:
481: * OUT:
482: * x_return_status Return status after the call. The status can
483: * be FND_API.G_RET_STS_SUCCESS (success),
484: * FND_API.G_RET_STS_ERROR (error),
485: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
486: * x_msg_count Number of messages in message stack.
487: * x_msg_data Message text if x_msg_count is 1.

Line 484: * FND_API.G_RET_STS_ERROR (error),

480: * IN/OUT:
481: * OUT:
482: * x_return_status Return status after the call. The status can
483: * be FND_API.G_RET_STS_SUCCESS (success),
484: * FND_API.G_RET_STS_ERROR (error),
485: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
486: * x_msg_count Number of messages in message stack.
487: * x_msg_data Message text if x_msg_count is 1.
488: * x_loc_id Location assignment ID.

Line 485: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

481: * OUT:
482: * x_return_status Return status after the call. The status can
483: * be FND_API.G_RET_STS_SUCCESS (success),
484: * FND_API.G_RET_STS_ERROR (error),
485: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
486: * x_msg_count Number of messages in message stack.
487: * x_msg_data Message text if x_msg_count is 1.
488: * x_loc_id Location assignment ID.
489: *

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

495: *
496: */
497:
498: PROCEDURE create_loc_assignment(
499: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
500: p_location_id IN NUMBER,
501: p_lock_flag IN VARCHAR2 :=FND_API.G_FALSE,
502: p_created_by_module IN VARCHAR2,
503: p_application_id IN NUMBER,

Line 501: p_lock_flag IN VARCHAR2 :=FND_API.G_FALSE,

497:
498: PROCEDURE create_loc_assignment(
499: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
500: p_location_id IN NUMBER,
501: p_lock_flag IN VARCHAR2 :=FND_API.G_FALSE,
502: p_created_by_module IN VARCHAR2,
503: p_application_id IN NUMBER,
504: x_return_status IN OUT NOCOPY VARCHAR2,
505: x_msg_count OUT NOCOPY NUMBER,

Line 520: IF FND_API.to_Boolean(p_init_msg_list) THEN

516: -- standard start of API savepoint
517: SAVEPOINT create_loc_assignment;
518:
519: -- initialize message list if p_init_msg_list is set to TRUE.
520: IF FND_API.to_Boolean(p_init_msg_list) THEN
521: FND_MSG_PUB.initialize;
522: END IF;
523:
524: -- initialize API return status to success.

Line 525: x_return_status := FND_API.G_RET_STS_SUCCESS;

521: FND_MSG_PUB.initialize;
522: END IF;
523:
524: -- initialize API return status to success.
525: x_return_status := FND_API.G_RET_STS_SUCCESS;
526:
527: -- call to business logic.
528: -- populate loc_id by calling tax package.
529: do_create_loc_assignment( p_location_id,

Line 536: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

532: p_lock_flag,
533: p_created_by_module,
534: p_application_id);
535:
536: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
537: RAISE FND_API.G_EXC_ERROR;
538: END IF;
539:
540: -- standard call to get message count and if count is 1, get message info.

Line 537: RAISE FND_API.G_EXC_ERROR;

533: p_created_by_module,
534: p_application_id);
535:
536: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
537: RAISE FND_API.G_EXC_ERROR;
538: END IF;
539:
540: -- standard call to get message count and if count is 1, get message info.
541: FND_MSG_PUB.Count_And_Get(

Line 542: p_encoded => FND_API.G_FALSE,

538: END IF;
539:
540: -- standard call to get message count and if count is 1, get message info.
541: FND_MSG_PUB.Count_And_Get(
542: p_encoded => FND_API.G_FALSE,
543: p_count => x_msg_count,
544: p_data => x_msg_data);
545:
546: EXCEPTION

Line 547: WHEN FND_API.G_EXC_ERROR THEN

543: p_count => x_msg_count,
544: p_data => x_msg_data);
545:
546: EXCEPTION
547: WHEN FND_API.G_EXC_ERROR THEN
548: ROLLBACK TO create_loc_assignment;
549: x_return_status := FND_API.G_RET_STS_ERROR;
550: FND_MSG_PUB.Count_And_Get(
551: p_encoded => FND_API.G_FALSE,

Line 549: x_return_status := FND_API.G_RET_STS_ERROR;

545:
546: EXCEPTION
547: WHEN FND_API.G_EXC_ERROR THEN
548: ROLLBACK TO create_loc_assignment;
549: x_return_status := FND_API.G_RET_STS_ERROR;
550: FND_MSG_PUB.Count_And_Get(
551: p_encoded => FND_API.G_FALSE,
552: p_count => x_msg_count,
553: p_data => x_msg_data);

Line 551: p_encoded => FND_API.G_FALSE,

547: WHEN FND_API.G_EXC_ERROR THEN
548: ROLLBACK TO create_loc_assignment;
549: x_return_status := FND_API.G_RET_STS_ERROR;
550: FND_MSG_PUB.Count_And_Get(
551: p_encoded => FND_API.G_FALSE,
552: p_count => x_msg_count,
553: p_data => x_msg_data);
554:
555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

551: p_encoded => FND_API.G_FALSE,
552: p_count => x_msg_count,
553: p_data => x_msg_data);
554:
555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
556: ROLLBACK TO create_loc_assignment;
557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
558: FND_MSG_PUB.Count_And_Get(
559: p_encoded => FND_API.G_FALSE,

Line 557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

553: p_data => x_msg_data);
554:
555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
556: ROLLBACK TO create_loc_assignment;
557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
558: FND_MSG_PUB.Count_And_Get(
559: p_encoded => FND_API.G_FALSE,
560: p_count => x_msg_count,
561: p_data => x_msg_data);

Line 559: p_encoded => FND_API.G_FALSE,

555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
556: ROLLBACK TO create_loc_assignment;
557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
558: FND_MSG_PUB.Count_And_Get(
559: p_encoded => FND_API.G_FALSE,
560: p_count => x_msg_count,
561: p_data => x_msg_data);
562:
563: WHEN APP_EXCEPTION THEN

Line 565: x_return_status := FND_API.G_RET_STS_ERROR;

561: p_data => x_msg_data);
562:
563: WHEN APP_EXCEPTION THEN
564: ROLLBACK TO create_loc_assignment;
565: x_return_status := FND_API.G_RET_STS_ERROR;
566: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
567: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
568: FND_MSG_PUB.ADD;
569: FND_MSG_PUB.Count_And_Get(

Line 570: p_encoded => FND_API.G_FALSE,

566: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
567: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
568: FND_MSG_PUB.ADD;
569: FND_MSG_PUB.Count_And_Get(
570: p_encoded => FND_API.G_FALSE,
571: p_count => x_msg_count,
572: p_data => x_msg_data);
573: WHEN OTHERS THEN
574: ROLLBACK TO create_loc_assignment;

Line 575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

571: p_count => x_msg_count,
572: p_data => x_msg_data);
573: WHEN OTHERS THEN
574: ROLLBACK TO create_loc_assignment;
575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
576: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
577: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
578: FND_MSG_PUB.ADD;
579: FND_MSG_PUB.Count_And_Get(

Line 580: p_encoded => FND_API.G_FALSE,

576: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
577: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
578: FND_MSG_PUB.ADD;
579: FND_MSG_PUB.Count_And_Get(
580: p_encoded => FND_API.G_FALSE,
581: p_count => x_msg_count,
582: p_data => x_msg_data);
583:
584: END create_loc_assignment;

Line 597: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

593: *
594: * ARGUMENTS
595: * IN:
596: * p_init_msg_list Initialize message stack if it is set to
597: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
598: * p_location_id Location ID.
599: * p_lock_flag Lock record or not. Default is FND_API.G_TRUE.
600: * p_created_by_module Module name which creates this record.
601: * p_application_id Application ID which creates this record.

Line 599: * p_lock_flag Lock record or not. Default is FND_API.G_TRUE.

595: * IN:
596: * p_init_msg_list Initialize message stack if it is set to
597: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
598: * p_location_id Location ID.
599: * p_lock_flag Lock record or not. Default is FND_API.G_TRUE.
600: * p_created_by_module Module name which creates this record.
601: * p_application_id Application ID which creates this record.
602: * IN/OUT:
603: * OUT:

Line 605: * be FND_API.G_RET_STS_SUCCESS (success),

601: * p_application_id Application ID which creates this record.
602: * IN/OUT:
603: * OUT:
604: * x_return_status Return status after the call. The status can
605: * be FND_API.G_RET_STS_SUCCESS (success),
606: * FND_API.G_RET_STS_ERROR (error),
607: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
608: * x_msg_count Number of messages in message stack.
609: * x_msg_data Message text if x_msg_count is 1.

Line 606: * FND_API.G_RET_STS_ERROR (error),

602: * IN/OUT:
603: * OUT:
604: * x_return_status Return status after the call. The status can
605: * be FND_API.G_RET_STS_SUCCESS (success),
606: * FND_API.G_RET_STS_ERROR (error),
607: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
608: * x_msg_count Number of messages in message stack.
609: * x_msg_data Message text if x_msg_count is 1.
610: * x_loc_id Location assignment ID.

Line 607: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

603: * OUT:
604: * x_return_status Return status after the call. The status can
605: * be FND_API.G_RET_STS_SUCCESS (success),
606: * FND_API.G_RET_STS_ERROR (error),
607: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
608: * x_msg_count Number of messages in message stack.
609: * x_msg_data Message text if x_msg_count is 1.
610: * x_loc_id Location assignment ID.
611: *

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

617: *
618: */
619:
620: PROCEDURE update_loc_assignment(
621: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
622: p_location_id IN NUMBER,
623: p_lock_flag IN VARCHAR2 :=FND_API.G_TRUE,
624: p_created_by_module IN VARCHAR2,
625: p_application_id IN NUMBER,

Line 623: p_lock_flag IN VARCHAR2 :=FND_API.G_TRUE,

619:
620: PROCEDURE update_loc_assignment(
621: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
622: p_location_id IN NUMBER,
623: p_lock_flag IN VARCHAR2 :=FND_API.G_TRUE,
624: p_created_by_module IN VARCHAR2,
625: p_application_id IN NUMBER,
626: x_return_status IN OUT NOCOPY VARCHAR2,
627: x_msg_count OUT NOCOPY NUMBER,

Line 660: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

656: *
657: * ARGUMENTS
658: * IN:
659: * p_init_msg_list Initialize message stack if it is set to
660: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
661: * p_location_id Location ID.
662: * p_lock_flag Lock record or not. Default is FND_API.G_TRUE.
663: * p_created_by_module Module name which creates this record.
664: * p_application_id Application ID which creates this record.

Line 662: * p_lock_flag Lock record or not. Default is FND_API.G_TRUE.

658: * IN:
659: * p_init_msg_list Initialize message stack if it is set to
660: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
661: * p_location_id Location ID.
662: * p_lock_flag Lock record or not. Default is FND_API.G_TRUE.
663: * p_created_by_module Module name which creates this record.
664: * p_application_id Application ID which creates this record.
665: * IN/OUT:
666: * OUT:

Line 668: * be FND_API.G_RET_STS_SUCCESS (success),

664: * p_application_id Application ID which creates this record.
665: * IN/OUT:
666: * OUT:
667: * x_return_status Return status after the call. The status can
668: * be FND_API.G_RET_STS_SUCCESS (success),
669: * FND_API.G_RET_STS_ERROR (error),
670: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
671: * x_msg_count Number of messages in message stack.
672: * x_msg_data Message text if x_msg_count is 1.

Line 669: * FND_API.G_RET_STS_ERROR (error),

665: * IN/OUT:
666: * OUT:
667: * x_return_status Return status after the call. The status can
668: * be FND_API.G_RET_STS_SUCCESS (success),
669: * FND_API.G_RET_STS_ERROR (error),
670: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
671: * x_msg_count Number of messages in message stack.
672: * x_msg_data Message text if x_msg_count is 1.
673: * x_loc_id Location assignment ID.

Line 670: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

666: * OUT:
667: * x_return_status Return status after the call. The status can
668: * be FND_API.G_RET_STS_SUCCESS (success),
669: * FND_API.G_RET_STS_ERROR (error),
670: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
671: * x_msg_count Number of messages in message stack.
672: * x_msg_data Message text if x_msg_count is 1.
673: * x_loc_id Location assignment ID.
674: *

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

680: *
681: */
682:
683: PROCEDURE update_loc_assignment(
684: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
685: p_location_id IN NUMBER,
686: p_lock_flag IN VARCHAR2 :=FND_API.G_TRUE,
687: p_created_by_module IN VARCHAR2,
688: p_application_id IN NUMBER,

Line 686: p_lock_flag IN VARCHAR2 :=FND_API.G_TRUE,

682:
683: PROCEDURE update_loc_assignment(
684: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
685: p_location_id IN NUMBER,
686: p_lock_flag IN VARCHAR2 :=FND_API.G_TRUE,
687: p_created_by_module IN VARCHAR2,
688: p_application_id IN NUMBER,
689: x_return_status IN OUT NOCOPY VARCHAR2,
690: x_msg_count OUT NOCOPY NUMBER,

Line 708: IF FND_API.to_Boolean(p_init_msg_list) THEN

704: -- standard start of API savepoint
705: SAVEPOINT update_loc_assignment;
706:
707: -- initialize message list if p_init_msg_list is set to TRUE.
708: IF FND_API.to_Boolean(p_init_msg_list) THEN
709: FND_MSG_PUB.initialize;
710: END IF;
711:
712: -- initialize API return status to success.

Line 713: x_return_status := FND_API.G_RET_STS_SUCCESS;

709: FND_MSG_PUB.initialize;
710: END IF;
711:
712: -- initialize API return status to success.
713: x_return_status := FND_API.G_RET_STS_SUCCESS;
714:
715: -- call to business logic.
716: -- populate loc_id by calling tax package.
717: do_update_loc_assignment( l_location_id,

Line 724: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

720: l_addr_warn_msg,
721: x_return_status,
722: p_lock_flag);
723:
724: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
725: RAISE FND_API.G_EXC_ERROR;
726: END IF;
727:
728: -- standard call to get message count and if count is 1, get message info.

Line 725: RAISE FND_API.G_EXC_ERROR;

721: x_return_status,
722: p_lock_flag);
723:
724: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
725: RAISE FND_API.G_EXC_ERROR;
726: END IF;
727:
728: -- standard call to get message count and if count is 1, get message info.
729: FND_MSG_PUB.Count_And_Get(

Line 730: p_encoded => FND_API.G_FALSE,

726: END IF;
727:
728: -- standard call to get message count and if count is 1, get message info.
729: FND_MSG_PUB.Count_And_Get(
730: p_encoded => FND_API.G_FALSE,
731: p_count => x_msg_count,
732: p_data => x_msg_data);
733: EXCEPTION
734: WHEN FND_API.G_EXC_ERROR THEN

Line 734: WHEN FND_API.G_EXC_ERROR THEN

730: p_encoded => FND_API.G_FALSE,
731: p_count => x_msg_count,
732: p_data => x_msg_data);
733: EXCEPTION
734: WHEN FND_API.G_EXC_ERROR THEN
735: ROLLBACK TO update_loc_assignment;
736: x_return_status := FND_API.G_RET_STS_ERROR;
737: FND_MSG_PUB.Count_And_Get(
738: p_encoded => FND_API.G_FALSE,

Line 736: x_return_status := FND_API.G_RET_STS_ERROR;

732: p_data => x_msg_data);
733: EXCEPTION
734: WHEN FND_API.G_EXC_ERROR THEN
735: ROLLBACK TO update_loc_assignment;
736: x_return_status := FND_API.G_RET_STS_ERROR;
737: FND_MSG_PUB.Count_And_Get(
738: p_encoded => FND_API.G_FALSE,
739: p_count => x_msg_count,
740: p_data => x_msg_data);

Line 738: p_encoded => FND_API.G_FALSE,

734: WHEN FND_API.G_EXC_ERROR THEN
735: ROLLBACK TO update_loc_assignment;
736: x_return_status := FND_API.G_RET_STS_ERROR;
737: FND_MSG_PUB.Count_And_Get(
738: p_encoded => FND_API.G_FALSE,
739: p_count => x_msg_count,
740: p_data => x_msg_data);
741:
742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

738: p_encoded => FND_API.G_FALSE,
739: p_count => x_msg_count,
740: p_data => x_msg_data);
741:
742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
743: ROLLBACK TO update_loc_assignment;
744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
745: FND_MSG_PUB.Count_And_Get(
746: p_encoded => FND_API.G_FALSE,

Line 744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

740: p_data => x_msg_data);
741:
742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
743: ROLLBACK TO update_loc_assignment;
744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
745: FND_MSG_PUB.Count_And_Get(
746: p_encoded => FND_API.G_FALSE,
747: p_count => x_msg_count,
748: p_data => x_msg_data);

Line 746: p_encoded => FND_API.G_FALSE,

742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
743: ROLLBACK TO update_loc_assignment;
744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
745: FND_MSG_PUB.Count_And_Get(
746: p_encoded => FND_API.G_FALSE,
747: p_count => x_msg_count,
748: p_data => x_msg_data);
749:
750: WHEN APP_EXCEPTION THEN

Line 752: x_return_status := FND_API.G_RET_STS_ERROR;

748: p_data => x_msg_data);
749:
750: WHEN APP_EXCEPTION THEN
751: ROLLBACK TO update_loc_assignment;
752: x_return_status := FND_API.G_RET_STS_ERROR;
753: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
754: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
755: FND_MSG_PUB.ADD;
756: FND_MSG_PUB.Count_And_Get(

Line 757: p_encoded => FND_API.G_FALSE,

753: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
754: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
755: FND_MSG_PUB.ADD;
756: FND_MSG_PUB.Count_And_Get(
757: p_encoded => FND_API.G_FALSE,
758: p_count => x_msg_count,
759: p_data => x_msg_data);
760:
761: WHEN OTHERS THEN

Line 763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

759: p_data => x_msg_data);
760:
761: WHEN OTHERS THEN
762: ROLLBACK TO update_loc_assignment;
763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
764: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
765: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
766: FND_MSG_PUB.ADD;
767: FND_MSG_PUB.Count_And_Get(

Line 768: p_encoded => FND_API.G_FALSE,

764: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
765: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
766: FND_MSG_PUB.ADD;
767: FND_MSG_PUB.Count_And_Get(
768: p_encoded => FND_API.G_FALSE,
769: p_count => x_msg_count,
770: p_data => x_msg_data);
771:
772: END update_loc_assignment;

Line 785: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

781: *
782: * ARGUMENTS
783: * IN:
784: * p_init_msg_list Initialize message stack if it is set to
785: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
786: * p_location_id Location ID.
787: * p_lock_flag Lock record or not. Default is FND_API.G_TRUE.
788: * p_created_by_module Module name which creates this record.
789: * p_application_id Application ID which creates this record.

Line 787: * p_lock_flag Lock record or not. Default is FND_API.G_TRUE.

783: * IN:
784: * p_init_msg_list Initialize message stack if it is set to
785: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
786: * p_location_id Location ID.
787: * p_lock_flag Lock record or not. Default is FND_API.G_TRUE.
788: * p_created_by_module Module name which creates this record.
789: * p_application_id Application ID which creates this record.
790: * IN/OUT:
791: * OUT:

Line 793: * be FND_API.G_RET_STS_SUCCESS (success),

789: * p_application_id Application ID which creates this record.
790: * IN/OUT:
791: * OUT:
792: * x_return_status Return status after the call. The status can
793: * be FND_API.G_RET_STS_SUCCESS (success),
794: * FND_API.G_RET_STS_ERROR (error),
795: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
796: * x_msg_count Number of messages in message stack.
797: * x_msg_data Message text if x_msg_count is 1.

Line 794: * FND_API.G_RET_STS_ERROR (error),

790: * IN/OUT:
791: * OUT:
792: * x_return_status Return status after the call. The status can
793: * be FND_API.G_RET_STS_SUCCESS (success),
794: * FND_API.G_RET_STS_ERROR (error),
795: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
796: * x_msg_count Number of messages in message stack.
797: * x_msg_data Message text if x_msg_count is 1.
798: * x_loc_id Location assignment ID.

Line 795: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

791: * OUT:
792: * x_return_status Return status after the call. The status can
793: * be FND_API.G_RET_STS_SUCCESS (success),
794: * FND_API.G_RET_STS_ERROR (error),
795: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
796: * x_msg_count Number of messages in message stack.
797: * x_msg_data Message text if x_msg_count is 1.
798: * x_loc_id Location assignment ID.
799: *

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

805: *
806: */
807:
808: PROCEDURE update_loc_assignment(
809: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
810: p_location_id IN NUMBER,
811: p_lock_flag IN VARCHAR2 := FND_API.G_TRUE,
812: p_do_addr_val IN VARCHAR2,
813: x_addr_val_status OUT NOCOPY VARCHAR2,

Line 811: p_lock_flag IN VARCHAR2 := FND_API.G_TRUE,

807:
808: PROCEDURE update_loc_assignment(
809: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
810: p_location_id IN NUMBER,
811: p_lock_flag IN VARCHAR2 := FND_API.G_TRUE,
812: p_do_addr_val IN VARCHAR2,
813: x_addr_val_status OUT NOCOPY VARCHAR2,
814: x_addr_warn_msg OUT NOCOPY VARCHAR2,
815: x_return_status IN OUT NOCOPY VARCHAR2,

Line 829: IF FND_API.to_Boolean(p_init_msg_list) THEN

825: -- standard start of API savepoint
826: SAVEPOINT update_loc_assignment;
827:
828: -- initialize message list if p_init_msg_list is set to TRUE.
829: IF FND_API.to_Boolean(p_init_msg_list) THEN
830: FND_MSG_PUB.initialize;
831: END IF;
832:
833: -- initialize API return status to success.

Line 834: x_return_status := FND_API.G_RET_STS_SUCCESS;

830: FND_MSG_PUB.initialize;
831: END IF;
832:
833: -- initialize API return status to success.
834: x_return_status := FND_API.G_RET_STS_SUCCESS;
835:
836: -- call to business logic.
837: -- populate loc_id by calling tax package.
838: do_update_loc_assignment( l_location_id,

Line 845: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

841: x_addr_warn_msg,
842: x_return_status,
843: p_lock_flag);
844:
845: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
846: RAISE FND_API.G_EXC_ERROR;
847: END IF;
848:
849: -- standard call to get message count and if count is 1, get message info.

Line 846: RAISE FND_API.G_EXC_ERROR;

842: x_return_status,
843: p_lock_flag);
844:
845: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
846: RAISE FND_API.G_EXC_ERROR;
847: END IF;
848:
849: -- standard call to get message count and if count is 1, get message info.
850: FND_MSG_PUB.Count_And_Get(

Line 851: p_encoded => FND_API.G_FALSE,

847: END IF;
848:
849: -- standard call to get message count and if count is 1, get message info.
850: FND_MSG_PUB.Count_And_Get(
851: p_encoded => FND_API.G_FALSE,
852: p_count => x_msg_count,
853: p_data => x_msg_data);
854: EXCEPTION
855: WHEN FND_API.G_EXC_ERROR THEN

Line 855: WHEN FND_API.G_EXC_ERROR THEN

851: p_encoded => FND_API.G_FALSE,
852: p_count => x_msg_count,
853: p_data => x_msg_data);
854: EXCEPTION
855: WHEN FND_API.G_EXC_ERROR THEN
856: ROLLBACK TO update_loc_assignment;
857: x_return_status := FND_API.G_RET_STS_ERROR;
858: FND_MSG_PUB.Count_And_Get(
859: p_encoded => FND_API.G_FALSE,

Line 857: x_return_status := FND_API.G_RET_STS_ERROR;

853: p_data => x_msg_data);
854: EXCEPTION
855: WHEN FND_API.G_EXC_ERROR THEN
856: ROLLBACK TO update_loc_assignment;
857: x_return_status := FND_API.G_RET_STS_ERROR;
858: FND_MSG_PUB.Count_And_Get(
859: p_encoded => FND_API.G_FALSE,
860: p_count => x_msg_count,
861: p_data => x_msg_data);

Line 859: p_encoded => FND_API.G_FALSE,

855: WHEN FND_API.G_EXC_ERROR THEN
856: ROLLBACK TO update_loc_assignment;
857: x_return_status := FND_API.G_RET_STS_ERROR;
858: FND_MSG_PUB.Count_And_Get(
859: p_encoded => FND_API.G_FALSE,
860: p_count => x_msg_count,
861: p_data => x_msg_data);
862:
863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

859: p_encoded => FND_API.G_FALSE,
860: p_count => x_msg_count,
861: p_data => x_msg_data);
862:
863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
864: ROLLBACK TO update_loc_assignment;
865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
866: FND_MSG_PUB.Count_And_Get(
867: p_encoded => FND_API.G_FALSE,

Line 865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

861: p_data => x_msg_data);
862:
863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
864: ROLLBACK TO update_loc_assignment;
865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
866: FND_MSG_PUB.Count_And_Get(
867: p_encoded => FND_API.G_FALSE,
868: p_count => x_msg_count,
869: p_data => x_msg_data);

Line 867: p_encoded => FND_API.G_FALSE,

863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
864: ROLLBACK TO update_loc_assignment;
865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
866: FND_MSG_PUB.Count_And_Get(
867: p_encoded => FND_API.G_FALSE,
868: p_count => x_msg_count,
869: p_data => x_msg_data);
870:
871: WHEN APP_EXCEPTION THEN

Line 873: x_return_status := FND_API.G_RET_STS_ERROR;

869: p_data => x_msg_data);
870:
871: WHEN APP_EXCEPTION THEN
872: ROLLBACK TO update_loc_assignment;
873: x_return_status := FND_API.G_RET_STS_ERROR;
874: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
875: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
876: FND_MSG_PUB.ADD;
877: FND_MSG_PUB.Count_And_Get(

Line 878: p_encoded => FND_API.G_FALSE,

874: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
875: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
876: FND_MSG_PUB.ADD;
877: FND_MSG_PUB.Count_And_Get(
878: p_encoded => FND_API.G_FALSE,
879: p_count => x_msg_count,
880: p_data => x_msg_data);
881:
882: WHEN OTHERS THEN

Line 884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

880: p_data => x_msg_data);
881:
882: WHEN OTHERS THEN
883: ROLLBACK TO update_loc_assignment;
884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
885: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
886: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
887: FND_MSG_PUB.ADD;
888: FND_MSG_PUB.Count_And_Get(

Line 889: p_encoded => FND_API.G_FALSE,

885: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
886: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
887: FND_MSG_PUB.ADD;
888: FND_MSG_PUB.Count_And_Get(
889: p_encoded => FND_API.G_FALSE,
890: p_count => x_msg_count,
891: p_data => x_msg_data);
892:
893: END update_loc_assignment;