DBA Data[Home] [Help]

APPS.PNT_LOCATIONS_PKG dependencies on APP_EXCEPTION

Line 594: APP_EXCEPTION.Raise_Exception;

590: );
591:
592: IF not(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
593: x_return_status := FND_API.G_RET_STS_ERROR;
594: APP_EXCEPTION.Raise_Exception;
595: END IF;
596:
597: -- Added redwin Fix for Bug 2722698
598:

Line 610: APP_EXCEPTION.Raise_Exception;

606: x_return_message => x_return_message);
607:
608: IF NOT ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
609: x_return_status := FND_API.G_RET_STS_ERROR;
610: APP_EXCEPTION.Raise_Exception;
611: END IF;
612:
613: END IF; -- if p_validate
614:

Line 626: APP_EXCEPTION.Raise_Exception;

622: OPEN LOCATION_CURSOR_OLD;
623: FETCH location_cursor_old INTO G_LOC_RECINFO;
624: IF (location_cursor_old%NOTFOUND) THEN
625: CLOSE location_cursor_old;
626: APP_EXCEPTION.Raise_Exception;
627: END IF;
628: CLOSE LOCATION_CURSOR_OLD;
629:
630: END IF;

Line 651: APP_EXCEPTION.Raise_Exception;

647: x_return_message => x_return_message);
648:
649: IF NOT ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
650: x_return_status := FND_API.G_RET_STS_ERROR;
651: APP_EXCEPTION.Raise_Exception;
652: END IF;
653:
654: END IF;
655:

Line 683: APP_EXCEPTION.Raise_Exception;

679: IF NOT ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
680: pnp_debug_pkg.debug(' CorUpdRow> Error in check_location_overlap');
681: pnp_debug_pkg.put_log_msg(' CorUpdRow> Error :Calling check_location_overlap');
682: x_return_status := FND_API.G_RET_STS_ERROR;
683: APP_EXCEPTION.Raise_Exception;
684: END IF;
685:
686: IF p_pn_locations_rec.location_type_lookup_code NOT IN ('OFFICE', 'SECTION') THEN
687: pnp_debug_pkg.put_log_msg('Calling check_location_gaps');

Line 703: APP_EXCEPTION.Raise_Exception;

699:
700: IF NOT ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
701: pnp_debug_pkg.put_log_msg('Error Calling check_location_gaps');
702: x_return_status := FND_API.G_RET_STS_ERROR;
703: APP_EXCEPTION.Raise_Exception;
704: END IF;
705:
706: END IF;
707:

Line 725: APP_EXCEPTION.Raise_Exception;

721: );
722:
723: IF NOT ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
724: x_return_status := FND_API.G_RET_STS_ERROR;
725: APP_EXCEPTION.Raise_Exception;
726: END IF;
727:
728: IF p_pn_locations_rec.location_type_lookup_code NOT IN ('OFFICE', 'SECTION') AND
729: LTRIM(RTRIM(p_cascade)) IS NOT NULL THEN

Line 773: APP_EXCEPTION.Raise_Exception;

769: );
770:
771: IF NOT ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
772: x_return_status := FND_API.G_RET_STS_ERROR;
773: APP_EXCEPTION.Raise_Exception;
774: END IF;
775:
776: pnp_debug_pkg.put_log_msg('Calling UPDATE ROW.');
777:

Line 796: APP_EXCEPTION.Raise_Exception;

792: );
793:
794: IF NOT ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
795: x_return_status := FND_API.G_RET_STS_ERROR;
796: APP_EXCEPTION.Raise_Exception;
797: END IF;
798:
799: IF p_pn_locations_rec.location_type_lookup_code NOT IN ('OFFICE', 'SECTION') AND
800: LTRIM(RTRIM(p_cascade)) IS NOT NULL THEN

Line 1318: APP_EXCEPTION.Raise_Exception;

1314: x_active_end_date,
1315: x_org_id);
1316: IF (l_return_status IS NOT NULL) THEN
1317: pnp_debug_pkg.put_log_msg('Error in unique_location_alias');
1318: APP_EXCEPTION.Raise_Exception;
1319: END IF;
1320:
1321: -----------------------------------------------------------------
1322: -- Call CHECK_UNIQUE_LOCATION_CODE to check if the location code

Line 1335: APP_EXCEPTION.Raise_Exception;

1331: ,x_active_end_date
1332: ,x_org_id);
1333: IF (l_return_status IS NOT NULL) THEN
1334: pnp_debug_pkg.put_log_msg('Error in unique_location_code');
1335: APP_EXCEPTION.Raise_Exception;
1336: END IF;
1337:
1338: IF x_location_type_lookup_code IN ('OFFICE', 'SECTION') AND
1339: x_rentable_area IS NOT NULL THEN

Line 1348: app_exception.raise_Exception;

1344: x_active_start_date,
1345: x_active_end_date) THEN
1346:
1347: fnd_message.set_name('PN', 'PN_GROSS_RENTABLE');
1348: app_exception.raise_Exception;
1349: END IF;
1350: END IF;
1351:
1352: -- Check for location overlap in insert row

Line 1371: APP_EXCEPTION.Raise_Exception;

1367: x_return_message => l_return_message);
1368:
1369: IF NOT ( l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1370: pnp_debug_pkg.debug(' InsRow> Error in check_location_overlap ');
1371: APP_EXCEPTION.Raise_Exception;
1372: END IF;
1373:
1374: END IF; -- x_change_mode
1375:

Line 1394: APP_EXCEPTION.Raise_Exception;

1390: x_return_status => l_return_status,
1391: x_return_message => l_return_message);
1392:
1393: IF NOT ( l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1394: APP_EXCEPTION.Raise_Exception;
1395: END IF;
1396:
1397: END IF; -- x_LOCATION_TYPE_LOOKUP_CODE
1398:

Line 1770: app_exception.raise_Exception;

1766: x_active_end_date,
1767: 'UPDATE') THEN
1768:
1769: fnd_message.set_name('PN', 'PN_GROSS_RENTABLE');
1770: app_exception.raise_Exception;
1771: END IF;
1772: END IF;
1773:
1774: IF x_assgn_area_chgd_flag IN ('CORRECT', 'UPDATE') THEN

Line 2041: APP_EXCEPTION.Raise_Exception;

2037: FETCH C INTO G_LOC_RECINFO;
2038: IF (C%NOTFOUND) THEN
2039: CLOSE C;
2040: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
2041: APP_EXCEPTION.Raise_Exception;
2042: ELSE
2043: PNT_LOCATIONS_PKG.SET_ROWID(
2044: p_location_id => x_location_id,
2045: p_active_start_date => x_active_start_date_old,

Line 3640: APP_EXCEPTION.Raise_Exception;

3636: );
3637:
3638: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3639: x_return_status := FND_API.G_RET_STS_ERROR;
3640: APP_EXCEPTION.Raise_Exception;
3641: END IF;
3642:
3643: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Insert_Locn_Row (-) ReturnStatus: '||x_return_status);
3644: END Insert_Locn_Row;