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 329: p_location_id = FND_API.G_MISS_NUM

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

Line 334: RAISE FND_API.G_EXC_ERROR;

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

Line 348: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 360: RAISE fnd_api.g_exc_error;

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

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

456: *
457: * ARGUMENTS
458: * IN:
459: * p_init_msg_list Initialize message stack if it is set to
460: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
461: * p_location_id Location ID.
462: * p_lock_flag Lock record or not. Default is FND_API.G_FALSE.
463: * p_created_by_module Module name which creates this record.
464: * p_application_id Application ID which creates this record.

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

458: * IN:
459: * p_init_msg_list Initialize message stack if it is set to
460: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
461: * p_location_id Location ID.
462: * p_lock_flag Lock record or not. Default is FND_API.G_FALSE.
463: * p_created_by_module Module name which creates this record.
464: * p_application_id Application ID which creates this record.
465: * IN/OUT:
466: * OUT:

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

464: * p_application_id Application ID which creates this record.
465: * IN/OUT:
466: * OUT:
467: * x_return_status Return status after the call. The status can
468: * be FND_API.G_RET_STS_SUCCESS (success),
469: * FND_API.G_RET_STS_ERROR (error),
470: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
471: * x_msg_count Number of messages in message stack.
472: * x_msg_data Message text if x_msg_count is 1.

Line 469: * FND_API.G_RET_STS_ERROR (error),

465: * IN/OUT:
466: * OUT:
467: * x_return_status Return status after the call. The status can
468: * be FND_API.G_RET_STS_SUCCESS (success),
469: * FND_API.G_RET_STS_ERROR (error),
470: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
471: * x_msg_count Number of messages in message stack.
472: * x_msg_data Message text if x_msg_count is 1.
473: * x_loc_id Location assignment ID.

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

466: * OUT:
467: * x_return_status Return status after the call. The status can
468: * be FND_API.G_RET_STS_SUCCESS (success),
469: * FND_API.G_RET_STS_ERROR (error),
470: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
471: * x_msg_count Number of messages in message stack.
472: * x_msg_data Message text if x_msg_count is 1.
473: * x_loc_id Location assignment ID.
474: *

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

480: *
481: */
482:
483: PROCEDURE create_loc_assignment(
484: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
485: p_location_id IN NUMBER,
486: p_lock_flag IN VARCHAR2 :=FND_API.G_FALSE,
487: p_created_by_module IN VARCHAR2,
488: p_application_id IN NUMBER,

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

482:
483: PROCEDURE create_loc_assignment(
484: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
485: p_location_id IN NUMBER,
486: p_lock_flag IN VARCHAR2 :=FND_API.G_FALSE,
487: p_created_by_module IN VARCHAR2,
488: p_application_id IN NUMBER,
489: x_return_status IN OUT NOCOPY VARCHAR2,
490: x_msg_count OUT NOCOPY NUMBER,

Line 505: IF FND_API.to_Boolean(p_init_msg_list) THEN

501: -- standard start of API savepoint
502: SAVEPOINT create_loc_assignment;
503:
504: -- initialize message list if p_init_msg_list is set to TRUE.
505: IF FND_API.to_Boolean(p_init_msg_list) THEN
506: FND_MSG_PUB.initialize;
507: END IF;
508:
509: -- initialize API return status to success.

Line 510: x_return_status := FND_API.G_RET_STS_SUCCESS;

506: FND_MSG_PUB.initialize;
507: END IF;
508:
509: -- initialize API return status to success.
510: x_return_status := FND_API.G_RET_STS_SUCCESS;
511:
512: -- call to business logic.
513: -- populate loc_id by calling tax package.
514: do_create_loc_assignment( p_location_id,

Line 521: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

517: p_lock_flag,
518: p_created_by_module,
519: p_application_id);
520:
521: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
522: RAISE FND_API.G_EXC_ERROR;
523: END IF;
524:
525: -- standard call to get message count and if count is 1, get message info.

Line 522: RAISE FND_API.G_EXC_ERROR;

518: p_created_by_module,
519: p_application_id);
520:
521: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
522: RAISE FND_API.G_EXC_ERROR;
523: END IF;
524:
525: -- standard call to get message count and if count is 1, get message info.
526: FND_MSG_PUB.Count_And_Get(

Line 527: p_encoded => FND_API.G_FALSE,

523: END IF;
524:
525: -- standard call to get message count and if count is 1, get message info.
526: FND_MSG_PUB.Count_And_Get(
527: p_encoded => FND_API.G_FALSE,
528: p_count => x_msg_count,
529: p_data => x_msg_data);
530:
531: EXCEPTION

Line 532: WHEN FND_API.G_EXC_ERROR THEN

528: p_count => x_msg_count,
529: p_data => x_msg_data);
530:
531: EXCEPTION
532: WHEN FND_API.G_EXC_ERROR THEN
533: ROLLBACK TO create_loc_assignment;
534: x_return_status := FND_API.G_RET_STS_ERROR;
535: FND_MSG_PUB.Count_And_Get(
536: p_encoded => FND_API.G_FALSE,

Line 534: x_return_status := FND_API.G_RET_STS_ERROR;

530:
531: EXCEPTION
532: WHEN FND_API.G_EXC_ERROR THEN
533: ROLLBACK TO create_loc_assignment;
534: x_return_status := FND_API.G_RET_STS_ERROR;
535: FND_MSG_PUB.Count_And_Get(
536: p_encoded => FND_API.G_FALSE,
537: p_count => x_msg_count,
538: p_data => x_msg_data);

Line 536: p_encoded => FND_API.G_FALSE,

532: WHEN FND_API.G_EXC_ERROR THEN
533: ROLLBACK TO create_loc_assignment;
534: x_return_status := FND_API.G_RET_STS_ERROR;
535: FND_MSG_PUB.Count_And_Get(
536: p_encoded => FND_API.G_FALSE,
537: p_count => x_msg_count,
538: p_data => x_msg_data);
539:
540: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 540: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

536: p_encoded => FND_API.G_FALSE,
537: p_count => x_msg_count,
538: p_data => x_msg_data);
539:
540: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
541: ROLLBACK TO create_loc_assignment;
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543: FND_MSG_PUB.Count_And_Get(
544: p_encoded => FND_API.G_FALSE,

Line 542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

538: p_data => x_msg_data);
539:
540: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
541: ROLLBACK TO create_loc_assignment;
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543: FND_MSG_PUB.Count_And_Get(
544: p_encoded => FND_API.G_FALSE,
545: p_count => x_msg_count,
546: p_data => x_msg_data);

Line 544: p_encoded => FND_API.G_FALSE,

540: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
541: ROLLBACK TO create_loc_assignment;
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543: FND_MSG_PUB.Count_And_Get(
544: p_encoded => FND_API.G_FALSE,
545: p_count => x_msg_count,
546: p_data => x_msg_data);
547:
548: WHEN APP_EXCEPTION THEN

Line 550: x_return_status := FND_API.G_RET_STS_ERROR;

546: p_data => x_msg_data);
547:
548: WHEN APP_EXCEPTION THEN
549: ROLLBACK TO create_loc_assignment;
550: x_return_status := FND_API.G_RET_STS_ERROR;
551: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
552: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
553: FND_MSG_PUB.ADD;
554: FND_MSG_PUB.Count_And_Get(

Line 555: p_encoded => FND_API.G_FALSE,

551: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
552: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
553: FND_MSG_PUB.ADD;
554: FND_MSG_PUB.Count_And_Get(
555: p_encoded => FND_API.G_FALSE,
556: p_count => x_msg_count,
557: p_data => x_msg_data);
558: WHEN OTHERS THEN
559: ROLLBACK TO create_loc_assignment;

Line 560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

556: p_count => x_msg_count,
557: p_data => x_msg_data);
558: WHEN OTHERS THEN
559: ROLLBACK TO create_loc_assignment;
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
561: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
562: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
563: FND_MSG_PUB.ADD;
564: FND_MSG_PUB.Count_And_Get(

Line 565: p_encoded => FND_API.G_FALSE,

561: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
562: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
563: FND_MSG_PUB.ADD;
564: FND_MSG_PUB.Count_And_Get(
565: p_encoded => FND_API.G_FALSE,
566: p_count => x_msg_count,
567: p_data => x_msg_data);
568:
569: END create_loc_assignment;

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

578: *
579: * ARGUMENTS
580: * IN:
581: * p_init_msg_list Initialize message stack if it is set to
582: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
583: * p_location_id Location ID.
584: * p_lock_flag Lock record or not. Default is FND_API.G_TRUE.
585: * p_created_by_module Module name which creates this record.
586: * p_application_id Application ID which creates this record.

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

580: * IN:
581: * p_init_msg_list Initialize message stack if it is set to
582: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
583: * p_location_id Location ID.
584: * p_lock_flag Lock record or not. Default is FND_API.G_TRUE.
585: * p_created_by_module Module name which creates this record.
586: * p_application_id Application ID which creates this record.
587: * IN/OUT:
588: * OUT:

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

586: * p_application_id Application ID which creates this record.
587: * IN/OUT:
588: * OUT:
589: * x_return_status Return status after the call. The status can
590: * be FND_API.G_RET_STS_SUCCESS (success),
591: * FND_API.G_RET_STS_ERROR (error),
592: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
593: * x_msg_count Number of messages in message stack.
594: * x_msg_data Message text if x_msg_count is 1.

Line 591: * FND_API.G_RET_STS_ERROR (error),

587: * IN/OUT:
588: * OUT:
589: * x_return_status Return status after the call. The status can
590: * be FND_API.G_RET_STS_SUCCESS (success),
591: * FND_API.G_RET_STS_ERROR (error),
592: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
593: * x_msg_count Number of messages in message stack.
594: * x_msg_data Message text if x_msg_count is 1.
595: * x_loc_id Location assignment ID.

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

588: * OUT:
589: * x_return_status Return status after the call. The status can
590: * be FND_API.G_RET_STS_SUCCESS (success),
591: * FND_API.G_RET_STS_ERROR (error),
592: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
593: * x_msg_count Number of messages in message stack.
594: * x_msg_data Message text if x_msg_count is 1.
595: * x_loc_id Location assignment ID.
596: *

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

602: *
603: */
604:
605: PROCEDURE update_loc_assignment(
606: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
607: p_location_id IN NUMBER,
608: p_lock_flag IN VARCHAR2 :=FND_API.G_TRUE,
609: p_created_by_module IN VARCHAR2,
610: p_application_id IN NUMBER,

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

604:
605: PROCEDURE update_loc_assignment(
606: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
607: p_location_id IN NUMBER,
608: p_lock_flag IN VARCHAR2 :=FND_API.G_TRUE,
609: p_created_by_module IN VARCHAR2,
610: p_application_id IN NUMBER,
611: x_return_status IN OUT NOCOPY VARCHAR2,
612: x_msg_count OUT NOCOPY NUMBER,

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

641: *
642: * ARGUMENTS
643: * IN:
644: * p_init_msg_list Initialize message stack if it is set to
645: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
646: * p_location_id Location ID.
647: * p_lock_flag Lock record or not. Default is FND_API.G_TRUE.
648: * p_created_by_module Module name which creates this record.
649: * p_application_id Application ID which creates this record.

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

643: * IN:
644: * p_init_msg_list Initialize message stack if it is set to
645: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
646: * p_location_id Location ID.
647: * p_lock_flag Lock record or not. Default is FND_API.G_TRUE.
648: * p_created_by_module Module name which creates this record.
649: * p_application_id Application ID which creates this record.
650: * IN/OUT:
651: * OUT:

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

649: * p_application_id Application ID which creates this record.
650: * IN/OUT:
651: * OUT:
652: * x_return_status Return status after the call. The status can
653: * be FND_API.G_RET_STS_SUCCESS (success),
654: * FND_API.G_RET_STS_ERROR (error),
655: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
656: * x_msg_count Number of messages in message stack.
657: * x_msg_data Message text if x_msg_count is 1.

Line 654: * FND_API.G_RET_STS_ERROR (error),

650: * IN/OUT:
651: * OUT:
652: * x_return_status Return status after the call. The status can
653: * be FND_API.G_RET_STS_SUCCESS (success),
654: * FND_API.G_RET_STS_ERROR (error),
655: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
656: * x_msg_count Number of messages in message stack.
657: * x_msg_data Message text if x_msg_count is 1.
658: * x_loc_id Location assignment ID.

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

651: * OUT:
652: * x_return_status Return status after the call. The status can
653: * be FND_API.G_RET_STS_SUCCESS (success),
654: * FND_API.G_RET_STS_ERROR (error),
655: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
656: * x_msg_count Number of messages in message stack.
657: * x_msg_data Message text if x_msg_count is 1.
658: * x_loc_id Location assignment ID.
659: *

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

665: *
666: */
667:
668: PROCEDURE update_loc_assignment(
669: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
670: p_location_id IN NUMBER,
671: p_lock_flag IN VARCHAR2 :=FND_API.G_TRUE,
672: p_created_by_module IN VARCHAR2,
673: p_application_id IN NUMBER,

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

667:
668: PROCEDURE update_loc_assignment(
669: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
670: p_location_id IN NUMBER,
671: p_lock_flag IN VARCHAR2 :=FND_API.G_TRUE,
672: p_created_by_module IN VARCHAR2,
673: p_application_id IN NUMBER,
674: x_return_status IN OUT NOCOPY VARCHAR2,
675: x_msg_count OUT NOCOPY NUMBER,

Line 693: IF FND_API.to_Boolean(p_init_msg_list) THEN

689: -- standard start of API savepoint
690: SAVEPOINT update_loc_assignment;
691:
692: -- initialize message list if p_init_msg_list is set to TRUE.
693: IF FND_API.to_Boolean(p_init_msg_list) THEN
694: FND_MSG_PUB.initialize;
695: END IF;
696:
697: -- initialize API return status to success.

Line 698: x_return_status := FND_API.G_RET_STS_SUCCESS;

694: FND_MSG_PUB.initialize;
695: END IF;
696:
697: -- initialize API return status to success.
698: x_return_status := FND_API.G_RET_STS_SUCCESS;
699:
700: -- call to business logic.
701: -- populate loc_id by calling tax package.
702: do_update_loc_assignment( l_location_id,

Line 709: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

705: l_addr_warn_msg,
706: x_return_status,
707: p_lock_flag);
708:
709: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
710: RAISE FND_API.G_EXC_ERROR;
711: END IF;
712:
713: -- standard call to get message count and if count is 1, get message info.

Line 710: RAISE FND_API.G_EXC_ERROR;

706: x_return_status,
707: p_lock_flag);
708:
709: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
710: RAISE FND_API.G_EXC_ERROR;
711: END IF;
712:
713: -- standard call to get message count and if count is 1, get message info.
714: FND_MSG_PUB.Count_And_Get(

Line 715: p_encoded => FND_API.G_FALSE,

711: END IF;
712:
713: -- standard call to get message count and if count is 1, get message info.
714: FND_MSG_PUB.Count_And_Get(
715: p_encoded => FND_API.G_FALSE,
716: p_count => x_msg_count,
717: p_data => x_msg_data);
718: EXCEPTION
719: WHEN FND_API.G_EXC_ERROR THEN

Line 719: WHEN FND_API.G_EXC_ERROR THEN

715: p_encoded => FND_API.G_FALSE,
716: p_count => x_msg_count,
717: p_data => x_msg_data);
718: EXCEPTION
719: WHEN FND_API.G_EXC_ERROR THEN
720: ROLLBACK TO update_loc_assignment;
721: x_return_status := FND_API.G_RET_STS_ERROR;
722: FND_MSG_PUB.Count_And_Get(
723: p_encoded => FND_API.G_FALSE,

Line 721: x_return_status := FND_API.G_RET_STS_ERROR;

717: p_data => x_msg_data);
718: EXCEPTION
719: WHEN FND_API.G_EXC_ERROR THEN
720: ROLLBACK TO update_loc_assignment;
721: x_return_status := FND_API.G_RET_STS_ERROR;
722: FND_MSG_PUB.Count_And_Get(
723: p_encoded => FND_API.G_FALSE,
724: p_count => x_msg_count,
725: p_data => x_msg_data);

Line 723: p_encoded => FND_API.G_FALSE,

719: WHEN FND_API.G_EXC_ERROR THEN
720: ROLLBACK TO update_loc_assignment;
721: x_return_status := FND_API.G_RET_STS_ERROR;
722: FND_MSG_PUB.Count_And_Get(
723: p_encoded => FND_API.G_FALSE,
724: p_count => x_msg_count,
725: p_data => x_msg_data);
726:
727: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 727: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

723: p_encoded => FND_API.G_FALSE,
724: p_count => x_msg_count,
725: p_data => x_msg_data);
726:
727: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
728: ROLLBACK TO update_loc_assignment;
729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
730: FND_MSG_PUB.Count_And_Get(
731: p_encoded => FND_API.G_FALSE,

Line 729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

725: p_data => x_msg_data);
726:
727: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
728: ROLLBACK TO update_loc_assignment;
729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
730: FND_MSG_PUB.Count_And_Get(
731: p_encoded => FND_API.G_FALSE,
732: p_count => x_msg_count,
733: p_data => x_msg_data);

Line 731: p_encoded => FND_API.G_FALSE,

727: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
728: ROLLBACK TO update_loc_assignment;
729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
730: FND_MSG_PUB.Count_And_Get(
731: p_encoded => FND_API.G_FALSE,
732: p_count => x_msg_count,
733: p_data => x_msg_data);
734:
735: WHEN APP_EXCEPTION THEN

Line 737: x_return_status := FND_API.G_RET_STS_ERROR;

733: p_data => x_msg_data);
734:
735: WHEN APP_EXCEPTION THEN
736: ROLLBACK TO update_loc_assignment;
737: x_return_status := FND_API.G_RET_STS_ERROR;
738: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
739: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
740: FND_MSG_PUB.ADD;
741: FND_MSG_PUB.Count_And_Get(

Line 742: p_encoded => FND_API.G_FALSE,

738: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
739: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
740: FND_MSG_PUB.ADD;
741: FND_MSG_PUB.Count_And_Get(
742: p_encoded => FND_API.G_FALSE,
743: p_count => x_msg_count,
744: p_data => x_msg_data);
745:
746: WHEN OTHERS THEN

Line 748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

744: p_data => x_msg_data);
745:
746: WHEN OTHERS THEN
747: ROLLBACK TO update_loc_assignment;
748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
749: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
750: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
751: FND_MSG_PUB.ADD;
752: FND_MSG_PUB.Count_And_Get(

Line 753: p_encoded => FND_API.G_FALSE,

749: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
750: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
751: FND_MSG_PUB.ADD;
752: FND_MSG_PUB.Count_And_Get(
753: p_encoded => FND_API.G_FALSE,
754: p_count => x_msg_count,
755: p_data => x_msg_data);
756:
757: END update_loc_assignment;

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

766: *
767: * ARGUMENTS
768: * IN:
769: * p_init_msg_list Initialize message stack if it is set to
770: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
771: * p_location_id Location ID.
772: * p_lock_flag Lock record or not. Default is FND_API.G_TRUE.
773: * p_created_by_module Module name which creates this record.
774: * p_application_id Application ID which creates this record.

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

768: * IN:
769: * p_init_msg_list Initialize message stack if it is set to
770: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
771: * p_location_id Location ID.
772: * p_lock_flag Lock record or not. Default is FND_API.G_TRUE.
773: * p_created_by_module Module name which creates this record.
774: * p_application_id Application ID which creates this record.
775: * IN/OUT:
776: * OUT:

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

774: * p_application_id Application ID which creates this record.
775: * IN/OUT:
776: * OUT:
777: * x_return_status Return status after the call. The status can
778: * be FND_API.G_RET_STS_SUCCESS (success),
779: * FND_API.G_RET_STS_ERROR (error),
780: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
781: * x_msg_count Number of messages in message stack.
782: * x_msg_data Message text if x_msg_count is 1.

Line 779: * FND_API.G_RET_STS_ERROR (error),

775: * IN/OUT:
776: * OUT:
777: * x_return_status Return status after the call. The status can
778: * be FND_API.G_RET_STS_SUCCESS (success),
779: * FND_API.G_RET_STS_ERROR (error),
780: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
781: * x_msg_count Number of messages in message stack.
782: * x_msg_data Message text if x_msg_count is 1.
783: * x_loc_id Location assignment ID.

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

776: * OUT:
777: * x_return_status Return status after the call. The status can
778: * be FND_API.G_RET_STS_SUCCESS (success),
779: * FND_API.G_RET_STS_ERROR (error),
780: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
781: * x_msg_count Number of messages in message stack.
782: * x_msg_data Message text if x_msg_count is 1.
783: * x_loc_id Location assignment ID.
784: *

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

790: *
791: */
792:
793: PROCEDURE update_loc_assignment(
794: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
795: p_location_id IN NUMBER,
796: p_lock_flag IN VARCHAR2 := FND_API.G_TRUE,
797: p_do_addr_val IN VARCHAR2,
798: x_addr_val_status OUT NOCOPY VARCHAR2,

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

792:
793: PROCEDURE update_loc_assignment(
794: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
795: p_location_id IN NUMBER,
796: p_lock_flag IN VARCHAR2 := FND_API.G_TRUE,
797: p_do_addr_val IN VARCHAR2,
798: x_addr_val_status OUT NOCOPY VARCHAR2,
799: x_addr_warn_msg OUT NOCOPY VARCHAR2,
800: x_return_status IN OUT NOCOPY VARCHAR2,

Line 814: IF FND_API.to_Boolean(p_init_msg_list) THEN

810: -- standard start of API savepoint
811: SAVEPOINT update_loc_assignment;
812:
813: -- initialize message list if p_init_msg_list is set to TRUE.
814: IF FND_API.to_Boolean(p_init_msg_list) THEN
815: FND_MSG_PUB.initialize;
816: END IF;
817:
818: -- initialize API return status to success.

Line 819: x_return_status := FND_API.G_RET_STS_SUCCESS;

815: FND_MSG_PUB.initialize;
816: END IF;
817:
818: -- initialize API return status to success.
819: x_return_status := FND_API.G_RET_STS_SUCCESS;
820:
821: -- call to business logic.
822: -- populate loc_id by calling tax package.
823: do_update_loc_assignment( l_location_id,

Line 830: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

826: x_addr_warn_msg,
827: x_return_status,
828: p_lock_flag);
829:
830: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
831: RAISE FND_API.G_EXC_ERROR;
832: END IF;
833:
834: -- standard call to get message count and if count is 1, get message info.

Line 831: RAISE FND_API.G_EXC_ERROR;

827: x_return_status,
828: p_lock_flag);
829:
830: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
831: RAISE FND_API.G_EXC_ERROR;
832: END IF;
833:
834: -- standard call to get message count and if count is 1, get message info.
835: FND_MSG_PUB.Count_And_Get(

Line 836: p_encoded => FND_API.G_FALSE,

832: END IF;
833:
834: -- standard call to get message count and if count is 1, get message info.
835: FND_MSG_PUB.Count_And_Get(
836: p_encoded => FND_API.G_FALSE,
837: p_count => x_msg_count,
838: p_data => x_msg_data);
839: EXCEPTION
840: WHEN FND_API.G_EXC_ERROR THEN

Line 840: WHEN FND_API.G_EXC_ERROR THEN

836: p_encoded => FND_API.G_FALSE,
837: p_count => x_msg_count,
838: p_data => x_msg_data);
839: EXCEPTION
840: WHEN FND_API.G_EXC_ERROR THEN
841: ROLLBACK TO update_loc_assignment;
842: x_return_status := FND_API.G_RET_STS_ERROR;
843: FND_MSG_PUB.Count_And_Get(
844: p_encoded => FND_API.G_FALSE,

Line 842: x_return_status := FND_API.G_RET_STS_ERROR;

838: p_data => x_msg_data);
839: EXCEPTION
840: WHEN FND_API.G_EXC_ERROR THEN
841: ROLLBACK TO update_loc_assignment;
842: x_return_status := FND_API.G_RET_STS_ERROR;
843: FND_MSG_PUB.Count_And_Get(
844: p_encoded => FND_API.G_FALSE,
845: p_count => x_msg_count,
846: p_data => x_msg_data);

Line 844: p_encoded => FND_API.G_FALSE,

840: WHEN FND_API.G_EXC_ERROR THEN
841: ROLLBACK TO update_loc_assignment;
842: x_return_status := FND_API.G_RET_STS_ERROR;
843: FND_MSG_PUB.Count_And_Get(
844: p_encoded => FND_API.G_FALSE,
845: p_count => x_msg_count,
846: p_data => x_msg_data);
847:
848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

844: p_encoded => FND_API.G_FALSE,
845: p_count => x_msg_count,
846: p_data => x_msg_data);
847:
848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
849: ROLLBACK TO update_loc_assignment;
850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
851: FND_MSG_PUB.Count_And_Get(
852: p_encoded => FND_API.G_FALSE,

Line 850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

846: p_data => x_msg_data);
847:
848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
849: ROLLBACK TO update_loc_assignment;
850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
851: FND_MSG_PUB.Count_And_Get(
852: p_encoded => FND_API.G_FALSE,
853: p_count => x_msg_count,
854: p_data => x_msg_data);

Line 852: p_encoded => FND_API.G_FALSE,

848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
849: ROLLBACK TO update_loc_assignment;
850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
851: FND_MSG_PUB.Count_And_Get(
852: p_encoded => FND_API.G_FALSE,
853: p_count => x_msg_count,
854: p_data => x_msg_data);
855:
856: WHEN APP_EXCEPTION THEN

Line 858: x_return_status := FND_API.G_RET_STS_ERROR;

854: p_data => x_msg_data);
855:
856: WHEN APP_EXCEPTION THEN
857: ROLLBACK TO update_loc_assignment;
858: x_return_status := FND_API.G_RET_STS_ERROR;
859: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
860: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
861: FND_MSG_PUB.ADD;
862: FND_MSG_PUB.Count_And_Get(

Line 863: p_encoded => FND_API.G_FALSE,

859: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
860: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
861: FND_MSG_PUB.ADD;
862: FND_MSG_PUB.Count_And_Get(
863: p_encoded => FND_API.G_FALSE,
864: p_count => x_msg_count,
865: p_data => x_msg_data);
866:
867: WHEN OTHERS THEN

Line 869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

865: p_data => x_msg_data);
866:
867: WHEN OTHERS THEN
868: ROLLBACK TO update_loc_assignment;
869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
870: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
871: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
872: FND_MSG_PUB.ADD;
873: FND_MSG_PUB.Count_And_Get(

Line 874: p_encoded => FND_API.G_FALSE,

870: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
871: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
872: FND_MSG_PUB.ADD;
873: FND_MSG_PUB.Count_And_Get(
874: p_encoded => FND_API.G_FALSE,
875: p_count => x_msg_count,
876: p_data => x_msg_data);
877:
878: END update_loc_assignment;